You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Alert composer using SQL as filter

in Learning 6 comments

Summary:

Hi,

Our requirement is to configure an alert that must trigger based on flexfields.

At this link Document 2783209.1 we understood that they are not supported but we can create filters using SQL.
We then inserted the following code to filter all courses for which attribute 11 is valued with 'Trattati 1':

exists(SELECT 'Y' FROM WLF_LEARNING_ITEMS_F CORS INNER JOIN WLF_LI_COURSES_F CORS_CUSTOM ON (CORS_CUSTOM.LEARNING_ITEM_ID=CORS.LEARNING_ITEM_ID AND TRUNC(SYSDATE) BETWEEN TRUNC(CORS_CUSTOM.EFFECTIVE_START_DATE) AND TRUNC(CORS_CUSTOM.EFFECTIVE_END_DATE) AND NVL(CORS_CUSTOM.CRS_ATTRIBUTE11,'N') = 'Trattati 1' ) WHERE CORS.LEARNING_ITEM_TYPE = 'ORA_COURSE' AND TRUNC(SYSDATE) BETWEEN TRUNC(CORS.EFFECTIVE_START_DATE) AND TRUNC(CORS.EFFECTIVE_END_DATE) AND CORS.LEARNING_ITEM_ID=${learningItemId})

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!