For more information, please refer to this announcement explaining best practices for getting answers to questions.
How to use Value Sets like JobFamilyPVO in content types on the profile
Summary
We need help creating and using a value set, similar to how the delivered Career Preferences Content Type use JobFamilyPVO.Content
We are setting up Career Development, and one of the asks is that a user can identify specific jobs of interests based on a list of all active job codes in the system. I notice that The "Career Preferences" content Item makes use already of a few different value sets. For example, JobFamilyPVO gives a list of the job families.
I'm trying to replicate that by either creating my own custom value set that does a sql lookup against the PER_JOBS view or PER_JOBS_F table but I'm failing. (I was suprised to find that All Jobs isn't an existing lookup, but I could be wrong as the search UI is really hard to use as it won't let me start my search with a wildcard)