change columns for query view

Michael_Watson

hi all, how do you add additional columns on the output to a query you run using Cireson Web Portal?  I want to add additional columns so I can export the report to Excel with this data.  thanks (see graphic with red box - the red box is where I want to add additional columns to view)
thanks all

Shane_White

Hi @Michael_Watson

You cannot change the columns in the Saved Search views, you can choose which columns show as shown in the screenshot below:


To achieve what you wanted to do you would need to create SQL Query's and choose the columns in the query itself then built the table view from it.

Going one step further you could also then build a custom view page with the export to Excel functionality and then put that query into the view and you would then be able to choose columns with the SQL query and export to Excel.

Below are some useful links on how to build views:

https://support.cireson.com/KnowledgeBase/View/1245#/
https://community.cireson.com/discussion/3708/how-to-create-custom-views-on-analyst-portal-contain-both-incident-and-service-requests

Hope this answers your question.
Thanks,
Shane.

Michael_Watson

Ok thank you for the information.  I will give this a try.

Shane_White

Hi @Michael_Watson

You cannot change the columns in the Saved Search views, you can choose which columns show as shown in the screenshot below:


To achieve what you wanted to do you would need to create SQL Query's and choose the columns in the query itself then built the table view from it.

Going one step further you could also then build a custom view page with the export to Excel functionality and then put that query into the view and you would then be able to choose columns with the SQL query and export to Excel.

Below are some useful links on how to build views:

https://support.cireson.com/KnowledgeBase/View/1245#/
https://community.cireson.com/discussion/3708/how-to-create-custom-views-on-analyst-portal-contain-both-incident-and-service-requests

Hope this answers your question.
Thanks,
Shane.

Michael_Watson

Ok thank you for the information.  I will give this a try.

Jason_Meyer

Appreciate the discussion on this topic, we ran into this today and was hoping that the selected columns would save as part of the search. Can we add this to the features requested?

In the meantime we will explore the SQL query and views approach.