nroeder
1
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.
![image](https://community.retool.com/uploads/default/original/2X/7/7a6a082035958d43b0d6fbee440d87eb9e3349f6.png)
![image](https://community.retool.com/uploads/default/original/2X/8/815e69fde5a5766516b26bf01b107b965881af32.png)
ScottR
2
please post the code/query etc...it will be more helpful for those wanting to help you ![:slight_smile: :slight_smile:](http://community.retool.com/images/emoji/apple/slight_smile.png?v=12)
nroeder
3
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
4
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...
ScottR
6
You need to populate value
![Screen Shot 2022-09-16 at 11.54.07 AM](https://community.retool.com/uploads/default/original/2X/f/f8172dd462b7bdd891362c48379175c31e7bec24.png)