How to hide certain attributes for reference field searches

Michael H1
Tera Guru

Apologies in advance if this is not under the correct forum and topic.

I am adding a reference variable to a Record Producer that is to be searchable with a set of columns. However, a date column is displaying alongside it, and I do not know how to hide it. The variable attributes are as follows:

 ref_ac_columns=col_variable,ref_ac_columns_search=true,ref_auto_completer=AJAXTableCompleter

At first, I thought this was including the sys_created_on field inadvertently, but if I add that to ref_ac_columns, it is added as an additional column in the reference field search and it says "Created On ....", which is different than the date displayed on the left. I am unsure of where this date in the left hand column is coming from and how to hide it or remove it from view.

For information, this reference variable maps to a reference field that is a reference to another custom table. The reference field has the same attributes as on the Record Producer.

 

find_real_file.png

1 ACCEPTED SOLUTION

Michael H1
Tera Guru

I figured out a solution after attempting some troubleshooting on my end. Although no fields on this custom table had Display set as true, I set the custom column that is blacked out here with Display as true, and the Created fields ceased to display. It appears that without setting a specific field with Display as true results in one being used automatically? I don't know if this is an issue or expected behavior but since I needed to display the custom column anyways in the search, marking Display as true for it was no problem.

View solution in original post

6 REPLIES 6

Aoife
Tera Guru

On the table being reference, check the table config and if the column is set to Display (checkbox on the column page), uncheck it.  Columns that are set to Display will always be on the listing.

Aoife

Thanks for the direction, although this was set to false already. Interestingly, if I add it to ref_ac_columns, it is duplicated in the list view.

To me, it is as if sys_created_on is duplicated and I don't have access to the other column.

find_real_file.png


find_real_file.png

I don't know if this matters, but viewing the table's contents in the list view, I see that "Created" is not in the Selected columns to be viewed, but is displaying anyways. Putting it in selected and back out has no effect. Even though it is not configured to display in the table configuration. I am curious if this is related to it being displayed as a column in the reference field.

find_real_file.pngfind_real_file.png

From a list view, click on a context menu icon, then select Configure, then List Layout.  Once in List Layout, see if there is a rel_list view, if so, edit it to contain what you want or delete it.

Aoife