Skip to main content

​
Supported Primitive Types

The following Polarion custom field types are supported and automatically mapped when properties are defined in the domain model.
Polarion TypePowersheet Data TypeDescription
StringStringPlain text values
TextStringMulti-line text content
IntegerInt32Whole number values
FloatDoubleFloating-point decimal values
CurrencyDoubleMonetary values stored as decimal
BooleanBooleanTrue/false toggle values
DateDateTimeFull date and time with timezone
DateOnlyDateTimeDate without time component
TimeOnlyDateTimeTime without date component
DurationTimeStringTime duration values (see Duration)
diagram

​
Property Definition for Primitive Types

Each property in the domain model can specify a type, though Powersheet automatically infers the type from Polarion metadata in most cases.
NameTypeDefaultDescription
namestringRequiredProperty name unique within the entity type
serverNamestringSame as nameOverride for the actual Polarion field name when it differs from the client-facing property name
customFieldNamestringnullPolarion custom field ID when the property maps to a custom field
typestringAuto-detectedData type override; values include string, integer, date, enum
readablebooleantrueControls whether the property can be read by clients
updatablebooleantrueControls whether the property can be modified by clients
scalarbooleantruetrue for single value, false for collection

​
Automatic Built-In Properties

All work item entity types automatically include the following built-in properties, regardless of what is defined in the domain model:
PropertyTypeDescription
objectIdStringUniversal primary key; read-only, non-nullable
idStringPolarion work item ID
titleStringWork item title
projectIdStringForeign key to the project
The objectId and id properties are always read-only. They cannot be modified by clients regardless of updatable configuration.

​
Query Behavior with Primitive Types

Primitive type properties support standard query operators for filtering:
Data TypeSupported Operators
Stringeq, ne, contains, startsWith, endsWith, toupper, tolower, trim
Int32 / Doubleeq, ne, gt, ge, lt, le
Booleaneq, ne
DateTimeeq, ne, gt, ge, lt, le, year, month
For full operator reference, see Operators and Function Expressions.

​
Complete YAML Example

domainModelTypes:
  UserNeed:
    polarionType: userNeed
    properties:
      title: ~
      description: ~
      priority:
        customFieldName: priority
      storyPoints:
        customFieldName: c_storyPoints
      isApproved:
        customFieldName: c_isApproved
      targetDate:
        customFieldName: c_targetDate
  SystemRequirement:
    polarionType: systemRequirement
    properties:
      title: ~
      severity:
        customFieldName: severity
The richtext Polarion type is retrieved and accessible in queries but rendering behavior for rich HTML content in sheet columns may vary. Verify the display format in the application for rich text fields.
Source Code
  • QueryDataTest.java
  • SchemaGenerator.java
  • MetadataTest.java
  • TypeFns.java
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/common/types/domain/document.ts