Override Reference Qualifier using a field from the child table

adilbelahbib · ‎05-24-2016

Hello everyone,

I'm trying to override the reference qualifier of the 'Parent' field (its type is 'Reference') in the case table (in the Customer Services application).

Apparently, I can only apply filters on fields that are created in the Task table and not the ones that I created in the 'Case' table.

Here are some screenshot to emphasize what I'm trying to say.

The field I'm trying to apply the filter on is 'u_case_type', which is a field that I created, and it's located in the case table (customer service application).

This doesn't work, I get all the records on the 'Parent' field and not only those having case type = global.

And when I try another field such as 'short_description', it works.

I hope that you can provide me some help.

Thank you.

Chuck Tomasi · ‎05-24-2016

I was able to reproduce this using the problem table. My reference qualifier override is:

sys_class_name=problem^u_problem_type=Global

and it still showed all records despite this query showing the correct records in the list. Here's why...

the Parent field points to "task". Task knows nothing about your fields on the sub-tables (like problem, or customer service case) so the reference qualifier cannot filter on those unknown fields. Same reason you cannot report on those when you use Task as the base table.

If you REALLY wanted to do this right, you should create a new parent field that points to your table, not task and then you can query against fields on that table.

I should have remembered this because I've run in to it before on my apps.

View solution in original post

Chuck Tomasi · ‎09-06-2016

Hi Ankit,

Try this instead.

name=Problem Management

The spaces may be getting you.

Rob Sestito · ‎02-11-2019

Hey Chuck!

So, I know this is an old post - but it is the best one I have come across (so far). I have my own post question in regards to the Override Reference Qualifier https://community.servicenow.com/community?id=community_question&sys_id=923929e8dba3eb00f0612183ca961934 - and I have yet been able to get what I need. Wondering if you had any time to check out my post and maybe lend a hand?

Greatly appreciated if you are able!

Thanks,

-Rob