For more information, please refer to this announcement explaining best practices for getting answers to questions.
Have a question with regard to Taleo OBI
Summary:
I'm working on a report to get the duplicate records based on the PAN Number.
So the report should give me all the duplicate records. I have used a custom SQL query but im getting error.
Can someone help me there?
Below is the query I used:
"Candidate Flex Fields"."UDF55" IN(SELECT "Candidate Flex Fields"."UDF55" FROM "Recruiting" WHERE "Candidate Identification"."Record Status"= 'AVAILABLE' GROUP BY "Candidate Flex Fields"."UDF55" HAVING COUNT("Candidate Identification"."Candidate Identifier")>1 )
Example data:
What is expected in the report is
To achieve this I used the above query.
Note: Candidate Flex Fields"."UDF55 is the field name for the PAN Number