Welcome, Guest
Username: Password: Remember me

TOPIC: Update info in database based on query

Update info in database based on query #2447

I am trying to set up an automatic way to expire old quotes in JobBOSS. I would like Event Manager to query all quote numbers that are expired by 30 days and change the status from open to expired.

I would be looking up the RFQ table and changing the Status column.

I can do all the look ups but I don't know how to write the portion that will make the change.

Any help?

Manville
The administrator has disabled public write access.

Update info in database based on query #2448

I got this one figured out.

UPDATE RFQ
SET Status='Expired'
WHERE status = 'Active' and Expiration_Date <'{%Last Month Start Date%}'
The administrator has disabled public write access.
Time to create page: 0.028 seconds
Powered by Kunena Forum  Protected by R Antispam