Skip to Content
avatar image
Former Member

Content filter is not Filtering data correctly

Hi,

I am using content filter in my integration flow, Where i want to filter on paygrade not equal to particular values. When i use filter for one value i am getting correct output but for multiple values it is not filtering. Please find below conditions used in content filter:

For Multiple values condition is follows:

/queryCompoundEmployeeResponse/CompoundEmployee[(person/employment_information/job_information/pay_grade/text()!='OPT') or (person/employment_information/job_information/pay_grade/text()!='TCT')]

For single value condition is as follows:

/queryCompoundEmployeeResponse/CompoundEmployee[(person/employment_information/job_information/pay_grade/text()!='OPT')]

Can you please help me if any error in condition?

Thanks ,

Harshada G

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 17 at 05:43 AM

    Hi Harshada,

    I assume that you are trying to filter values wherein the Pay Grade is neither equal to 'OPT' nor to 'TCT', please use the condition with an 'AND' operator and you should achieve the desired result.

    /queryCompoundEmployeeResponse/CompoundEmployee[(person/employment_information/job_information/pay_grade/text()!='OPT') and (person/employment_information/job_information/pay_grade/text()!='TCT')]

    Thanks,

    Aditya

    Add comment
    10|10000 characters needed characters exceeded