WEEK function using MySQL

autonomy2

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.

autonomy2

Hi Support.

Do you have information in regards to my original post?

aware_support

Should work in theory - have a look at the LogViewer and check what it returns for the WEEK function.

ACDC

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