Browse Articles

Welcome
- Welcome to Monitoring
- Getting Started
- Overview and Features
- System Requirements
Account Management
- Companies
- Users & Permissions
- Contacts & Contact Methods
- Account Settings
Web Account
- Introduction to your Monitoring Web Account
- Multiple Companies
- Multiple Users
- Charts and Graphs
- About the Search Index
- About Dashboards
- Setting Up Dashboards
- Notifications
Applications
- About Monitoring Applications
- Inventory Application
- Alerting Application
- Remote Support Application
- Data Collection Application
- Reports Application
- Server Health Application
- Logs Application
- Automation Application
- Netflow Application
- WSUS Patch Reporting Application
- VMware Application
- Zendesk Application
- XenServer Application
Data Collection
- GoToAssist Setup Assistant
- About Data Collection
- LAN Data Collection (Crawler)
- Off-LAN Data Collection
- Internet Services Testing
- About the Crawler
- Configuring Crawler Credentials
- About Crawler Plugins
Community
- Community
- About Forums and Discussions
- About Share-Its
- User Profiles
Search
- Introduction to Search
- Basic Search
- Search Shortcuts
- Advanced Search
- Using Search Templates
- Nested Search
For Developers
- For Developers
- GoToAssist Developer Tools
- Developing Applications
- GoToAssist API
- Ontology
- About Databases
- Database Concepts
- Straddling Dual Databases
- Tree-Structured Database
- Application Tutorial
- Writing Crawler Plugins
About PQL
- About GoToAssist Query Language (PQL)
- GoToAssist Query Language (PQL) Overview
- PQL Index
- PQL Keywords
- Data Types
Using PQL
- Alternatives
- Subqueries
- Expressions
- Regular Expressions (REGEX)
- Boolean Expressions
- Ephemeral Nodes
- Floating Points
- Identifiers
PQL Functions
- PQL Functions
- Join Function
- History Function
- PQL nvl and coalesce Functions
- Abbreviate Function
- Zip Function
- ID Function
- Available_history Function
- Cast Functions
- Child Function
- Created_at Function
- PQL downcase, lower, upcase and upper functions
- First Function
- Raw_history Function
- Format Function
- Regex Function
- Substring Function
- Has_history Function
- Aggregate Functions
- Num_children Function
- Observed_at Function
- Parent Function
PQL Statements
- Statements
- SELECT
- MERGE
- INSERT
- UPDATE
- DELETE
PQL Clauses and Values
- FROM clause
- WHERE clause
- NULL value
- True and False
PQL Operators
- Operators
- AND operator
- NOT operator
- OR operator
PQL Paths
- Paths
- Path Scoped Predicate
- Path Scoped Projection
- Qualified and Unqualified Paths
PQL Tutorials
- Writing simple queries using SELECT and FROM
- Writing queries using the WHERE clause
- Writing queries that extract historical values
- Writing basic queries
Examples
- Examples
- Examples for Sample Databases
- Examples Historical Data
- Examples IT scenarios
- Creating a dashboard NOC
- Query Examples
- Query Sandbox
- Sample Data and Fictitious Database
Corner Examples
- Corner Examples
- Audit software
- Track Traffic
- Find users
- Inventory management
- Monitor Servers
- More things you can do with GoToAssist
FAQs
- GoToAssist Monitoring FAQs
- WMI Errors and Solutions
Glossary
- Glossary

PQL Index

The components and subcomponents of the GoToAssist Query Language (PQL):

	@		>
	-		<
	+		>=
	~		<=
	**		!=
	\|\|		=
	*		IS
	/		LIKE
	+		BETWEEN
	-		ISNULL
	^		NOTNULL
	&		NOT
	\|		AND
	<<		OR
	>>

Miscellaneous

| Views: 1124 | Last Updated: Thu, May 09 2013 2:28 PM

© 2013 Citrix Online, LLC. All rights reserved. Citrix, GoToAssist, GoToMeeting, GoToMyPC, GoToTraining, GoToWebinar, Podio and Sharefile are trademarks of Citrix Systems, Inc., or a subsidiary thereof, and are or may be registered in the U.S. Patent and Trademark Office and other countries. All other trademarks are the property of their respective owners.