Should the Breadcrumbs also reflect Reference Qualifier Query ?

[MariuszJ]

Currently when a reference field has specific Reference Qualifier configured, like. e.g, Active = True. The results that are returned when user opens a list with records (using magnifying glass button on reference field) are depleted of records that would not fit mentioned condition, e.g., Active = True. Guessing, a Simple Reference Qualifier is the method to enforce users to select only from a preconfigured/desired set of results.

Problem:

But in some cases, like for example reference fields to [cmdb_ci] table, business users want just to optimize the loading time of the list of results by ensuring most probable query is already predefined, but they may not necessary want to be limited by that query.

Use cases:

If we use Reference Qualifier to do that, we prevent users from option to search for non-optimal results as well. E.g. When a Simple Reference Qualifier is configured to return only Linux Servers class records, as this is the class selected here 90% of times by the business users. But some users want to be able to also select a Mainframe class or Windows class. If we used Reference Qualifier, the results that are not Linux Servers will not be retrieveable to such end-users, but the results list and its breadcrumbs will show "All". This may be confusing to the 'itil' users, who do not have visibility into configurations of reference qualifiers that admins made, hence reference qualifier is not reflected on breadcrumb filtering.

Idea #1:

What we propose, is to add a system property, which when set to true, allows to show real breadcrumbs such which are reflecting a query condition defined by the administrator in Simple Reference Qualifier for some, or for all the reference fields.

Idea #2:

Other option, would been leaving current default behavior untouched, to ensure that breadcrumbs on the results list for reference field are always starting with "All". But adding a checkbox to the sys_dictionary in Reference Specification tab, somewhere under Reference floats option, that would allow admins to opt specifically to "Show in breadcrumbs" so the breadcrumbs would in such case reflect a real condition that admin designed with Simple Reference Qualifier.   

We understand, ensuring that Breadcrumbs does reflect Simple Reference Qualifier is reversing current paradigm upside-down, but we also strongly believe, it will bring more transparency towards non-admin end-users, and come-in handy to those who use Reference Qualifiers as a way to optimize performance instead just enforcing set of results. 

So, maybe a question: how do you overcome the need fo optimizing a query but seamlessly ensuring users are not so tightly limited? Thanks in advance!

That's all Folks!