Highlighted
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?

2 REPLIES 2
Highlighted

Re: PQL query to display

Hi SRS,

 

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

https://help.prognosis.com/prognosis/117/prognosis-rest-api-25168694.html

 

Hope this helps.

 

Regards

David

Highlighted

Re: PQL query to display

@SRS 

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.