Hi @Minoshini Fonseka , thank you for looking at this. My understanding is that you are telling me that I cannot use a Data Source Condition in order to filter the standard Service Contract list in Aurena. I am familiar with the other options within the Navigation options and am comfortable filtering based on data. I think I’ll go the custom field on the form route and see if I can filter on that. Many thanks.
I changed the Value to #TODAY# instead of sysdate, and that made the lobby display correctly - for the lobby in EE, at least... HOWEVER:In Aurena, the #TODAY# value isn’t being transposed correctly so the formatting doesn’t apply correctly. As I write this, it’s 1st July. In the UK, that means it’s 01/07/2021. In the US, though, today is 07/01/2021. I believe the Aurena client is calculating the formatting based on US format, rather than the full (or ISO8601) date format. I created two test cases to test this theory out. One of the items returned today has an invoice date of 6th Jan (06/01, or 2021-01-06). The second has an invoice date of 8th Jan (08/01, or 2021-01-08). Aurena is correctly showing the icon on the line with invoice date of 06 Jan as red. But, it’s showing the line with invoice date of 08/01 as amber - meaning it thinks it’s the 01st August, which hasn’t happened yet. I’ve got round it by moving the calculation to Oracle inside the IAL to create a column, but I
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.
