Questions tagged [triggers]
Triggers are rules that perform actions or invoke functions in response to events such as matching conditions or database changes. Use with an applicable database, platform, product, or service tag where possible. Always use with corresponding language tag.
triggers
20,004
questions
0
votes
2
answers
35
views
Htmx on custom events
I'm trying to use htmx triggers and custom events without success. I'm using custom events because I'm going to trigger multiple refresh in a page. My source is very simple, but I cannot make it work:
...
-1
votes
1
answer
32
views
trigger insert query
iam making trigger insert query
CREATE TRIGGER trg_insertZYP_NEW
ON ZYP
AFTER INSERT
AS
BEGIN
INSERT INTO ZYP (zy_id)
VALUES (NEW.zy_id);
END ;
showing error the object 'ZYP' does not exist or ...
0
votes
1
answer
19
views
I want to place 3 items in the Google tables dialog box with a choice of the answer from the text
For some reason, the dialog box currently works with only one list. The rest of the lists are ignored and do not want to appear in the specified cells. I tried to solve the problem in various ways and ...
0
votes
1
answer
44
views
Sometimes my code runs and sometimes it does not
I work for a big organisation and we have some large Google Sheets that multiple users use (however maybe at one time it would be maximum 7-10). I am working on automating some processes for this ...
0
votes
1
answer
22
views
Woocommerce custom e-mail status not working version 9.1.2
I am currently facing a problem.
My Custom e-mail status used to work but out of nowhere it stopped working. I am able to set the status, but it doesnt send an e-mail. The other standard status work ...
0
votes
1
answer
48
views
How do I insert data on DELETE into a different database?
My table holds material details in Material.db. Once the material is processed its details are deleted and new material details inserted. Before deleting I want this data stored in archive database ...
0
votes
0
answers
15
views
Airflow 2.7.2 Trigger badld-written code block Triggerer's async thread
I am running Airflow version 2.7.2, and I constantly see the issue in my trigger log.
Triggerer's async thread was blocked for 0.50 seconds, likely by a badly-written trigger. Set PYTHONASYNCIODEBUG=1 ...
0
votes
0
answers
17
views
Cron stops triggering jobs across entire Jenkins instance
It's happened a couple of times in the last few months, that on one of our Jenkins instances, all jobs that are run by cron stop being triggered. Restarting the Jenkins instance fixes it so that cron ...
-1
votes
0
answers
35
views
I have a sql trigger to avoid application users from login in through ssms. yesterday suddenly the trigger started executing for all users [closed]
The production server suddenly stopped connecting to database and error of trigger execution was shown in error logs and to end user. I have checked the error logs and event logs of computer and could ...
0
votes
0
answers
26
views
How to get the current users window login for audit table
I have a table which needs to be audited for add, update, and delete actions. The SQL I have written successfully adds rows to the audit table when each of these events take place. The problem is that ...
0
votes
1
answer
12
views
Google Tag Manager - Trigger off Custom JS Variable
I have a trigger that does work which is a custom event > some custom events. {{dlv - email}} contains @
{{dlv - email}} pulls information from the following code
`<script>
(function () {
...
0
votes
2
answers
16
views
Is there a way to use p4 triggers to ask for a submit password
I am trying to implement a soft lock system, where we will have a password we send people before submitting.
This kind of works if people pass the password on the submit, but then everyone sees the ...
1
vote
1
answer
41
views
How to get the statement that triggered a trigger function when it is called as part of multi-statement query or function in PL/pgSQL?
I have an INSTEAD OF INSERT trigger on a view. Its trigger function calls current_query(). When inserting something directly into this view, everything works fine.
But when something is inserted into ...
0
votes
1
answer
29
views
How can I find out from which object the event was called?
I want the event to work only on mouse click, how can this happen?
I use jqwitgets grid, this event I use for the grid is triggered when I select a row with the mouse.
$(document).on("rowselect&...
0
votes
0
answers
26
views
Time-Based Trigger Returns Only the Values from Row 1
I have a function that runs based on edits made in Column V starting from Row 2 in a worksheet. That function sends an email on edit.
function onEdit_ColumnV(e){
if(activeSheetName === ...