GUIDE: Filters and Queries: Desktop and Dashboard

Jonathan Semones -

In this workbook we will discuss the intricacies of creating advanced filters and queries. We will demonstrate the different types of queries and how to retrieve the data that you need. We will also discuss creating filters for the dashboard and how this differs with creating filters in the desktop. Examples will be provided to aid you in creating your own filters in the dashboard and the desktop.

ACT 2014 - Download PDF, Samples - SQL for Lucity Examples

Topics

Advanced Filters in the Desktop Special Keywords
Defining Relationships Additional Information
Properly Formed Queries Special Filters for the Dashboard
Creating Filters using “or” Acquiring Filters
String Values Restrictions
Boolean Fields Advanced Filters: Web vs. Desktop
Date Fields Web Application Filter Examples:
Querying for Null and Non-Null Values Desktop Application Filter Examples:
Wildcards in Filters Default Joins
Advanced Filters and Crystal Reports Filtering on Child Records
Conversion Convention Examples More Filter Practice

 

Older Versions

ACT 2013Download PDF

Have more questions? Submit a request

Comments