Problems with using WEEK() function
8 August, 2014
Hi,
I'm trying to use a freehand SQL field with the WEEK() function: WEEK(datefield,3)
I've used this before with success on certain other table fields but in this case when I try to save/activate the field in the view builder it keeps loading and at one point gives a timeout.
Thanks,
Jaap
I'm trying to use a freehand SQL field with the WEEK() function: WEEK(datefield,3)
I've used this before with success on certain other table fields but in this case when I try to save/activate the field in the view builder it keeps loading and at one point gives a timeout.
Thanks,
Jaap
Hi Jaap,
Can you please provide;
-Database you're reporting against
-Version of Yellowfin (including build version from 'system information')
-Raw data and expected result when querying the DB directly (outside of YF)
-How you're applying this query in YF (showing view builder etc..)
-log files under Yellowfinappserverlogs and let me know roughly what time you're trying to save the field.
Also , do you get the same problem if using a virtual table, or a freehand sql calc field at the report level?
Please let me know your findings.
Regards,
David
Can you please provide;
-Database you're reporting against
-Version of Yellowfin (including build version from 'system information')
-Raw data and expected result when querying the DB directly (outside of YF)
-How you're applying this query in YF (showing view builder etc..)
-log files under Yellowfinappserverlogs and let me know roughly what time you're trying to save the field.
Also , do you get the same problem if using a virtual table, or a freehand sql calc field at the report level?
Please let me know your findings.
Regards,
David