Skip to main content
H
harrisc0535
March 12, 2021
Question

Is there a way to provide user input into a record filter?

  • March 12, 2021
  • 4 replies
  • 0 views

I am looking for a way to create a range in a record filter. I want to be able to enter in a minimum and maximum value to query by, but that does not seem to be allowed as the options for a filter are only =, <>, or between. Is this a possibility, and if not, do you have any intention to update this in a later release?

4 replies

danny.verb
danny.verb
March 12, 2021

What can of range are you trying to create and what is your business data? Appian already have a great out of the box filter for date ranges.

H
harrisc0535Author
March 12, 2021

We have a field for revenue and we're trying to implement the ability to filter a specific revenue range.

stewart.burchell
stewart.burchell
March 15, 2021

The "between" operator fulfils the "range" you are looking to implement. In your query filter you can identify the "field" you want to filter on, set the "operator" to "between" and set the value to an array of two items. The first will be your lower bound and the second your upper bound.

H
harrisc0535Author
March 15, 2021

We addressed that as a possibility but would prefer to have user input to specify the range instead of preset ranges.

Terms & ConditionsAccessibility statement