Juris Client/Matter import queries

Below are sample queries that can be used when creating a custom SQL import from Juris:

Client level:

SELECT DISTINCT RIGHT(CliCode,6) AS ClientNumber, CliNickName AS ClientName
FROM Client AS C
INNER JOIN
Matter AS M ON M.MatCliNbr = C.CliSysNbr
WHERE M.MatStatusFlag = '0'

Matter level:

SELECT RIGHT(C.CliCode,6) AS ParentClientNumber, RIGHT(M.MatCode,6) AS MatterNumber,
M.MatNickName AS MatterName
FROM Client AS C
INNER JOIN
MATTER AS M ON M.MatcliNbr = C.CliSysNbr
WHERE M.MatStatusFlag = '0'