Type Specifications Reference Qualifier question

Community Alums
Not applicable

Hi,

Create a reference field to the personal computer table that is filtered to only computers assigned to that user that are listed as not retired/end of life. Show the Name, Manufacturer and Model ID fields in the drop-down so it is easy to find the computer that is lost.

I have done most of it, still I have to work on 'computers assigned to that user'. Kindly help.

 

Brand.PNG

 

Apple.PNG

 

Regards

Suman P.

1 ACCEPTED SOLUTION

Hello @Community Alums 

 

You have to put 

Reference Qualifier : 

javascript:"life_cycle_stage!=End of Life^life_cycle_stage_status!=Retired^assigned_to= current.variables.assigned_to"

 

variable attributes you have written previously was correct.

 

Vishal Birajdar
ServiceNow Developer

I know one thing, and that is that I know nothing.
- Socrates

View solution in original post

3 REPLIES 3

Vishal Birajdar
Giga Sage

Hello @Community Alums 

 

Do you have any variable which refers to User table..??

 

if yes, then you can use Advanced reference qualifier :

 

javascript&colon; "life_cycle_stage!=End of Life^life_cycle_stage_status!=Retired^assigned_to=" + current.variables.<Name of Variable refering to User table>

Vishal Birajdar
ServiceNow Developer

I know one thing, and that is that I know nothing.
- Socrates

Community Alums
Not applicable

Hi @Vishal Birajdar ,

Thank you so much, I think I am still doing something wrong. Kindly help.

 

 

 

javascript&colon;"life_cycle_stage!=End of Life^life_cycle_stage_status!=Retired^assigned_to= current.variables.assigned_to"

 

Apple.PNG

 

Screenshot 2023-09-07 at 11.59.35 AM.png

 

Brand.PNG

 

Regards

Suman P.

Hello @Community Alums 

 

You have to put 

Reference Qualifier : 

javascript&colon;"life_cycle_stage!=End of Life^life_cycle_stage_status!=Retired^assigned_to= current.variables.assigned_to"

 

variable attributes you have written previously was correct.

 

Vishal Birajdar
ServiceNow Developer

I know one thing, and that is that I know nothing.
- Socrates