Override Reference Qualifier using a field from the child table

[adilbelahbib]

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]

I think I understand what you're trying to do. I'll have to some experimentation later today.

[adilbelahbib]

Ok, thanks a lot Chuck Tomasi !

[Chuck Tomasi · Accepted solution]

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.

[adilbelahbib]

I see, thanks a lot Chuck, I'm grateful

[ankit_gupta1]

i want to override assignment_group   field reference qualifier "name" value in Problem table   i put