Options
change columns for query view
Michael_Watson
Customer IT Monkey ✭
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
thanks all
0
Best Answers
-
Options
Shane_White
Cireson Support Super IT Monkey ✭✭✭✭✭
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.5 -
OptionsMichael_Watson
Customer IT Monkey ✭
Ok thank you for the information. I will give this a try.0
Answers
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.
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.