Skip to main content

Date Time node

​

Description​

The Date Time node represents one or more date and time values, e.g. 14 July 2021 15:21:34

Usage​

The Date Time node is an input, so it can be added to the segments of comparison nodes.

alt text

It can be:

Configuration​

alt text
  • Parameter - select a compatible parameter to use as a placeholder value (if any have been defined in the query).
  • Date and Time - the default value is the current date and time. Select it and use the calendar picker to select one or more dates and times.

Example​

Fetch all defects raised between 14 July 2021 and 14 August 2021

In full detail:

Fetch items of the Defects interface where their Reported Date attribute is greater than 14 July 2021 and less than 14 August 2021

alt text
See JSON code
{
  "type": "Query",
  "properties": {
    "collectionCode": "Live",
    "dodiCode": "designInterfaces_defects"
  },
  "children": [
    {
      "type": "And",
      "children": [
        {
          "type": "GreaterThan",
          "children": [
            {
              "type": "Attribute",
              "properties": {
                "attributeCode": "attributes_defectsReportedDate"
              }
            },
            {
              "type": "DateTime",
              "properties": {
                "value": ["2021-07-13T23:00:00.000Z"]
              }
            }
          ]
        },
        {
          "type": "LessThan",
          "children": [
            {
              "type": "Attribute",
              "properties": {
                "attributeCode": "attributes_defectsReportedDate"
              }
            },
            {
              "type": "DateTime",
              "properties": {
                "value": ["2021-08-13T23:00:00.000Z"]
              }
            }
          ]
        }
      ]
    }
  ]
}