About GoToAssist Query Language (PQL) - GoToAssist Monitoring

Find an Answer

Search GoToAssist Monitoring articles, videos and user guides   Your search term must have 2 or more characters.

Browse Articles

About GoToAssist Query Language (PQL)

The GoToAssist Query Language (PQL) is a simple query language that was developed especially for requesting information from GoToAssist's tree-structured, dual-database search index. Because PQL is very similar to SQL and is as human-readable, you only need a few special characters and symbols to create a PQL query. When basic searches are run, Monitoring automatically translates the basic search terms into PQL and displays it in the Search box as a query.

However, if you do want to utilize a more advanced search features, you'll find that learning PQL provides a lot of advantages.

END-OF-LIFE ANNOUNCEMENT: The GoToAssist Monitoring product will be permanently decommissioned on December 31, 2015. Please see our FAQs for additional details.

Why a new query language?

We wanted a query language simple enough that you could type it on a single line. We also wanted a query language that could talk to GoToAssist's dual database. The traditional relational databases that are based on tables tend to be rigid and hard to extend. The GoToAssist Search Index includes a unique combination of database functionality that is much more flexible and can easily be extended as new types of data are added.

SQL is widely known and designed for relational databases, so it might seem like a logical choice. But SQL and other similar languages — and XML-based languages such as XQuery and XPath — didn't meet our standards of simplicity and flexibility. PQL is not a subset of SQL, it's an entirely new language. And while PQL is similar enough to SQL that we sometimes describe it as SQL-like, it has a different approach that makes it simpler and easier to use.

How do I use PQL?

The GoToAssist Query Language is developed for handling complex search and look-up requirements, and supporting advanced quantitative searches. PQL uses a straightforward, SQL-like syntax that's easy to read. If you know SQL, you know PQL. It comes with a library of basic statements that are all you need to get started: SELECT, INSERT, MERGE, UPDATE, and DELETE.

You can run these examples against your own data in your GoToAssist search field, or against fictitious data in the Query Sandbox:

You can make simple searches using terms like dell in plain English to get standard text results. You can also write sophisticated queries in PQL for handling the complex search and look-up requirements, and supporting advanced quantitative searches that make GoToAssist unique.

When you start with a simple search term such as dell, GoToAssist automatically converts it into a PQL query. And you can harvest the data that's important to you from your results. You can convert it into a rich chart or graph, or click the detail icon to drill deeper for more specific information. As you delve, you'll see your PQL query evolve in the Search window. Once you have the exact information you're looking for, save that query! Just run the same query, the next time you need that information. You can display the results on a dashboard pane, or share the query itself with colleagues or the greater GoToAssist community.

Related Topics

GoToAssist Query Language (PQL) Overview