I am trying to fetch the data using intital values from the search
Ex. If Package ID is 10825 then I can type 10 or 25 etc. and should get complete list of package id containing those numbers displayed in search result
i tried using IN and INCLUDES but getting error and it is a wired thing can someone help i am using appian 17.4
a!queryEntity( entity: cons!TMOS_ETY_WF_EXEC_AUDIT, query: a!query( filter: a!queryFilter( field: "packageID", operator: "INCLUDES", value: ri!packageID ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: - 1 ) ) )
error:-
Expression evaluation error at function a!queryEntity: Cannot apply operator [INCLUDES] to field [packageID] when comparing to value [TypedValue[it=101,v={4}]].
Discussion posts and replies are publicly visible
This is basically saying that Appian can't compare two different types of data. What datatype is the field 'packageID'? (ri!packageID appears to be 'List of Number (Integer)'
yes it is integer type and i am trying to find all the package ID starting with 1 but nor IN neither INCLUDES are working to fetch the result
eg:- if i have a data with 123,124,125,126 and if i try to find with 1 then it should result all the list of array