"The a!queryFilter function has an invalid value for the “value” parameter. When the value of “operator” is “=” “value” must not be null or empty." I'm getting this expression evaluation error.

Question

"The a!queryFilter function has an invalid value for the “value” parameter. When the value of “operator” is “=” “value” must not be null or empty." I'm getting this expression evaluation error. 
 with( 
 local!pagingInfo: a!pagingInfo( 
 startIndex: 1, 
 batchSize: - 1 
 ), 
 a!queryEntity( 
 entity: cons!CFS_ALL_DS[7], 
 query: a!query( 
 filter: a!queryFilter( 
 field: "Id", 
 operator: "=", 
 value: ri!Id 
 ), 
 pagingInfo: local!pagingInfo 
 ) 
 ) 
 )

Sharmila Nagaraj · Accepted Answer

Hi Shobhit, 
 
when you do an equal operation in query, the value cannot be passed as blank. Please try like below: 
 
with( 
 local!pagingInfo: a!pagingInfo( 
 startIndex: 1, 
 batchSize: - 1 
 ), 
 local!datasubset: if( 
 rule!APN_isBlank( 
 ri!Id 
 ), 
 {}, 
 a!queryEntity( 
 entity: cons!CFS_ALL_DS[7], 
 query: a!query( 
 filter: a!queryFilter( 
 field: "Id", 
 operator: "=", 
 value: ri!Id 
 ), 
 pagingInfo: local!pagingInfo 
 ) 
 ) 
 ) 
)

sindhug · Answer

Hi Shobhit,

Can you please try below code.Hope this will resolve your issue.

with( 
local!pagingInfo: a!pagingInfo( 
startIndex: 1, 
batchSize: - 1 
), 
local!datasubset: if( 
rule!APN_isBlank( 
ri!Id 
), 
{}, 
a!queryEntity( 
entity: cons!CFS_ALL_DS[7], 
query: a!query( 
filter: a!queryFilter( 
field: "Id", 
operator: "=", 
value: ri!Id 
), 
pagingInfo: local!pagingInfo 
) 
) 
), 
local!datasubset 
) 
 
Thanks, 
Sindhu

"The a!queryFilter function has an invalid value for the “value” parameter. When the value of “operator” is “=” “value” must not be null or empty." I'm getting this expression evaluation error.

Top Replies