Why are there no records returned from a reference field when I know there are records in the referenced table?

Rick Pine
Tera Contributor

We have a Location field on our Catalog Task form that is a Reference Field to the Locations table. When you click on the magnifying glass and the pop-up window comes up, no records are displayed, as if the table were empty, but it's not, there are over 1.500 records.

find_real_file.png

Note that this worked recently in our production environment, and it still works on two of our development environments, but no matter how much I try to compare between the working instances and the non-working ones, I can't figure out what changed or what is different. I'm guessing I lack the experience to know where to look for what has changed, or how it got changed.

find_real_file.png

I checked the Variable to make sure nothing had changed...
find_real_file.png

Here is something interesting and might be a clue, the URLs of the popup windows are identical on the working and non-working instances, and I can get a non-working instance to return the records if I remove one parameter from the URL.

Here is the full, non-working URL minus the domain...

/cmn_location_list.do?sysparm_target=ni.VE181dc5a2db5a30508a4c7504e29619ee&sysparm_target_value=d01dfc816fd27d005314c0bcbb3ee450&sysparm_nameofstack=reflist&sysparm_clear_stack=true&sysparm_element=not&sysparm_reference=cmn_location&sysparm_view=sys_ref_list&sysparm_form_view=default&sysparm_additional_qual=&sysparm_parent_id=78752dd51b5f30101bde960abc4bcb1e&sysparm_domain_restore=false

If I remove sysparm_view=sys_ref_list from that URL, all of the records are returned.

I compared the UI View Reference List / List between the working instances and the non-working ones and they look identical to me.

Any guidance on what else I can check to figure this out is much appreciated. Here are a few screenshots in case that helps.

7 REPLIES 7

Allen Andreas
Administrator
Administrator

Hi,

If the field itself has no reference qualifier on it, you can try looking at your query business rules for this referenced table and perhaps there's some sort of customization set to look at the URI and if it contains sys_ref_list intercept the query and make it something else to where no records would show.

Please mark reply as Helpful/Correct, if applicable. Thanks!


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

It's possible I simply lack the knowledge to understand "If the field itself has no reference qualifier on it" but as you can see in screenshot, it has the Simple reference qualifier on it.

I checked (compared) the business rules for this referenced field table and they are identical between the working instances and the non-working ones, even the dates they were last updated.

Any other ideas? Or, is there some other place I need to look for a reference qualifier on the field itself?

Rick Pine
Tera Contributor

Strangely, we just noticed that another reference field on a Catalog Item (creates a RITM, not a TASK) is doing the same thing. Could they be related?

snowdev8
Tera Expert
Could you compare the ACLs on cmn-location between the instances