Filter in a reference field

[thirumala2]

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:

[Dr Atul G- LNG]

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.

[thirumala2]

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

[SunilKumar_P]

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

[thirumala2]

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