This is a review of our most recent Query Instruction meetings both of which concentrated on using Expressions and standard functions in Query. This is also an overview of the content of the November classes which will be about using Wesleyan Functions in Expressions.
If you are unable to attend the classes, feel free to make use of any of the material in the SFIS Blog. As always, I am available if you have any questions, general or specific, on working with Query. Please send an email to cpike01@wesleyan.edu .
The October 9 Track 1 class introduced how to create expressions and reviewed examples of some of their uses. Basically, expressions are calculations that PS Query performs as part of a query. For example, there can be mathematical calculations, SQL functions or Wesleyan functions utilized in expressions. Using common SQL functions increase the utility of expressions. You can review Lesson 8 in the Query Manager module for more information, including a demonstration of concatenating fields and a page of notes on using expressions.
The next Track 1 class on November 6 continues with expressions (Lesson 8), introducing the use of Wesleyan Functions.
The October 16 Track 2 class reviewed the basics of working with expressions and expanded on the use of SQL functions. If you go to the EXPRESSIONS page you will see a link to a document listing a number of Query Expressions Function Definitions and Examples. You will find similar expressions in Lesson 13 – Expressions – More Examples in the Advanced Concepts module.
The topic of the next Track 2 class on November 20 will be a review of Wesleyan Functions with illustrations of how they can be utilized. An overview and examples of some Wes Functions can be found in Lesson 14 – Wes Functions Review.