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

sql.auth.secUser.read.sql Maven / Gradle / Ivy

There is a newer version: 1.0.31
Show newest version
SELECT
	u.*,
	f.firmName,
	f.theme
FROM secUser u
left join (__authDataSql__) dfu on
	dfu.dataType = 'firm' and
	(dfu.d1 = '*' or (dfu.d1 = u.firmId))
left join (__authDataSql__) du on
	du.dataType = 'user' and
	(du.d1 = '*' or (du.d1 = u.id))
LEFT JOIN secFirm f ON 
	f.firmId = u.firmId
WHERE
	(dfu.d1 is not null or du.d1 is not null) and
	u.id = :id
	 




© 2015 - 2025 Weber Informatics LLC | Privacy Policy