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;
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;