MQSeries.net :: View topic

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » Filter by date

Filter by date

« View previous topic :: View next topic »

Author

Message

sam999

Posted: Thu Dec 22, 2005 1:05 am Post subject: Filter by date

Apprentice

Joined: 12 Jul 2005
Posts: 34

Hi,

Is there a way to filter based on current or system date.....ie show me items with start date = current date or system date?

Thanks....

elvis_gn

Posted: Thu Dec 22, 2005 1:13 am Post subject:

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

If you are referring to WorkItem start date...then you can do it.

Look at the Runtime field which shows the Date(date time) and use it in the filter condition.

Regards.

sam999

Posted: Thu Dec 22, 2005 2:13 am Post subject:

Apprentice

Joined: 12 Jul 2005
Posts: 34

Hi there,

Thanks but maybe I didn't make myself clear. I know I can filter on a particular date but what i want to do is show everything that is only equal to "system_Date" or "current_date"....can I specifiy such a thing????

hos

Posted: Thu Dec 22, 2005 2:54 am Post subject:

Chevalier

Joined: 03 Feb 2002
Posts: 470

You can't use a variable (e.g. NOW) in a filter expression so that MQWF would compute the appropriate value. You have to do this in your client code.

nMQWF

Posted: Thu Dec 22, 2005 3:25 am Post subject:

Apprentice

Joined: 02 Oct 2005
Posts: 27

As hos mentioned, you need to get the system date/ current date / required date in your client code and then use the same in Filter.

sam999

Posted: Thu Dec 22, 2005 6:01 am Post subject:

Apprentice

Joined: 12 Jul 2005
Posts: 34

ok thanks for that......just thought I may have been able to use something like 'current_date'.....

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » Workflow Engines - IBM MQ Workflow & Business Process Choreographer » Filter by date

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP