Filter in a reference field
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2024 06:06 AM
HI All ,
I need a help in creating a filter for a reference field :
There is a table : f5 devices
in that the ip address are of different environments .
In the other table which the field is referencing to is below : F5 vips
Now the requirement is if environment is non prod then devices which have dev as environment in f5 devices only needs to be visible in the reference field. This environment field is not available in F5 vips table :
How can I acheive that kindly suggest:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2024 06:15 AM
Hi @thirumala2
To do this, you need to do filter manually. By Dot walk. Like i tried in incident table, and on caller i can see further field, you can do this way.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2024 06:31 AM
Hi AG ,
How I can use dot walk here when there is no reference field in between these two tables ?
Do i need to create a script include and call that in reference qualifier?
Regards,
Thirumala
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2024 06:24 AM
Hi @thirumala2, You can have a reference qualifier of field F5 IP to show only the records with environment as DEV but the question here is as you stated, "if environment is non prod then devices which have dev as environment in f5 devices only needs to be visible in the reference field. This environment field is not available in F5 vips table"
How are you identifying whether the record in F5 vips table is Nonprod or not?
Regards,
Sunil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-13-2024 08:41 AM
HI Sunil,
I am comparing those F5 big ip field with ip address field in F5 devices whether they have environment as dev or prod .
Regards,
thirumala