-
Type: Improvement
-
Status: Reopened
-
Priority: Minor
-
Resolution: Unresolved
-
Affects Version/s: 6.0-HF05, 7.1
-
Fix Version/s: None
-
Component/s: Automation
-
Tags:
-
Story Points:3
As of today, using the CurrentDate wrapper in NXQL queries is not completely straightforward and error prone.
Select * From Document Where dc:created < DATE '@{CurrentDate.format("yyyy-mm-dd")}'
or
Select * From Document Where dc:created < TIMESTAMP '@{CurrentDate.format("what is the correct format ?")}'
Would be a lot easier and faster if there were helpers so that you don't need to ask yourself what is the correct format.
- is related to
-
NXP-22484 Add NOW() function and related date computations to NXQL
- Resolved