Is it possible to display unique values only in a filtered list using a business rule?

[abrahams]

I am working on creating user provisioning request using Service Catalog. I've created a filter using a Reference Qual on a reference field (department) so that when a specific company is selected in the company variable only the departments for that company will display as choices in the department reference field variable. The table that I am pulling departments from also contains all the job titles associated with each department and what type of access each title should be given. This means that there are duplicate departments listed in this file. Is there a way to limit the list that I present to the end user to only display unique values and not list duplicate departments? I would like to list the departments only once on the list without having to create another table.

I am also having a problem getting my list to sort departments. I have the line of code in my script ... dptList.orderBy('u_department'); ... (dptList is my Glide Record) however it seems to be ignoring this line. I made sure I spelled the table column name correctly. The script works so far except for this line.

[Uncle Rob]

Dear abrahams,

I may not be understanding this correctly, but it sounds like the root issue here is data structure. It sounds like the table you're referencing to retrieve departments is really storing Job Titles. This Job Titles table has a reference to the department table all its own.

I'd either reference the department table directly (where I expect each department record to be unique), or normalize my data so I have such a table.

Make sense?

[abrahams]

Thank you. That worked.