Showing results for 
Search instead for 
Did you mean: 

PQL query to display

05 Base Camper

PQL query to display

I have a pql query that I would like to display in the WebGui.  Whats the best way to do this?

Community Manager

Re: PQL query to display



The Prognosis REST API provides the function of executing the custom PQL query. Please refer to the online help for it:


Hope this helps.




12 Sherpa

Re: PQL query to display


NO, utilizing the RestAPI is not the easiest way of doing this as it doesn't accomplish getting the actual display of the data.. the RestAPI is for utilizing a very limited data set in another application in limited circumstances at this point.


There are several different ways you can get the data into the Prognosis WebUI; it all depends on the structure of the query and number of fields.  We cover this in the Advanced Dashboard manipulation course where PQL is a prerequisite.   

There are two way you do this though at a high level for a customer.

1) Execute the query from PQL via an Extractor; pull it into a custom record via an extractor script. Then it is in Prognosis and usable in both user interfaces.

2) Create a shell dashboard on that record and publish it to the web with the same number of fields; change our the PQL query it executes in the .DASHBOARD file and usually also in the query_user.xml file.


If you have services hours we can help you work through this as well. 


CC: @David_Sun 

If my answer helped you today, please be sure to mark the resolved button to assist others.

Christopher R Souser - Solution Architect – MSci. PA, CISSP, ITIL.
IR Partner

Re: PQL query to display

Hello Christopher,

where can I find the mentioned "Advanced Dashboard manipulation course" ?

05 Base Camper

Re: PQL query to display

Please follow this link and download this link and download the slide deck:




Ricardo Machado