Need columns 'Custom Filter's Context' and 'Add Custom Filter' in BIP report from Career site - IRC
Summary:
I am building a BI query to take out all the basic details of career site, here, I have requirement of two more columns 'Custom Filter's Context' and 'Add Custom Filter', This is descriptive flexfield associated with table 'IRC_REQUISITION_B' column - 'ATTRIBUTE_CHAR2', now as per the requirement I want to map each site id with these two columns. I found out one possible match with 'SITE_ID' including tables - IRC_REQUISITION_B(contains requistion_id) → IRC_PUBLISHED_JOBS(contain Site_id and Requisition id) → IRC_CX_SITES_VL(a view containing site_id and name). But the problem is IRC_PUBLISHED_JOBS only have site_id as '1' for all the entries. Is there