All Downloads are FREE. Search and download functionalities are using the official Maven repository.

sql.auth.secFirm.list.sql Maven / Gradle / Ivy

There is a newer version: 1.0.31
Show newest version
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