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
Check the value in cons!ATRFA_ENTITY_SETTLE_REQUEST. It contains Data store entity, and you are trying to index text value from it