Good morning,
I am loading a picker through the records of a DB table, But the error "Expression evaluation error at function a! queryEntity: An error occurred while retrieving the data."I think the reason may be due to the volume of data it recovers, it can exceed 10,000.Is there a maximum number to obtain data?
Thx
Discussion posts and replies are publicly visible
the best way is to call the query entity inside the suggestFunction (STD_ucArrayPickerFilter), parameter *filter* get the entered value
also you can customize the suggest function if the filter value have more than 3 characters then call the Query Entity by paging into 100
/* STD_ucArrayPickerFilter */ a!localVariables( if( len(ri!filter) > 3, a!queryEntity( entity: cons!NAME_TABLE, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "EstadoClient", operator: "starts with", value: ri!filter ) }, ignoreFiltersWithEmptyValues: true ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: 100, sort:a!sortInfo( field:"IdClient", ascending: true ) ) ), fetchTotalCount: false ), todatasubset({}) )
Thank you very much