SQL Queries to extract Proforma data from the 3E Database

Discussions about anything WA Proforma Tracker related. Please keep it constructive.
Post Reply
User avatar
chris.wieman
Posts: 2
Joined: Fri Dec 06, 2019 4:38 pm

SQL Queries to extract Proforma data from the 3E Database

Post by chris.wieman » Fri Dec 06, 2019 7:34 pm

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.
Attachments
Proforma Data Steps Sample.xlsx
(12.84 KiB) Downloaded 240 times
Proforma Data Sample.xlsx
(10.89 KiB) Downloaded 240 times
Post Reply