How queries are formatted when we do group by?

[RahulY00040]

Hello friends,

When I do the Group By against field Discovery Source against the CIs listing in cmdb_ci_hardware table, and then click on Open in new Tab, in new opened tab, CI listing is opened but with updated Query which has Class is one of (LIST OF CI CLASSES).  Do we know how this query gets formatted? Any idea?

Many thanks,
Rahul

[Brad Bowman]

I'm following up until clicking on Open in new Tab - where are you clicking on this?  Screenshots would help.

[RahulY00040]

Thanks Brad for your reply. What i mean is when  i click hyperlink for one of the group by record, something like below:

It opens new tab and there if you observer the query, you would see that query is different with condition of Class is one of (xxxxx).

Let me know if you have any questions. Thanks for your response.

_Rahul

[Brad Bowman]

That's what I thought, but what you are seeing after that is unexpected and differs from my experience.  When I do this on my mostly out of box Zurich PDI, hovering over the grouping link shows what it's going to do

then, sure enough when clicking the link this is the resulting list, with the expected filter/query preset

although this does not open in a new tab/window unless I hold down cmd when clicking, but even then the query is the same.  You are starting from the Hardware table list view, correct - not a related list?

[rafaelramos0]

Hi @RahulY00040 !

Let's see if I understood well your question.

Query grouping by the list: cmdb_ci_list.do?sysparm_query=GROUPBYdiscovery_source

Query listing a particular Discover Source: /cmdb_ci_list.do?sysparm_view=&sysparm_query=discovery_source%3DEngineering%20Software

Query listing Class Hardware or Computer and grouping by Discovery Source: cmdb_ci_list.do?sysparm_query=sys_class_nameINcmdb_ci_hardware,cmdb_ci_computer%5EGROUPBYdiscovery_source

Mark helpful if makes sense. 🙂