Job Application Grid View Sample Query for EL Expression

If you plan to mask data in the job application grid view, you can find below a sample query for an EL expression, an example of an EL expression, and a table listing supported operators in EL expressions.

Sample Query to Get CSP Details

You can run the following query to get the Phase ID, Phase Name, State ID, and State Name for use in the EL expression. Pass the CSP Name as the input value to the query.

select processesvl.process_id,
        processesvl.Name,
        processesvl.code,
        processesvl.status_code,
        rsphases.routing_step_id,
        rsphases.phase_id,
        rsphases.sequence_number as Phase_sequence_number,
        phases.name AS phase_name,
        rsstates.state_id,
        rsstates.sequence_number as State_sequence_number,
        states.name as state_name
from IRC_PROCESSES_VL processesvl,
irc_routing_steps_b rsphases,
irc_phases_tl phases,
irc_routing_steps_b rsstates,
irc_states_tl states
where processesvl.process_id = rsphases.process_id
and rsphases.phase_id = phases.phase_id
AND phases.language = userenv('LANG')
AND rsphases.sub_process_id = rsstates.process_id
AND rsstates.state_id = states.state_id
AND states.language = userenv('LANG')
and processesvl.name = :bindCSPName
order by rsphases.sequence_number, rsstates.sequence_number

Example of an EL Expression

#{securityContext.userInRole['ORA_IRC_RECRUITER_JOB'] ?
                !(item.PhaseId == 14 and item.StateId == 1020 and item.PhaseName == 'Offer' and
                item.StateName eq 'Draft') : false}

Supported Operators in EL Expressions

Operator	Meaning
`>, gt`	Greater Than
`<, lt`	Less Than
`>=, ge`	Greater Than Equals To
`<=, le`	Less Than Equals To
`==, eq`	Equal To
`!=, ne`	Not Equal To
`&&, and`	And Operator
`\|\|, or`	Or Operator