How to add active users in advanced reference qualifier condition

Gaurav_S0107
Tera Contributor

I have one advanced reference qualifier condition for a field now I want to add active users to that existing condition. how can I add?

 

Thanks!

existing condition : javascript:new global.ReferenceQualifierService().getCaseRequestedByRefQual()

1 ACCEPTED SOLUTION

Subhashis Ratna
Tera Guru

HI @Gaurav_S0107 

Option 1 : 
You can do like this

SubhashisRatna_0-1712744127343.png
Option 2 : 
In script include u can return query like this also,

SubhashisRatna_1-1712744505132.png

For better understanding, I'm attaching a demo screenshot. You can review it for further clarification. However u can add other conditions like this way

SubhashisRatna_2-1712744568552.png

 

 

If this solution resolves your query, kindly mark it as the accepted solution and give it a thumbs up.

Thanks,
Subhashis Ratna


 



View solution in original post

4 REPLIES 4

Ranjit Nimbalka
Mega Sage

Hi @Gaurav_S0107 ,

 

Try with below condition :

 

 javascript:new global.ReferenceQualifierService().getCaseRequestedByRefQual()+"^active=true";

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Regards,
Ranjit

 

Maddysunil
Kilo Sage

@Gaurav_S0107 

 

javascript: new global.ReferenceQualifierService().getCaseRequestedByRefQual() + '^active=true'

 

Please Mark Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

 

Thanks

Vishal Birajdar
Giga Sage

Hello @Gaurav_S0107 

 

Can you try like below if solution provided by other's does not work : 

 

Add below line of code in reference qualifier : 

 

javascript :
var query = new global.ReferenceQualifierService().getCaseRequestedByRefQual();
query = query + '^active=true';
query;

 

 

Vishal Birajdar
ServiceNow Developer

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

Subhashis Ratna
Tera Guru

HI @Gaurav_S0107 

Option 1 : 
You can do like this

SubhashisRatna_0-1712744127343.png
Option 2 : 
In script include u can return query like this also,

SubhashisRatna_1-1712744505132.png

For better understanding, I'm attaching a demo screenshot. You can review it for further clarification. However u can add other conditions like this way

SubhashisRatna_2-1712744568552.png

 

 

If this solution resolves your query, kindly mark it as the accepted solution and give it a thumbs up.

Thanks,
Subhashis Ratna