12-12-2023 03:03 PM - last edited on 04-02-2024 09:16 AM by Mercedes_O
Hello,
I want to recover the structure of the custom fields in the tables.
I can find the custom fields linked to a type of ticket, but I can't find the link between the custom Fields.
Example
Building 1
Ground floor
1st floor
Building 2
basement
Ground floor
1st floor
Building 3
Ground floor
1st floor
2nd floor
I do a
SELECT *
FROM lansweeper.htblcustomfields cf
JOIN lansweeper.htblcustomfieldvalues cf_value ON cf.fieldid = cf_value.fieldid
JOIN lansweeper.htblcustomfieldvaluelinks lnk ON lnk.fieldvalueid=cf_value.fieldvalueid
WHERE
cf.fieldid=1
I find my buildings (1,2,3), the fieldValueId and finally a fieldId in the link table (htblcustomfieldvaluelinks) but it has a value that does not exist in the htblcustomfields table!
how to find the customfieldid corresponding to building 2, for example ?
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now