Skip to main content

​
Supported Date and Time Types

Polarion TypeMapped TypeDescription
DateDateTimeFull date and time with timezone
DateOnlyDateTimeDate without time component
TimeOnlyDateTimeTime without date component
All three Polarion date types map to the DateTime data type in Powersheet. The distinction between date-only, time-only, and full date-time is preserved in the Polarion metadata and affects display formatting. diagram

​
Property Configuration

Date and time properties in the domain model use the standard property syntax:
NameTypeDefaultDescription
namestringRequiredProperty name unique within entity type
customFieldNamestringnullPolarion custom field ID for date/time custom fields
typestringAuto-detectedAutomatically inferred from Polarion metadata
readablebooleantrueControls whether the property can be read by clients
updatablebooleantrueControls whether the property can be modified by clients

​
Serialization Format

Date and time values are serialized using ISO 8601 format with UTC timezone:
Format ElementExample
Full DateTime2025-03-15T14:30:00.000Z
DateOnly2025-03-15
TimeOnly14:30:00
All date-time values are transmitted in UTC. The Powersheet client handles timezone conversion for display based on the user’s locale.

​
Query Operations

Date and time properties support comparison operators and date extraction functions:

​
Comparison Operators

OperatorDescriptionExample
eqExact matchupdated eq datetime'2025-03-15T00:00:00Z'
neNot equalupdated ne null
gtAfterupdated gt datetime'2025-01-01T00:00:00Z'
geOn or aftertargetDate ge datetime'2025-03-01T00:00:00Z'
ltBeforecreated lt datetime'2025-06-01T00:00:00Z'
leOn or beforedueDate le datetime'2025-12-31T00:00:00Z'

​
Date Extraction Functions

FunctionReturn TypeDescription
yearInt32Extracts the year component from a DateTime value
monthInt32Extracts the month component (1-12) from a DateTime value
For the full list of query functions, see Function Expressions.

​
Built-In Date Properties

Entity queries automatically include the updated timestamp as a standard metadata field for all entity types:
PropertyTypeDescription
updatedDateTimeLast modification timestamp of the work item
Additional built-in date properties (such as created or resolved) may be available depending on the Polarion work item type. Verify the available date fields for your specific entity type in the application.

​
Complete YAML Example

domainModelTypes:
  UserNeed:
    polarionType: userNeed
    properties:
      title: ~
      targetDate:
        customFieldName: c_targetDate
      reviewDate:
        customFieldName: c_reviewDate
      approvalDeadline:
        customFieldName: c_approvalDeadline
  SystemRequirement:
    polarionType: systemRequirement
    properties:
      title: ~
      plannedStart:
        customFieldName: c_plannedStart
      plannedEnd:
        customFieldName: c_plannedEnd

​
Sheet Configuration with Date Columns

columns:
  title:
    title: Title
    width: 250
  targetDate:
    title: Target Date
    width: 120
  systemRequirements.systemRequirement.plannedEnd:
    title: SR Planned End
    width: 120
Source Code
  • Property.java
  • QueryDataTest.java
  • SaveTest.java
  • JsonGson.java