
sql.auth.secFirm.list.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of butor-auth-dao Show documentation
Show all versions of butor-auth-dao Show documentation
This project is an authentication module (DAO).
SELECT distinct
sf.active,
sf.theme,
sf.firmId,
sf.firmName,
sf.contactName,
sf.contactPhone,
sf.creationDate,
sf.attributes,
sf.revNo,
sf.stamp,
sf.userId,
max(d.mode) mode
FROM
${security.dbName:PORTAL}.secFirm sf
inner join (__authDataSql__) d on
d.dataType = 'firm' and
(d.d1 = '*' or d.d1 = sf.firmId)
WHERE
(:firmName IS NULL OR firmName like :firmName)
GROUP BY firmId
ORDER BY firmName ASC
© 2015 - 2025 Weber Informatics LLC | Privacy Policy