Function groupedExternalTransactionsQuery

database/reconciliation.go:802–863

(groupCriteria string)

}

func groupedExternalTransactionsQuery(groupCriteria string) (string, bool) {
	switch groupCriteria {
	case "id":
		return `
        SELECT id::text AS group_key, id, amount, reference, currency, description, date, source
        FROM ledgerforge.external_transactions
        WHERE upload_id = $1 AND id::text IS NOT NULL AND id::text != ''
        ORDER BY id::text
        LIMIT $2 OFFSET $3
    `, true
	case "amount":
		return `
        SELECT amount::text AS group_key, id, amount, reference, currency, description, date, source
        FROM ledgerforge.external_transactions
        WHERE upload_id = $1 AND amount::text IS NOT NULL AND amount::text != ''
        ORDER BY amount::text
        LIMIT $2 OFFSET $3
    `, true
	case "reference":
		return `
        SELECT reference::text AS group_key, id, amount, reference, currency, description, date, source
        FROM ledgerforge.external_transactions
        WHERE upload_id = $1 AND reference::text IS NOT NULL AND reference::text != ''
        ORDER BY reference::text
        LIMIT $2 OFFSET $3
    `, true
	case "currency":
		return `
        SELECT currency::text AS group_key, id, amount, reference, currency, description, date, source
        FROM ledgerforge.external_transactions
        WHERE upload_id = $1 AND currency::text IS NOT NULL AND currency::text != ''
        ORDER BY currency::text
        LIMIT $2 OFFSET $3
    `, true
	case "description":
		return `
        SELECT description::text AS group_key, id, amount, reference, currency, description, date, source
        FROM ledgerforge.external_transactions
        WHERE upload_id = $1 AND description::text IS NOT NULL AND description::text != ''
        ORDER BY description::text
        LIMIT $2 OFFSET $3
    `, true
	case "date":
		return `
        SELECT date::text AS group_key, id, amount, reference, currency, description, date, source
        FROM ledgerforge.external_transactions
        WHERE upload_id = $1 AND date::text IS NOT NULL AND date::text != ''
        ORDER BY date::text
        LIMIT $2 OFFSET $3
    `, true
	case "source":
		return `
        SELECT source::text AS group_key, id, amount, reference, currency, description, date, source
        FROM ledgerforge.external_transactions
        WHERE upload_id = $1 AND source::text IS NOT NULL AND source::text != ''
        ORDER BY source::text
        LIMIT $2 OFFSET $3
    `, true