Admins receive the following message when performing item search and filtering by multiple curricula.
Reproducing the Issue
- After logging as an Administrator, Go to Learning > Items;
- Click the blue funnel next to the Curricula field and include multiple curricula to the filter;
- Select the parameters for the item (example status)
- Click Search
The issue is happening only when the number of curricula used to search items exceeds > 1000. When you include more than 1000 IDs as criteria to search, search selector framework in the system needs to prepare specialized query to handle oracle limit of 1000 IDs in In-clause. This is a limitation from Oracle Database and not from the product
There is an enhancement planed to 1802 release which will address the max limit approach for in-clause.
In the meantime, if customer is planning to use more than 1K curricula in the item search criteria, the Item Search Selector configuration can be updated to address this without waiting for the enhancement.
- Go to System Admin > Configuration > Search Selectors;
- Find Component and edit;
- Find criteria.Qualification.filter;
- And modify the entry FROM:
criteria.Qualification.filter=PV_COURSE.CPNT_TYP_ID, PV_COURSE.CPNT_ID, PV_COURSE.REV_DTE) in (select qc.CPNT_TYP_ID, qc.CPNT_ID, qc.REV_DTE from PA_QUAL_CPNT qc where\n\t\t\t\t\t$CASE$(qc.QUAL_ID) $OPERATOR$ $VALUE$
criteria.Qualification.filter=PV_COURSE.CPNT_TYP_ID, PV_COURSE.CPNT_ID, PV_COURSE.REV_DTE) in (select CPNT_TYP_ID, CPNT_ID, REV_DTE from PA_QUAL_CPNT where\n\t\t\t\t\t$CASE$(QUAL_ID) $OPERATOR$ $VALUE$
LMS, item search, table or view does not exist, ORA-00942: table or view does not exist, curricula , KBA , LOD-SF-LMS , SuccessFactors Learning , Problem