HCI Content Filter-Terminated employees

[NareshDasika18]

Hello All,

Requirement is to exclude the employees coming SF Compound employee who are terminated before 30th June 2018.

/queryCompoundEmployeeResponse/CompoundEmployee[(person/employment_information/job_information/emplStatus/text() != 'T')]

/queryCompoundEmployeeResponse/CompoundEmployee[(person/employment_information/job_information/start_date/text() < '2018-06-30')]

Please help me with the Xpath expression that i have to use in the content filter

Thanks in advance,

Regards,

Naresh

[Sriprasadsbhat · Accepted solution]

Below should work.

/queryCompoundEmployeeResponse/CompoundEmployee[(person/employment_information/job_information/emplStatus/text() = 'A') or
( not((person/employment_information/job_information/emplStatus/text() != 'T') and (person/employment_information/job_information/start_date < '2018-04-06')))]

Regards,

Sriprasad Shivaram Bhat

[NareshDasika18]

Thanks for your response.

I doubt In this way, I loose an Active employee who has start date greater than 2018-04-06

[Sriprasadsbhat]

Then put a condition for active employee also OR with above condition.

[Sriprasadsbhat]

Hello Naresh,

Below XPATH should work for you.

/queryCompoundEmployeeResponse/CompoundEmployee[not((person/employment_information/job_information/emplStatus/text() != 'T') and (person/employment_information/job_information/start_date < '2018-04-06'))]

Regards,

Sriprasad Shivaram Bhat