Skip to main content
January 19, 2023
Question

Issue getting the records which meet the condition

  • January 19, 2023
  • 2 replies
  • 0 views

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

January 20, 2023

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

linp0001Author
January 20, 2023

thanks