Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to subtract minutes to a current date variable and to pass this new variable in a dynamic QUERY

3155307Feb 6 2017 — edited Feb 7 2017

Hi Community! I'm new to SOA Suite and I'm facing two issues in my project.

  1. I have defined a variable $currentDate in an Assign node as fn:string(fn:current-dateTime()). Now I have to subtract 2 minutes to my $currentDate.

I find this expression on the web but it doesn't work: xp20:subtract-dayTimeDuration-from-dateTime($currentDate,"PT2M")}

The error I get is on the namespace: http://www.w3.org/2005/xqt-errors}XPST0081: The prefix "xp20" used in the qualified name "xp20:subtract-dayTimeDuration-from-dateTime" can not be resolved

I also added the namespace as shown below but nothing changes.

pastedImage_1.png

How can I get my custom date?

  1. Once I have defined a variable with my custom date I need to call it in a XQUERY like this below:

pastedImage_7.png

I need to insert another WHERE clause where LastModifiedDate must be >= my variable Custom Date

How can I implement this solution?

Thanks in advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2017
Added on Feb 6 2017
6 comments
1,004 views