Thank you! That clarified the problem. There were two different problems that was generated when the Where-statement was included or not included.The problem seemed to be using the #START_OF_THIS_MONTH# in the Where statement. I don’t know if this is a general issue or if it is due to me converting the same variable with to_char. But upon replace it with TRUNC(sysdate, ‘MM’) the query worked!Thanks for learning me a new skill with the IFS Cloud DevTool, I can feel it will come in handy in more cases.
No, even when the WHERE statement is blank, I still get the same behavior.
No, still no success unfortunately. I tried to change the datatype to ‘Text’, ‘Date’, ‘Datetime’ but still get the same result no matter which I select.
Hi,Thanks for the reply and that’s interesting! Here are two pictures from the query I am trying to run (one with and one without Group By). I have also tried to remove the filter but get the same result.Without Group ByWith Group By
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.