Filter help

[huyjor]

Hello Team 

I'm trying to filter out the first name & last name from another custom table. For some reason, It only displaya the first name in the field. I used the simple reference qualifier. I would like to know how to get both first & last on the field. Thanks for your help 

[Louise VA]

Hello! What displays in a reference field is set on the custom table itself, not the reference field. 

Reference fields look for the display value in the following order:

1. A field with display=true in the system dictionary on the lowest sub-table for extended tables.
2. A field with display=true in the system dictionary on the parent table.
3. A field named name or u_name.
4. The Created on field of the referenced record.

As an example, look at the "name" field on the sys_user table. This field is calculated based on the first and last name fields. You can see the script on the "Calculated Value" tab on the dictionary record for the name field. It sounds like you want to create a similar field on your custom table, and either name it "u_name" or check the "Display" option on the field. 

More here: https://docs.servicenow.com/csh?topicname=t_SelectTheDisplayValue.html&version=latest

[huyjor]

I don't have any script on the table. I have a custom registration table with 3 fields: firstname, lastname and fullname for student and the same 3 fields for instructors in the same table. ServiceNow sets the variable "instructor fullname" to display true. Everything else is false in custom registration table. I have a catalog item with a variable full student name, which I set as reference to the registration table. I tried to make it display the firstname & last name of the student from the reference table. I tried to use the variable attribute. it wouldn't display. If I turn  on the variable fullname as student as true. It will turn off the variable instructor's full name on the registration table.

I just don't know how to go around this. I'm currently using all custom tables 

[Ashir Waheed]

Hi @huyjor 

If the instructor name is the Reference field, Follow the below instructions.

1. Open the Variable Instructor Name. Go to the Type Specification and use variable attributes.

2. ref_ac_columns=first_name;last_name;name,ref_ac_columns_search=true,ref_ac_display_value=false

3. You can replace the first_name;last_name;name acording to your's Instructor first name and last name.

Alternate: If this doesn't satisfy that you have to change the display value in table configuration. Change will affected on whole table.

Regards,

Ashir Waheed

[huyjor]

Thanks for you help. I tried that variable attribute. It shows up as a blank in the drop down. I see your variable attribute path ref_ac_columns=first_name;last_name;name,ref_ac_columns_search=true,ref_ac_display_value=false. Should this be: ref_ac_display_value=true. I tried that, still didn't work. 

If i make this variable first_name display: true. It causes my other variable from another table into false. This is dangerous. it causes more messy.