Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Error using Dynamic date
Summary
Getting error when using Dynamic date to beginning of the yearContent
I am using the dynamic date filter to look for a hired date >= beginning of the year: TIMESTAMPADD(SQL_TSI_DAY, DAYOFYEAR(CURRENT_TIMESTAMP) * -(1) + 1, CURRENT_TIMESTAMP))
I am getting this error:
Error | |
View Display Error | |
Error getting drill information: SELECT "Submission Dates"."Submission Completed Date" saw_0, "Submission Source"."Submission Source Type" saw_1, "Submission Source"."Submission Source (BL)" saw_2, "Submission Dates"."Hired Date" saw_3, "Candidate Identification"."State/Prov of Residence" saw_4, "Requisition Primary Location"."Location Level1 Code" saw_5, "Candidate Identification"."Candidate Identifier" saw_6, "Requisition Primary Location"."Location Level2 Name" saw_7, "Requisition Identification"."Req. Identifier" saw_8, "Candidate Identification"."Candidate Is Internal" saw_9, "Requisition Identification"."Title (BL)" saw_10, "Submission CSW Status - Current"."Current Status Name" saw_11, "Submission Source"."Submission Source Explanation" saw_12, "Requisition Flex Fields"."UDF20" saw_13, "Requisition Primary Location"."Location Level3 Name" saw_14, "Candidate Identification"."Zip Code of Residence" saw_15, "Candidate Identification"."City of Residence" saw_16, "Requisition Organization"."Organization Level4 Name" saw_17, "Requisition Organization"."Organization Level3 |
Tagged:
0