I need to implement a script-based service selection to select tickets based on user defined fields of the company - user defined fields created in the sales part of SuperOffice. While the selection is technically no problem the user will not see any user defined fields in the selection result. Also, it is not possible to filter the result by user defined fields. It is not practical for our users. They want to see user defined fields in the result and be able to filter according to user defined fields as well.
The only workaround I can think of is to duplicate user defined fields as extra fields of the company, and to populate those extra fields in a scheduled task. Then I can use regular dynamic service selection based on the redundant extra fields.
Is there any other way? Without having to create redundant data?