Who is ready to take Ad Hoc to the next level? (Everyone is raising their hand - I know it!). This fun interactive session will allow users to gain a basic understanding of that 3rd radio button in the query wizard - SQL Pass Through.
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 pass-through query uses SQL language to gather the desired information. A basic understanding of SQL and a working knowledge of the Campus data schema is helpful. Pass-through queries allow users to search for data in a more customized way, to search on tables and views not used in the Query Wizard and to use SQL operators.
Click
HERE for the presentation.