How to use UI Builder Data Resource to create a lookup of unique status from table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2025 01:34 PM
I'm new to UI Builder. I would like to know if there is a way to use Data resources to retrieve unique records from a table. There is a string field named "status". I would like to select this field from the table but only care about the unique values... (select distinct status from table1). I want to then use this list to populate a dropdown component. If there is a way to accomplish this can you share. Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2025 11:59 PM
So you are creating a filter, based on that string field, or are you trying to achieve something else?
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2025 08:20 AM
I want to create a filter/dropdown that filters a list on the page. The filter would be derived from selecting unique values from the status field in a customer table... ie (Select distinct status from products). I want to be able to script the id and label from the response for a dropdown or filter.
