Home : Products : Job Cal Plus : Documentation : Main Menu : Edit : Filters Entry, Advanced SQL
Q13732 - INFO: Filters Entry, Advanced SQL
Tab allows you to enter Advanced SQL entries within Filters Entry.  This is only for people who have a very advanced understanding of SQL statements.  If you want to see the SQL statement that is generated by the selections you made on the filter and sort tabs check the Show Filter and Sort SQL expression made from the Filter and Sort tabs box.  Uncheck this box to clear the text displayed in the box.  If you want to filter by a SQL statement that you have written enter the text in the box and then check the Override All Filter and Sort Settings and apply this SQL expression box.  Now your statement will override any settings that were made in the Filter and Sort tabs.     

 

FIELDS:

Overide All Filter and Sort Settings and apply this SQL expression box selection: If you want to filter by a SQL statement that you have written enter the text in the box and then check the Override All Filter and Sort Settings and apply this SQL expression box.  Now your statement will override any settings that were made in the Filter and Sort tabs.

Show Filter and Sort SQL expression made from the Filter and Sort tabs for the Currently Applied Filter box selection: If you want to see the SQL statement that is generated by the selections you made on the filter and sort tabs check the Show Filter and Sort SQL expression made from the Filter and Sort tabs box.  Uncheck this box to clear the text displayed in the box.

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 2/6/2012 2:15 PM.
Last Modified on 6/29/2012 4:43 PM.
Last Modified by Scott Dorner.
Article has been viewed 3328 times.
Rated 9 out of 10 based on 2 votes.
Print Article
Email Article