cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
eric_vdv_
Engaged Sweeper

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 ?

0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now