Skip to Content
0

Content filter is not Filtering data correctly

May 14 at 07:37 AM

33

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Aditya Sharma May 17 at 05:43 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded