Distinct values from sql query for select multiple fields component

[nroeder]

I have a sql query that returns "tags" of photos. I want to populate the select list with unique values

when i run the sql query I get the values.

However when i use {{item.Name}} It returns all the tags and if the tag is blank puts the row number in.

[ScottR]

please post the code/query etc...it will be more helpful for those wanting to help you

[nroeder]

select Photo.PhotoId, PropertyId, Tags, IsPrimaryThumbnail, CreatedDate, UpdatedDate, ImageBytes, Notes, FileName, Url, ThumbnailImageUrl, DisplayImageUrl, OriginalImageUrl, Latitude, Longitude, TimeStamp, DistanceInMeters, IsActive, ArchivedBy, ArchivedDate, CRC, Tag.Name,('https://rrsav2photos.blob.core.windows.net/prod/Properties' + OriginalImageUrl) As 'FullUrl'
From Photo
Left Join PhotoTag on Photo.PhotoId = PhotoTag.PhotoId
Left Join Tag on PhotoTag.TagId = Tag.TagId
Where PropertyId = {{tableProperties.selectedRow.data.PropertyId}}

[ScottR]

How are you calling item.name if name is not within the query itself?
Maybe posting part of the data you get back from that query will help...

[nroeder]

[ScottR]

You need to populate value

[nroeder]

PERFECT! thanks!