Print  
Gray star Gray star Gray star Gray star Gray star --Not rated--
212 Visits 9 Comments
Created
Daniel Damiani Daniel Damiani
Kablink Component
  • Teaming

Hi.

  1. I created a form with some fields like: field01, field02, etc.
  2. The values of these fields are stored in table "SS_CustomAttributes" in Mysql "sitescape"
  3. And.....i would like to change the value "stringValue" of field "field01" in table above (with jsp and sql).

Question: I will damage all database? or no??????

Thanks a lot

 

Workflow
Process State Action
Discussion workflow Active
This entry is currently active
Attachments(0)
Entry History
Tags
 
Replies
Thumbnail Image
Nathan B Jensen Nathan B Jensen

You should be able to change the value without damaging the database, but you should always backup your database prior to making any manual changes to the database.

Thumbnail Image
Daniel Damiani Daniel Damiani

So....all is ok until now....

another question....

after i changed the Strignvalue i need rebuild ths index of a specific folder for example, binder=50.

There are some url like this to rebuild the index:

http://10.1.1.3:8080/ssf/a/do?p_name=ss_administration&p_action=1&action=configure_index&binder=50

 

Or there are a way to rebuild the index of one forum (jsp)?

Thumbnail Image
Peter Hurley (Novell) Peter Hurley (Novell)

The Admin Menu has an option for indexing the search index. You can select a single folder if you want.

Thumbnail Image
Daniel Damiani Daniel Damiani

Thanks Peter.

But i need to do this with jsp.

In jsp, i will change the value in table "SS_CustomAttributes" and i need rebuild the index (of one specfic folder) after this (without manual procedure).

Thumbnail Image
Jong Kim Jong Kim
Modified by
Jong Kim Jong Kim
Aug 6, 2010 8:13 PM

Were you actually able to change the value in SS_CustomAttributes from your jsp successfully? Did the new value stick, for example, after Teaming/Tomcat restart?

Thumbnail Image
Daniel Damiani Daniel Damiani
Modified by
Daniel Damiani Daniel Damiani
Aug 9, 2010 1:43 PM

Hi Jong Kim. I changed the value of a field that i created in form. All is ok after restart the teaming/tomcat.

I still need to rebuild the index after to modify the value and to restart teaming is not a good alternative.

I need to rebuild the index through jsp.

Thumbnail Image
Peter Hurley (Novell) Peter Hurley (Novell)

If you are doing all of this through a jsp, then the best way to force a rebuild of the index is to have your jsp submit a "modify" operation to the entry. The best way would be to have a form on the page that doesn't have any fields. It is an empty form that submits to the URL used to modify the entry. This will cause a re-index for this single entry. But since the form is empty, nothing will actually be changed in the entry data.

Thumbnail Image
Daniel Damiani Daniel Damiani

Hi Peter.

Sorry my incomplete questions.

The value that i changed in table "SS_CustomAttributes" will affect the a lot of itens inside one specific folder so, modify each item, in not a good ideia too.

The rebuild the index of the forum is the best solution (i think- :).

So, if is not possible to rebuild a specifc folder through jsp, i will need search another solution.

Thanks.

Thumbnail Image
Peter Hurley (Novell) Peter Hurley (Novell)

You can have your jsp submit a form that requests the folder to be re-indexed. To do this, look at the source of the Admin Menu item that Manages the Search Index. You should be able to duplicate this form and action URL and force it to submit a request to re-index your folder.

Of course, this only works if you are logged in as admin or some other user with Site Administration rights.

(By the way, we don't think this is a great idea. The folder will appear to be empty if anyone tries to view the folder while the re-indexing is being done.)

Skip Footer Toolbar