Comment 1 for bug 1895551

Revision history for this message
Chris Sharp (chrissharp123) wrote :

SQL generated by the Dojo acq search:

SELECT "acqpro".id,
        oils_i18n_xlate('acq.provider', 'acqpro', 'name', 'id', "acqpro".id::TEXT, 'en') AS "name",
        "acqpro".owner,
        "acqpro".currency_type,
        "acqpro".code, "acqpro".holding_tag,
        "acqpro".san, "acqpro".edi_default,
        "acqpro".active, "acqpro".prepayment_required,
        "acqpro".url,
        "acqpro".email,
        "acqpro".phone,
        "acqpro".fax_phone,
        "acqpro".default_claim_policy,
        "acqpro".default_copy_count
FROM acq.provider AS "acqpro"
WHERE "acqpro".code ilike 'b%'
ORDER BY code ASC
LIMIT 50;