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

Certified Senior Developer

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)

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data