cancel
Showing results for 
Search instead for 
Did you mean: 

PQL query to display

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

4 REPLIES 4
David_Sun
Community Manager

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

ChristopherS
12 Sherpa

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.
BES-SWO
IR Partner

Re: PQL query to display

Hello Christopher,

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

RicardoMachado
05 Base Camper

Re: PQL query to display

Please follow this link and download this link and download the slide deck: https://community.ir.com/t5/PQL/PQL-Advanced-Presentation-Summit-2019/m-p/8159

 

Regards,

 

Ricardo Machado