This query returns students whose birth dates exist within a range of time between two dates. Student Queries for Census and Demographic Data Student Birth Date from Range Student Pass-Through Queries The following queries are related to student information and require that the Student radio button be selected from the main Filter Designer page. Items in the following sections are working examples and may be copied into a pass-through query editor with little to no modifications. “Box B” refers to the lower text box that specifies conditions of returned results. NOTE: “Box A” refers to the upper text box that continues the SQL statement. Sample Pass-Through Queries The following sections provide examples of commonly used pass-through queries, organized by the Filter Data Type selected for the query on the Filter Designer main page. NOTE: Nested SELECT statements and ORDER BY clauses are not supported by the passthrough query. Course/Section will return course number and course name.Census/Staff will return last name and first name.Student will return grade, last name, first name and student number.The SELECT statement is predetermined therefore, only certain fields are returned by a pass-through query: SELECT Statements and Pass-Through Queries The SELECT phrase changes depending on the filter data type chosen. It also appears in the Saved Reports list of the Report Builder tool (Ad Hoc Reporting > Report Builder). The saved query appears for selection on the Saved Filters list of the Filter Designer main page. Once saved, the pass-through query can be used to generate custom reports. Click Test Query to run a test of the query. Select the type of users who may access this query from the Organized To dropdown list. Add conditions to distinguish query results in the second text box, Box B. Specify query definitions by continuing the SELECT statement in the first text box, Box A. Enter a name for the query in the Filter Name field. The Pass-Through Query page will display.Ĭreating a Pass-Through Query – (continued) 5. Select Student, Census/Staff or Course Section from the “Filter Data Type” section. Select Create a Pass-Through SQL Query from the “Create a New Filter” section. ![]() ![]() The Filter Designer main page will display. Navigate to Ad Hoc Reporting > Filter Designer. Infinite Campus Technical Reference – Ad Hoc Pass-Through SQL QueriesĬreating a Pass-Through Query – Filter Designer Main Page Users should have the desired year, school and calendar displayed in the Campus toolbar when creating a pass-through query.ġ. A basic understanding of SQL and a working knowledge of the Campus data schema is helpful.Ĭreating a Pass-Through Query Ad Hoc Reporting > Filter Designer Pass-through queries allow users to search for data in a customized manner, to search in tables and/or views not used in the Query Wizard, and they use SQL functions to manipulate results. A pass-through query uses SQL language to gather the desired information. ![]() Overview In Campus, users can return custom sets of data by using the pass-through SQL query option, available as part of the Ad Hoc Filter Designer tool. A copy of the Campus schema may also be useful and may be obtained upon request of Campus Support or a Campus Client Executive. For an introduction to Campus-related SQL basics, please refer to the Campus SQL Basics Technical Guide. Use of the Pass-Through Query tool beyond the “cut and paste” examples listed in this document requires basic SQL knowledge. Technical Reference: Ad Hoc Pass-Through SQL Queries September 2008 This technical guide provides information on using the Ad Hoc Filter Designer tool to perform passthrough SQL queries and contains working examples of commonly used queries.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |