Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Adding a Column to the Dynamic CI Group List View

BhargavY
Tera Contributor

Hello,

I have a requirement to add a “Subclass” column immediately after the “Class” column, as shown in the screenshot below.

However, this view looks different from the standard list view and is displaying the table name as “%24sa_qbs_view”. Could someone please help me understand how to achieve this requirement?

Thanks in advance



BhargavY_0-1768831813061.png

 

7 REPLIES 7

Matthew_13
Mega Sage

Hi Buddy,

That screen isn’t a standard list view, which is why it looks different and shows the table name as $sa_qbs_view. This is a Query Builder / Platform Analytics–generated view, not a normal table list.

Because it’s a virtual view, you can’t add columns using List Layouts or dictionary changes. The columns are driven by the underlying Query Builder configuration.

To add a “Subclass” column after “Class”, you need to:

  1. Identify and open the Query Builder query that powers this view.

  2. Add the field that represents the subclass (typically sys_class_name, or a calculated/derived field depending on your CMDB model).

  3. Reorder the result columns in Query Builder so Subclass appears immediately after Class.

  4. Save and refresh the workspace.

Basically, $sa_qbs_view means this list is controlled by Query Builder, not standard list configuration. The change has to be done at the query level, not the list level.

 

@BhargavY - Please mark Accepted Solution and Thumbs Up if you found Helpful 🙂

MJG

Hi @Matthew_13 ,

Could you please guide me on how to open and update the Query Builder?

Thanks,
Bhargava

GlideFather
Tera Patron

Hi @BhargavY,

 

could you possibly explain where do you see that able name "%24sa_qbs_view"?

 

If it is a view, then update the URL and check this:

https://yourinstance.service-now.com/sys_ui_view_list.do?sysparm_query=titleLIKE24sa_qbs_view%5EORnameLIKE%2524sa_qbs_view&sysparm_view=

 

Perhaps it's a view created by accident...

_____
Answers generated by GlideFather. Check for accuracy.

Ankur Bawiskar
Tera Patron

@BhargavY 

share 1st how did you navigate there so that I can check

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader