labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
f_GroupFullName
Parameters
Name
Type
Mode
GID
int
IN
Definition
BEGIN Declare ut varchar(2000); Set @ut = ''; SELECT group_concat(m.name order by m.depth SEPARATOR '.') FROM mastergroups m where FIND_IN_SET(m.groupid,(SELECT CONCAT(Parents,GroupID) from MasterGroups where GroupID=GID)) into @ut; return ifnull(@ut,''); END