Skip to main content
kavyam0002
July 25, 2022
Question

query rule

  • July 25, 2022
  • 18 replies
  • 0 views

Hi 

how can i write above query in ER? 

can anyone help me with this?

i have tried but it gives error

    18 replies

    harshitb6843
    July 25, 2022

    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

    kavyam0002
    July 25, 2022

    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

    harshitb6843
    July 25, 2022

    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?