Where to find the field Settings/General/Description in tmsng sql DB TMS 13.1.2

[philokoi0]

Hi,

I need to find in which tmsng sql table the field in TMS/Settings/General/ "Description" is stored.

I need to use this text field as filter with objSystemCallLog and objSystem...

Thank you for your help,

Philippe

[thobonho · Accepted solution]

Hi Philippe,

The value of the "description" field is stored in dbo.field_SystemField.

Look for field_Field_Id = 938, it's the corresponding Id for "Description".

Hope that helps,

Thomas

[philokoi0]

Hi Thomas,

Great, it works, thank you for your help.

Best regards,

Philippe

[philokoi0]

Hi Thomas,

The E164 number is also stored in the same table and in the same field (StrValue) with ID 121

If I want to add this data in my table, I have a problem as they are stored in the same field!

My SQL Query:

select objsystem.name,field_systemfield.strvalue,objSystemCallLog.RemoteSite,objSystemCallDirection.Description,objSystemCallProtocol.Description,objSystemCallLog.duration,cast(objSystemCallLog.time as varchar(11))

from objSystemCallLog

INNER JOIN field_systemfield ON objSystemCallLog.objsystem_Id = field_systemfield.objsystem_Id

INNER JOIN objsystem ON objSystemCallLog.objsystem_Id = objsystem.Id

INNER JOIN objSystemCallProtocol ON objSystemCallLog.objSystemCallProtocol_Id = objSystemCallProtocol.Id

INNER JOIN objSystemCallDirection ON objSystemCallLog.objSystemCallDirection_Id = objSystemCallDirection.Id

where field_field_id = 938 and objSystemCallLog.duration > 30000 ORDER BY objSystemCallLog.time

Do you have an idea to add this field to my table?

Thanks for your kind help,

Philippe