Hi
how can i write above query in ER?
can anyone help me with this?
i have tried but it gives error
Discussion posts and replies are publicly visible
In the "Value" field, you need to remove the double quotes and add ri! instead. What you have done right now is you are comparing an Integer field (groupCif_int) with a string ("liabilityNumber_int"). So instead of "liabilityNumber_int" it should be ri!liabilityNumber_int
i have tried with that also
when i given ri it is not filtering all data it is giving
so can you please let me know how can i write ER for this query
You have exchanged the CIF and liability number fields. Please check..Rest, the code looks fine and should work. Can you also include the values that you are passing in your RI in the screenshot?
In the picture, you enter the data into groupCIF_int variable but you are not using it anywhere.