Skip to main content
Known Participant
Jan 19, 2023 11:14 PM UTC
Question

Issue getting the records which meet the condition

Hi there,

could anyone let me know what's the problem here,

in the following expression rule, if the condition is meeting, it will return the records which meet the condition, if there are no records meet the condition, I just want to return 0 item, but here it returns 2 "0 items". replacing "{}" with null does not work either. what I should do?

regards

Lin

2 replies

Known Participant
Jan 20, 2023 4:15 AM UTC

In line Number 21 use union function like union(local!existingMaterialInLotInfo1,local!existingMaterialInLotInfo1), will give you unique value

linp0001Author
Known Participant
Jan 20, 2023 3:59 PM UTC

thanks