AnsweredAssumed Answered

Complex SQL query

Question asked by sccardais on Aug 14, 2015
Latest reply on Aug 14, 2015 by erolst

I would like some help writing an SQL query to export unique records from a single table, USERS. USERS is a master list of all current and previous Users of our product. There are about 75,000 records.


After excluding previous clients and inactive users, we want to generate a report that lists a count of unique Usernames and a count of unique email addresses for each of our current clients.


Unique Users and emails by Org.png


So, in summary, we want to create a found set of records in USERS with USERS::Status = "Client" and USERS::Restrictions = "None" From this found set, we want to create a report with three columns:


  • Org ID
  • Count of Unique Usernames
  • Count of Unique email addresses.


Ideally, I would like to export this report to a spreadsheet.


We are using FMPA 14.01.


This seems like something better suited for an SQL query but its complexity is beyond my experience. Any help would be appreciated.