All Learning Initiatives are not visible in UI.

We have requirement where client wants to see all enrolled employees for particular learning initiative

As parameter for learning initiatives , we are using below query to fetch the list learning initiatives

SELECT DISTINCT name

FROM  wlf_event_assignments_f_tl

WHERE name not like 'Ad Hoc%'

AND     SYSDATE BETWEEN effective_start_date AND effective_end_date

ORDER BY 1

However , In UI we are able to see only one learning initiative and above query is fetching the data whatever in present in UI, which is expected.

Along with that some other learning initiatives also it is pulling, which are not shown in UI.