CMDBuild Forum

Insert new lookup via db script

Old Versions
#1

Hi,

I have tried to insert a new lookup record to 'LookUp' table via below script. 

INSERT INTO public."LookUp"("User", "Code", "Description", "Status","Type", "Number") VALUES ('system','Ready','Ready','A','JobStatus','2');

The data doesn't seem to be loaded to cmdbuild after running the script and clear the cache ..

Is there any other table I need to look into , Thanks. 

 

 
#2

The SQL command seems correct.
However,
you need to clean not only the browser cache, but also the server cache
(Administration Module => Setup => Server Management => Clear
Cache (or Restart Tomcat).
CMDBuild Team