Hi, is it possible to change the description column value in an entity attribute table (System Table) in MSSQL? We tried to edit the value in Database but the value cannot be seen in Outsystems Entity Attribute Table. Anyone to advise? Thanks
Hi Victor,
System / metadata tables, like the one you mentioned, should not be tampered with, as Service Studio relies on them and will manipulate them. Changing these tables may lead to unexpected behaviours.
On your particular case, the description of the attributes should be changed in Service Studio.
You can rely on shortcuts to Replace All (CTRL + R shortcut) for instance, if applicable, to speed up your changes.
Also take into account that in the data model, there may be multiple columns with the same name on different entities, or the attribute may be inactive and therefore won't be visible in Service Studio.
Kind Regards,João
Thanks João.
I was wondering if the all description field is null, can enable create in the DB (we are not updating anything) because we have 800+ tables for one application and apparently the description fields are all empty.
This will help ease the process greatly.
Can treat this as a feedback as well.
Thanks Victor
This will greatly improve the productivity.
It is not like anybody on the forum could make this happen for you, we are just users of the product like you.
But I'm curious now, having to come up with 800+ descriptions (really, 800 in a single application ?!?!) seems like a big job, why do you think changing that directly in the database would ease that process. Coming up with a meaningfull and correct description 800 times is where the brunt of it is, not entering it.
Unless of course you want to plug in the same meaningless automatic piece of text, but there is so little value in this, that you might as well save yourself even more time by leaving them empty.
Dorine
I agree totally, its 800 tables of descriptions, one table consist of 20 to 30 attributes with description to be filled. I'm just carrying out some instructions and would like to improve the productivity if possible.
I tried to create sql statements in outsystems but the Database returned the following error: Error in advanced query SQL1: Invalid object name 'xxxxx'. because they are systems table.
The only way to do this is to copy and paste description one at a time on the description field for each attribute.
(really, 800 in a single application ?!?!) - sad but true The System Table does have CRUD capabilities, but nothing happens to the field when I try updating.
Ok,
Well good luck and lots of courage with that, or you could challenge the instructions if all you are doing is copy- paste, that sounds like someone is trying to get rid of architecture warnings without actually solving what those warnings are about.