Page 1 of 1

SQL Queries to extract Proforma data from the 3E Database

Posted: Fri Dec 06, 2019 7:34 pm
by chris.wieman
In the Attached Excel files are 2 tabs. The first has the results of the SQL query. The 2nd is the actual query that I created to extract the data. The 1st one extracts a list of current Proformas with some basic information.
The 2nd one extracts all open Proformas and the steps each has taken. The Excel also has the delta so you can see how long the Proforma spent at each step in the process.
Feel free to contact me if you need or want additional information.