Reference List Filter

Not applicable

‎08-04-2009 02:03 AM

I have a form which contains a lookup and references a second table. This works fine.

However, I want to place a filter on this list to only return records that match a criteria.

I defined a filter on my referenced table and called it 'sys_ref_list'.

Now, when I perform a lookup, the pop up window displays my custom filter by default BUT I have to click on run for it to complete.

I do not want any manual intervention and would like this query to run automatically.

0 Helpfuls
  • 1,155 Views
4 REPLIES 4

Mark Stanger
Giga Sage

‎08-04-2009 05:23 AM

Have you checked out Reference Qualifiers?

http://wiki.service-now.com/index.php?title=Reference_Qualifiers


0 Helpfuls

Not applicable
In response to Mark Stanger

‎08-12-2009 02:16 AM

I am already using the reference qual to perform another query.

Can you please advise why the filter does not run by default?


0 Helpfuls

Mark Stanger
Giga Sage
In response to

‎08-12-2009 04:19 AM

I'm not sure. I don't even know what the intended behavior is with a filter set up like that. We do use it like that in one other place (for Workflow) but I'm seeing the same thing you are in my testing. You may have to reach out to support on this question. Please post any answer you get back here.


0 Helpfuls

Valor1
Giga Guru
In response to Mark Stanger

‎01-29-2010 02:34 PM

Any update on this? I'm trying to add an "order by" condition to a related list (something that even this found functionality does not support).

I supposed one could add an "onQuery" business rule to sort, but that would override anyone's preferences.


0 Helpfuls