Hello,
TimeXtender 20.10.40.64.
In one of our projects we are adding descriptions to every column in a table and we want to be able to get this data querying the database.
However, we can’t find a good place in the repository where the description is stored on a column level and how to effectively exctract this data.
Looking at the [TxObjectDescriptions] table in the repository there is a column called Description that is a long string. This string includes the description we added to the field, however it also has alot of other data. On top of this, the string seems to have different structures from case to case and I can’t find a good way to always get the value we need.
Does anyone have a good way to get this data or knows if there is data saved in another place in a better format?
Thank you,
Victor
Solved
Column/field description repository
Best answer by Thomas Lind
Hi
You will need to split out the text part from the fields. I got a project where I do this, perhaps you can rework it to work for your description field.
+5Hi
You will need to split out the text part from the fields. I got a project where I do this, perhaps you can rework it to work for your description field.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
