Hello Support.
Would you have any advice for the following:
My application is using an attribute in Business Object A to store the number of instances found matching certain criteria in Business Object B.
The following works using the default Derby database but won't work using MySQL (MySQL 5.1.19).
BusinessObject_A.Qty = COUNT BusinessObject_B WHERE
(BusinessObject_B = LoggedInSystemUser.BusinessObject_Focus AND
WEEK(DATE_PART(BusinessObject_B.InstanceTimeStamp)) = CURRENT_WEEK AND
YEAR(DATE_PART(BusinessObject_B.InstanceTimeStamp)) = CURRENT_YEAR)
Thanks.
WEEK function using MySQL
Week Function
Hi Support.
Do you have information in regards to my original post?
Do you have information in regards to my original post?
-
- Posts: 7525
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
I had a similar problem to this and could not find a solution. However I was able to get around the problem by creating an Attribute "CurrentWeek" and then updating it with a rule using CurrentWeek=Current_Week
Then in your rule refer to the Attribute CurrentWeek instead of Current_Week
hope that makes sense
Then in your rule refer to the Attribute CurrentWeek instead of Current_Week
hope that makes sense