Service Desk Practitioners Forum
cancel

DB rule and direct SQL write

SOLVED
Go to solution
Highlighted
gusztav.ullrich
Trusted Contributor.

DB rule and direct SQL write

Hi,
I would have a question. I write direct into an SQL field of the SD database. I set DB rules to fire at the changing of this field. But the DB rule doesn't start. Is this the normal function?
Regrads,
Gusztav
5 REPLIES
Moxie
Super Contributor.

Re: DB rule and direct SQL write

Check two things...

1) Ensure your rule starts with "When is created or modified... You state that you checked the box to fire the rule when this field changes. So that is good.

2) If it still doesn't fire, Save, hit F5 and see if that helps. F5 refreshes the screen and may cause the rule from firing depending on the order of rules / other rules involved.

If this doesn't help, please paste a copy of the rule and I will take a look.
Do it right the first time
Moxie
Super Contributor.

Re: DB rule and direct SQL write

I found a doc I wrote on how I did this. The doc shows concatenation of a person (Information Modified by) and date (Information Log Timestamp) to a field Information and then conconcatenate all of this to whatever is already existing in the Information Log field.
Do it right the first time
Moxie
Super Contributor.

Re: DB rule and direct SQL write

sorry i posted the above to the wrong post. apologies.
Do it right the first time
Gyula Matics_1
Acclaimed Contributor.
Solution

Re: DB rule and direct SQL write

DB Rules won't trigger on direct SQL updates.

You shouldn't do direct sql anyway.

Gyula
gusztav.ullrich
Trusted Contributor.

Re: DB rule and direct SQL write


Thank you very much.
Gusztav