Current Timestamp minus some amount of time

bucobill

Does anyone know how to return in a report using a query items that have been added to the system in a short amount of time from the time the report is created. In other words, I have an item and I need to send a report via email for this one type of product to a vendor who owns the product to ask for shipping.

I have tried Item.Timestamp >= CURRENT_TIMESTAMP - 1
I also have in the same query Item.MaufacturerName = Product.ManufacturerName

I thought this would work but it doesn't. It returns all items sold to this vendor for the entire day plus.

I read the Rule Language Document and I know CURRENT_TIMESTAMP -1 should be Current Time minus 1 hour. Is there any way to just say the time of sale was within 20 seconds of current time? That should produce only limited items in the email report document.

kklosson

Use the DATE_ADD function (counter-intuitive).

bucobill

I need it in a query. I attempted to add

Item.timestamp >= DATE_ADD
This was inside the WHERE area.

It doesn't support this function.

How would I go about using DATE_ADD ? I did find in the rule language TIME_ADD wouldn't this work better. Something like:

Item.TimeStamp >= TIME_ADD - 1 Then maybe run query. However since the query is need for the report how would you suggest we work around this.

Do you think in a Process it would work if we did something like

Find Item where Item.Timestamp>= TIME_ADD-1
SEND MESSAGE ' Dear Vendor here is your order' TO Order.Vendor?

However we need a document for their files and info in the email would not be enough to satisfy their requirements.

Thank you for your help.

rocketman

needs an argument

item.TimeStamp >= TIME_ADD(current_timestamp, - 1)

Replace current_timestamp with a different argument - this is just an example

bucobill

Worked perfectly Thank you so much.

Can you look at the duplicate multiple items into one line thread and see any way to make this select all items that have a multiple greater than one and make the process function as a one click process for all? I really do appreciate your help.