Hi
Will it possible to filter the data without defining that column in record list means for example i have one column which has Boolean values as Yes or No i have to define that column as filter in Record without defining that column in Record List.
Kindly suggest in this
Discussion posts and replies are publicly visible
Yes, you can do that. But I recommend against, as the user should see what he is doing. This is like searching in a field that is not included in the list.
Thank you for the update Stefan
yeah but user only requesting only to show filter alone and after adding in filter when i try to select the value from filter was getting this error pop up
The field [nonstandard_req_bool] does not exist. (APNX-1-4203-000)
More details please. Can you share the filter config?
I did a quick test. Works, as expected.
Sure below is the configuration i have defined
a!recordFilterList( name:"Non Standard Request", defaultOption: " ", options:{a!recordFilterListOption( id:1, name:"Yes", filter:a!queryFilter( operator:"=", field:"nonstandard_req_bool" ) ), a!recordFilterListOption( id:2, name:"No", filter:a!queryFilter( operator:"=", field:"nonstandard_req_bool" ) ) }
)
Actually in DB values for those fields is as 0 and 1 so i displayed it as YES or NO in filter
Did you try to use the "Guided Configuration"?
Why do you define a queryFilter without a value?
I would expect the field references in the form of "recordType!your_record.fields.your_field".
Thank you for the suggestions Stefan
No i didn't tried to use guided configuration could you please provide any sample example or snippet for the guided configuration
The public Appian documentation is a great resource of knowledge. After searching 3 seconds, I came up with this:
https://docs.appian.com/suite/help/23.2/filter-the-record-list.html#user-filters
Thank you for the documentation will go through it