Date range fields are a special field type in Ardoq, which are presented as a distinct field, but at times must be handled as two Date time fields. For the purposes of the Ardoq API and Gremlin graph search, find the names of the underlying Date time fields, and construct your search or API calls accordingly.
To refer to fields using gremlin, we must use their API name. The API name of a can be found under 'Name' inside the field's properties:
The API name of a Date Range field is the value under 'Name' in its properties + '_start_date' for the Start Date. Similarly + '_end_date' for the End Date.
To get the start date for the Date Range field 'Live', the API name would be 'live_start_date'. The end date would be 'live_end_date'.
When composing a Gremlin graph search query, use the Date time fields if you wish to constrain the query based on start or end dates that are greater than or less than your reference date.
fiveDaysAgo = new Date().toInstant().minus(5, java.time.temporal.ChronoUnit.DAYS).toString()g.V().hasLabel('Application').ย ย ย has('research_start_date', lte(fiveDaysAgo))
Calls to the Ardoq API must also deal with the underlying Date time fields; it is not possible to reference a Date range field in an Ardoq API call.
When using Advanced search, it is not necessary to look up the Date time field names. Simply select the Date range field in the field list, and apply a constraint using the before, after, contains, or does not contain operators.
โ