How to sort a list of records from a reference field by a certain field

[matthew_hughes]

On my Business Application form, I've got a reference field called 'Business owning organisation' that links to the Department table:

I'm wanting to order the list of results by the 'Department Type' field:

I've applied the following Reference Qualifier, but it doesn't work:

Does anyone know what I'm doing wrong?

[Nikhil Bajaj9]

Hi,

Is department a custom table - If no - why you are using "u_active" and u_department_type" etc...What I can see is department table is cmn_department (OOB table). Hope you may understood your mistake.

Regards,

Nikhil Bajaj

[matthew_hughes]

Hi @Nikhil Bajaj9 I'm using "u_active" and u_department_type" to limit the number of department records to appear. 'department' is referring to the 'cmn_department' table.

[Nikhil Bajaj9]

Since these columns are not there in Cmn_department table, how these will help you in filtering. You should apply filter on the columns of cmn_department table only.

[matthew_hughes]

"u_active" and "u_department_type" are in the Cmn_department table. The "u_department_type" field is a custom field that we've created and added to the Cmn_department table.