labtech
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
f_getEFD
Parameters
Name
Type
Mode
cmpID
int
IN
efdID
int
IN
Definition
BEGIN declare result longtext; set @result = NULL; SELECT efd.value FROM extrafielddata efd where efd.ExtraFieldID = efdID and efd.ID = cmpID into @result; select ifnull(@result,efd.Value) from extrafielddata efd where efd.ExtraFieldID = efdID and efd.ID = 0 into @result; return @result; END