Manitou Core - SQL Query - SELECT ACCOUNTS BY PANEL TYPE

01/02/2024 6:31 pm EST

/****** SELECT ACCOUNTS BY PANEL TYPE ******/
SELECT
C.[CONTID] AS 'CUSTOMER ID'
, CS.[PANELTYPE] AS 'PANEL TYPE'
, PT.[DESCR] AS 'PANEL TYPE DESCRIPTION'

FROM [MANITOU].[dbo].[CUSTSYS] CS
JOIN [MANITOU].[dbo].[CUSTOMER] C ON C.[SERIALNO] = CS.[SERIALNO]
JOIN [MANITOU].[dbo].[PANELTYPE] PT ON PT.[PANELTYPE] = CS.[PANELTYPE]

WHERE
-- CS.[PANELTYPE] IN ('13','DSC0003')         /*  TO CHANGE TO SPECIFIC PANEL TYPES REMOVE -- AND                                                                                                  ADD -- TO NEXT LINE     */
CS.[PANELTYPE] IS NOT NULL                     /* TO CHANGE TO ALL PANEL TYPES ADD -- IN FRONT OF ABOVE LINE                                                                               AND TAKE OFF THE -- IN FRONT OF 2ND LINE    */

ORDER BY
CS.[PANELTYPE] ASC
, C.[CONTID] ASC

Was this article helpful?