List box values in not displaying selected value after the update

Novice User asked on December 15, 2020 22:48

I have a page type field which populates value in list box from a custom table. I bulk updated that field for some documents through SQL server management studio Now when I go to those documents , in form tab those values does not come as selected in the list box. I can see from backend in the tables that they have correct value.

Does any one have any idea of why its happening?

Correct Answer

Brenden Kehren answered on December 15, 2020 23:41

Unfortunately, if you don't have advanced knowledge of how the database tables are connected to one another, you will cause a lot of errors directly editing data in the database. You're better off writing code to perform you updates and using the API to handle these mass updates.

Regarding your current problem at hand.

Do you have versioning enabled?

Do you have workflow enabled?

If you answered yes to either of those questions, this is your underlying problem. Based on your question, you're updating the data directly in the page type's table. Unfortunately, with versioning and workflow, you need to update XML in another connecting table and NOT the page type's table.

So aside from telling you how to update XML in SQL, I'll provide some workarounds to get this working.

  1. First, make sure all your pages are checked in.
  2. Make sure all your pages are properly published in workflow.
  3. Remove all pages from workflow (done in the workflow app).
  4. Turn off check-in/out in your workflow.
  5. Manually run the t-sql update on your pages.
  6. Restart your web app's application pool.
  7. Navigate to your website and look for new content.
  8. Renable workflow and versioning.
2 votesVote for this answer Unmark Correct answer

   Please, sign in to be able to submit a new answer.