Workspace filter builder additional columns

Stefan_Garcia
Tera Contributor

Is it possible to show additional columns in the Workspace version of the filter builder? For example, I have several locations named 10th floor, but obviously for different buildings. This isn't an issue in Platform view because of the popup window that you get to search for records - you can see the parent. Similarly, on Employee Center, with the additional column attribute on the variable you can see the parent. And even on the Incident form, you can see the parent, again due to the additional column attribute.

 

Stefan_Garcia_1-1737054487930.png

One option is I can have my users workaround the issue using a combination of criteria like "Location contains 10" AND "Location > Parent is <building>".

 

Thanks!

1 ACCEPTED SOLUTION

Marco0o1
Tera Sage

Hi @Stefan_Garcia ,

 

That view exactly don't get correctly the ref_ac_columns, I have something like this into my instance on the location field:

tree_picker=true,readonly_clickthrough=true,ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_building_number,ref_ac_columns_search=true

 

In the form view it load correctly the second name and building number:

Marco0o1_0-1737494419956.png

 

But don't load into the workspace:

Marco0o1_1-1737494461531.png

 

What can I recommend is using a combination of contain and other field like building number|city:

Marco0o1_2-1737494535693.png

 

 

View solution in original post

1 REPLY 1

Marco0o1
Tera Sage

Hi @Stefan_Garcia ,

 

That view exactly don't get correctly the ref_ac_columns, I have something like this into my instance on the location field:

tree_picker=true,readonly_clickthrough=true,ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_building_number,ref_ac_columns_search=true

 

In the form view it load correctly the second name and building number:

Marco0o1_0-1737494419956.png

 

But don't load into the workspace:

Marco0o1_1-1737494461531.png

 

What can I recommend is using a combination of contain and other field like building number|city:

Marco0o1_2-1737494535693.png