Scribd
Upload
32 views1 page

Notes

The document contains a series of SQL queries that retrieve and union various journal modification dates from different tables. It also includes a sample XML transaction request. The queries are structured to order the results by date and include hardcoded historical dates for comparison.

Uploaded by

shubham kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
32 views1 page

Notes

The document contains a series of SQL queries that retrieve and union various journal modification dates from different tables. It also includes a sample XML transaction request. The queries are structured to order the results by date and include hardcoded historical dates for comparison.

Uploaded by

shubham kumar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

Latitude-E5270,jb,.

[Link]

((SELECT 1 AS seq, '2070-10-30 [Link]' AS journalmodifieddate)


UNION
(SELECT 1 AS seq, journalmodifieddate FROM test.generaljournalentrylines_fsg ORDER
BY journalmodifieddate DESC LIMIT 1)
UNION
(SELECT 2 AS seq, '1870-10-30 [Link]') ORDER BY 1, journalmodifieddate ASC)

(SELECT 1 AS seq, journalmodifieddate FROM test.generaljournalentrylines_fm ORDER


BY journalmodifieddate DESC LIMIT 1)
UNION
(SELECT 1 AS seq, journalmodifieddate FROM test.generaljournalentrylines_fsg ORDER
BY journalmodifieddate DESC LIMIT 1)
UNION
(SELECT 2 AS seq, '1870-10-30 [Link]') ORDER BY 1, journalmodifieddate DESC

2021-01-18 [Link].592

SELECT '2020-12-01 [Link]'::timestamp AS journalmodifieddateshdj

(SELECT journalmodifieddate FROM test.generaljournalentrylines_radiuznl) UNION


(SELECT '1870-10-30 [Link]') ORDER BY journalmodifieddate DESC

<?xml version="1.0" encoding="UTF-8"?>


<TransactionRequest>
<fromCounter>15435664</fromCounter>
</TransactionRequest>

(SELECT modifieddate FROM test.glaccounts_afas) UNION (SELECT '1870-10-30


[Link]') ORDER BY modifieddate DESC

(SELECT 1 AS seq, journalmodifieddate FROM test.generaljournalentrylines_fm ORDER


BY journalmodifieddate DESC LIMIT 1) UNION (SELECT 1 AS seq, journalmodifieddate
FROM test.generaljournalentrylines_fsg ORDER BY journalmodifieddate DESC LIMIT 1)
UNION (SELECT 2 AS seq, '1870-10-30 [Link]') ORDER BY seq, journalmodifieddate
ASC

You might also like