Expression-Backed Record - multiple user filters

Question

Hello, 
 I created a expression-backed record with the help of the Appian tutorial : https://docs.appian.com/suite/help/19.3/Service-Backed_Record_Tutorial.html 
 I replaced the facet part by a!recordFilterListOption. It worked well. A filtering list on one of my record fields appeared and my data were filtered by my selection. 
 Now, I would like to have 2 filtering lists in order to have the ability to filtre on 2 fields of my record. 
 Is it possible ? 
 I tried with a code in the User Filters pane that looks like the code below but I got a message error : The User Filters expression failed to evaluate. Details: [Expression evaluation error at function 'localvariables': A variable is incorrectly defined. Parameter: 2. Expected syntax: localvariables(local!a, ..., expr) or localvariables(local!a:10, ..., expr)]. (APNX-1-4205-019) 
 Moreover, is there a wa to bypass the limit of 1 000 char of this pane ? 
 Can someone help me ? 
 Thank you 
 ------------------------------------ 
 a!localVariables( .... , a!recordFilterList( name: "Field 1", .... ), a!recordFilterList( name: "Field 2", .... )

Mike Schmitt · Accepted Answer

Julien Fontaine said: Moreover, is there a wa to bypass the limit of 1 000 char of this pane ? 
 
 Move your code into an expression rule, and just call the expression rule in the User Filters panel. 
 
 Julien Fontaine said: I tried with a code in the User Filters pane that looks like the code below but I got a message error 
 When you do a local variable definition, Appian expects that there be exactly one expression after any local variables are defined. In your example above you have two - each of the a!recordFilterList() calls. 
 The fix for this is simple - wrap everything in an array (which fulfills the "exactly one expression" requirement): 
 a!localVariables(
 local!var1,
 local!var2,
 
 {
 a!recordFilterList(
 name: "Field 1",
 ....
 ),
 a!recordFilterList(
 name: "Field 2",
 ....
 )
 }
)

Mike Schmitt · Answer

The documentation defines rsp!filters as "An array containing the record type's default filters as well as the user filter selections." 
 Basically this ends up meaning that I can't tell you how to see what the actual value is at runtime, but you can deduce what the value is by whatever value (if any) you have defined for your Default Filters and User Filters - which, as far as I know, boils down to a list of a!queryFilter . 
 In my case, I'm able to test out my list view source expression Expression Rule by typing an array of valid a!queryFilter() entries in the "Expression" box for ri!filters (or just leave it blank to test a default query). 
 That being said, I still believe you'll need to figure out a way to differentiate the two different types of "id" before you get to this point. I'm still a little unclear on the source of the incoming data types - are they mapped to Appian data types or something else? In what way do the two different tables end up being queried by the same record source expression?

Expression-Backed Record - multiple user filters

Top Replies