Skip to Content

HCI Content Filter-Terminated employees

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Sep 20 at 11:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20 at 10:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 20 at 10:32 AM

    Thanks for your response.

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

    Add comment
    10|10000 characters needed characters exceeded