The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL to delete from History Lines?

Highlighted
Peter Dent
Frequent Visitor

SQL to delete from History Lines?

Hi,

I'm running SD4.5 SP17.

I need to delete rows from the History Lines where the Subject begins with "Server Config".

I identified and deleted rows from the ITSM_HISTORYLINES_CONFIG table where HCF_SUBJECT begins with the required string.

However the lines still appear in the History of the CI when viewed through the GUI.

What have I missed?
2 REPLIES
Ben Snell
Member

Re: SQL to delete from History Lines?

Hi

Rerun the select query - if this picks up teh records chances are that the delete did not work. if you have to run the delete statement again make sure that you have a COMMIT command afterwards.

The App server does cache some data - try a restart and see if that helps.

Regards
Ben
Peter Dent
Frequent Visitor

Re: SQL to delete from History Lines?

The SQL wasn't picking up the records, that's what I couldn't understand.

Also at first I wasn't running the Commit.

It turned out that some of the records had been deleted but not all.

They didn't all have the same text string, so I wasn't identifing all the records in the first place.

It's all done now though.

Thanks for your help.
//Add this to "OnDomLoad" event