How would I filter a repeat control to only show documents with a certain value (e.g. a states 2 character abbreviation). What I would ultimately want to do is have a dropdown or button to select a state and it would refresh the page with the selected states.
Right now I have 3 (nested) repeats setup: 1. State, 2. Agent Code, 3. Agent Details. Everything is displaying properly, but I would like to filter certain states out. The outermost "State" repeat has the following code for data binding:
@Unique(@DbColumn(@DbName(), "AgentView", 3))
Where the number 3 is the third column, Agent State, in the view. Is there a method I can use to only show documents with a certain state value in that column?
Thanks for any help.