Can you use SQL to update Attributes in a Live Report

Is there any way to use the live reports to update the attributes in content server 10. For instance I know I could put the following SQL in the live report:
UPDATE [OTCS10].[dbo].[LLAttrData]SET ValStr = %2 WHERE DefID = '14541' and ValStr = %1;

But this doesn't update the Attribute in the UI, just the DB. Is there a way to have it changed in the UI and the DB?

Find more posts tagged with

Comments

Appu Nair

One of the most DANGEROUS THINGS YOU CAN DO TO GET YOUR CONTENT SERVER not supported or the application go cuckoo
Proper API's REST (developer.opentext.com) , SOAP(https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=67792619&objAction=browse&viewType=1) ,Oscript

Web Reports which is basically Oscript executing under the covers as an LL Object since you know SQL this might be the easiest...

**LLATTRBLOBDATA **is the real table that Category Metadata is updated. **LLATTRDATA **serves as a read-only table since the other one is proprietary data structure.

This kind of updating the LL Schema directly does not /should not be done in any LL Installs.

Dave Carpeneto

But this doesn't update the Attribute in the UI, just the DB. Is there a way to have it changed in the UI and the DB?

As if it were a swarm of bees: avoid direct SQL updates (as per Appu's comment above). Whether via a live report or direct SQL this will corrupt your DB, and invalidate your systems supportability. What you wind up with is an inconsistency between tables in the DB. The schema for Content Server is complicated in most places, including categories & attributes.

If you want to update these things programmatically you'll most likely want to look into Web Reports (if purchased for your system), REST / Web Services, or composing your own OScript module (though the last option has quite a steep learning curve).