Skip to main content

Polarion to Powersheet Type Mapping

The metadata system automatically maps Polarion custom field types to internal data types when processing domain model configurations.
Polarion TypeInternal Data TypeNotes
StringStringPlain text values
TextStringMulti-line text content
IntegerInt32Whole number values
FloatDoubleFloating-point decimal values
CurrencyDoubleMonetary values, stored as decimal
BooleanBooleanTrue/false values
DateDateTimeFull date and time with timezone
DateOnlyDateTimeDate without time component
TimeOnlyDateTimeTime without date component
DurationTimeStringDuration values as formatted string
EnumEnumConstrained option set with ID and display label
ListCollectionSets scalar to false for multi-value fields
diagram

Conversion Rules

Primitive Type Conversion

Properties defined in the domain model without an explicit type are automatically typed from Polarion metadata:
  1. The metadata system reads the Polarion field type from custom field configuration
  2. The type is mapped to the corresponding internal data type (see table above)
  3. The mapped type determines column display behavior, editing controls, and query operators

Enum Type Conversion

Enum properties receive additional metadata beyond the base type:
PropertyDescription
Enumeration IDPolarion enum definition identifier
Full qualified enum IDDot-separated scoped identifier
Query keysContext keys for loading options (proto, project, polarionType, enumId)
Default valueInferred from Polarion or explicit domain model configuration

List Type Conversion

When a Polarion field type is a list (collection), the property is marked with scalar: false. This affects:
AspectScalar (true)Collection (false)
Data bindingSingle value displayMulti-value display
Query expansionDirect property accessRequires expand clause
Column renderingStandard cellMulti-item cell

Property Type Information

Each column in Powersheet carries combined type information that determines its rendering and editing behavior:
Type CategoryDescription
Column typeOverall column behavior type (text, number, date, enum, etc.)
Column value typeSpecific value format within the column type
Property typeCombined intersection of column type and value type

Built-In Property Types

All work item entity types include these automatically typed built-in properties:
PropertyTypeRead-Only
objectIdStringYes (primary key)
idStringYes
titleStringNo
projectIdStringYes (foreign key)

Document Entity Read-Only Fields

Document entity types have additional create-only and read-only fields:
PropertyAccess
moduleFolderCreate-only
moduleNameCreate-only
titleCreate-only
typeCreate-only
allowedWITypesCreate-only
outlineNumberRead-only

Security and Type Interaction

Server-rendered properties (computed fields) interact with the type system:
ConfigurationEffect on Type
serverRender enabledProperty is always non-editable regardless of updatable
readable: falseProperty excluded from metadata; not available to client
Entity-level read-onlyIntersected with property-level updatable

Default Value Resolution by Type

TypeDefault Resolution
Primitive (String, Int32, etc.)null unless explicit default in domain model
EnumExplicit domain model default > Polarion enumeration default > null
Booleannull unless configured
DateTimenull unless configured

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
      estimatedEffort:
        customFieldName: c_estimatedEffort
      verificationMethod:
        customFieldName: c_verificationMethod
        enumValues:
          - analysis
          - inspection
          - test
  SystemRequirement:
    polarionType: systemRequirement
    properties:
      title: ~
      severity:
        customFieldName: severity

relationships:
  - from: UserNeed
    to: SystemRequirement
    cardinality: many-to-many
    storage: linkedWorkItems
    linkRole: relates_to
    direct:
      name: systemRequirements
    back:
      name: userNeeds
In most configurations, you do not need to specify the type property explicitly. Powersheet infers types from Polarion metadata. Only specify type when you need to override automatic detection or when the property is not backed by a Polarion field.
Source Code
  • MetadataTest.java
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/common/types/domain/document.ts
  • QueryDataTest.java
  • QueryExecutorTest.java
  • DataPropertyFactory.java