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.
can you please look into this query and let me know
what is the datatype for GCIF and Liability_Number?
all are integer - gcif, cif, liability_number
a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "GCIF", operator: "=", value: ri!gcif ), a!queryFilter( field: "LIABILITY_NUMBER", operator: "=", value: ri!liabilityNumber ), a!queryFilter( field: "CIF_TYPE", operator: "=", value:"Parent" ) })
please replace your code with the above one and add two rule input variables 1) gcif number(integer) 2) liabilityNumber number(integer). I am not sure why you took GCIF 2 times in where conditions.
I have taken a look and that is what I am suggesting. You have configured it incorrectly. Please take a look the screenshots above and try the suggested approach.