I have a Thing called Requests, which has one column in the database table called Status. The StatusList field is a field type of Status, which comes from a second Thing called Status.
In the Status thing are records like New, Approved, Funded, Rejected, Completed. These records have a field called Order. Where each record is numbered 1,2,3, and so on (e.g. New = 1, Approved = 2, Funded = 3).
I have a repeating group that displays Requests, but I want to limit the requests to those that have a Status with an Order greater than 1 and less than 4.
The issue I’m having is with creating the proper search to only display those Status’.