"SELECT ReferenceNumber, Description, SentDate, RPADReference, "
+ "ClientName FROM legalnotices INNER JOIN clients ON ClientId=clients.id"
- + " WHERE NoticeSent=1 AND NoticeDelivered=0;"
+ + " WHERE NoticeSent=1 AND NoticeDelivered=0;",
+
+ "SELECT ReferenceNumber, Description, EntrustmentDate, ClientName FROM legalnotices"
+ + " INNER JOIN clients ON ClientId=clients.id"
+ + " WHERE DraftCreated=1 AND DraftApproved=0;",
+
+ "SELECT ReferenceNumber, Description, EntrustmentDate, "
+ + "ClarificationRemarks, ClientName FROM legalnotices INNER JOIN clients ON"
+ + " ClientId=clients.id WHERE ClarificationPending=1;",
+
+ "SELECT ReferenceNumber, Description, EntrustmentDate, ClarificationRemarks"
+ + ", ClientName from legalnotices INNER JOIN clients ON ClientId=clients.id "
+ + "WHERE DraftCreated=0;",
+
+ "SELECT ReferenceNumber, Description, EntrustmentDate, ClientName FROM"
+ + " legalnotices INNER JOIN clients ON ClientId=clients.id WHERE "
+ + " DraftApproved=1 AND NoticeSent=0;"
} ;
private static final String[] REPORTS_FILTERED = { "SELECT ReferenceNumber, Description"
"SELECT ReferenceNumber, Description, SentDate, RPADReference, "
+ "ClientName FROM legalnotices INNER JOIN clients ON ClientId=clients.id"
- + " WHERE NoticeSent=1 AND NoticeDelivered=0 AND ClientId=?;"
+ + " WHERE NoticeSent=1 AND NoticeDelivered=0 AND ClientId=?;",
+
+ "SELECT ReferenceNumber, Description, EntrustmentDate, ClientName FROM legalnotices"
+ + " INNER JOIN clients ON ClientId=clients.id"
+ + " WHERE DraftCreated=1 AND DraftApproved=0 AND ClientId=?;",
+
+ "SELECT ReferenceNumber, Description, EntrustmentDate, "
+ + "ClarificationRemarks, ClientName FROM legalnotices INNER JOIN clients ON"
+ + " ClientId=clients.id WHERE ClarificationPending=1 AND ClientId=?;",
+
+ "SELECT ReferenceNumber, Description, EntrustmentDate, ClarificationRemarks"
+ + ", ClientName from legalnotices INNER JOIN clients ON ClientId=clients.id "
+ + "WHERE DraftCreated=0 AND ClientId=?;",
+
+ "SELECT ReferenceNumber, Description, EntrustmentDate, ClientName FROM"
+ + " legalnotices INNER JOIN clients ON ClientId=clients.id WHERE "
+ + " DraftApproved=1 AND NoticeSent=0 AND ClientId=?;"
} ;
static void saveStationerySettings (String left_header,