
sql.auth.secFirm.read.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
FROM
secFirm sf
inner join (__authDataSql__) d on
d.dataType = 'firm' and
(d.d1 = '*' or d.d1 = sf.firmId)
WHERE
sf.firmId = :firmId
© 2015 - 2025 Weber Informatics LLC | Privacy Policy