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 

[Ashir Waheed]

Hi @huyjor 

Have you modified the script according to the variables names available on your sys_user table?? can you share your modified script?

As you are referencing to sys_user table and the field in your filter shows First Name(first_name_instructure).

Your script should be according to

ref_ac_columns=first_name_instructure;last_name_instructure,ref_ac_columns_search=true,ref_ac_display_value=false. 

This will only be effected on your reference field.

Regards,

Ashir Waheed

[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 don't know why ServiceNow only allows to have 1 variable to display as true. 

It gotta be away to get around them.