Skip to main content
March 30, 2023
Question

Want to add two user filters in Record which will be fetching the data from DB two columns

  • March 30, 2023
  • 11 replies
  • 0 views

Hi 

I want to add two user filters in record the data to those two filters is two columns data from DB when i tried was getting error like below 

And the data have duplicate values but need unique values only kindly suggest for this also

a!recordFilterList(
name:rule!ATRFA_translateLabel(field:"wbs"),
options:a!forEach(
items:cons!ATRFA_ENTITY_SETTLE_REQUEST,
expression:a!recordFilterListOption(
id:fv!item.wbs,
name:fv!item.wbs&" ["&fv!item.wbs&"]",
filter:a!queryFilter(
operator:"=",
field:"wbs",
value:fv!item.wbs
)
)
)

)

Error:

The Requested Record Type Is Not Available The WBS user filter expression for record type ATRFA_Settle_Request failed to evaluate. Details: [Expression evaluation error at function a!forEach [line 3]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function a!recordFilterListOption [line 7]: Invalid index: Cannot index property 'wbs' of type Text into type Data Store Entity]. (APNX-1-4205-021)

11 replies

March 30, 2023

Check the value in cons!ATRFA_ENTITY_SETTLE_REQUEST. It contains Data store entity, and you are trying to index text value from it

stefanhelzle0001
Brainy
March 30, 2023

I suggest to visit the documentation of how to configure this.

https://docs.appian.com/suite/help/23.1/fnc_system_a_recordfilterlist.html#example

And then 

March 30, 2023

Hi Stefan

Thank you for the response

Tried in similar kind of way like mentioned but it didnt fetched the data

March 30, 2023

That code in documentation is just an example code for how your recordFilterList() will look like, you need to use recordType! domain to reference any record fields in queryFilter. Check this (this link was also there on the link that Stefan provided ) example and try to apply it to your code.