Kathy Baker, Consultant, Juris Professional Services, LexisNexis:
SQL (Structured Query Language) is a database management language for relational databases. SQL uses a variety of statements and clauses to get information out of databases; such as:
Our Software Engineers use SQL when writing custom Juris Suite reports. SQL statements are combined into queries that extract specific fields and records based on certain selection criteria provided by the client. The data can also be grouped and sorted using the SQL statements within the queries. The output of those SQL queries is then designed in a report layout and when printed provides valuable statistical and financial data to the firm. Our Developers also use SQL to code utilities that can alter and/or correct the data in the Juris database.
However, you don’t have to be a Software Engineer or a Developer to be able to use SQL to extract information from the Juris database! The View Tables function in Juris allows you to quickly perform SQL queries on the Juris data. View Tables is only available to users with the “Grant System Administrator Authority” Menu Permission granted. The Juris Professional Services team can create SQL queries for you, or you can use one of the many SQL queries provided on the Juris Support Center web site. Search the web site for “Juris Queries”.
The View Tables function can be found in the Setup and Manage module in Juris. Simply copy the SQL query starting with the SELECT statement, paste it into the View Tables query window, and then click on the Exclamation icon to execute the query. The results are displayed in the grid below the window and can be copied to Microsoft Excel for further manipulating. Below is an example of a simple SQL Query that will select all users/timekeepers from the Employee table (the table in Juris that stores the information about each employee whether they are a user and/or a timekeeper) and displays every field in the table:
View Tables queries can be used to find:
The list goes on and on. There are over 100 helpful SQL queries available on the Juris Support Center web site: