Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Excerpt
Include Page
ILTERMS:_Number FieldIL
TERMS:_Number Field

Number Overview

Icon

Image Removed
Image Added

Behavior

VIDEO: How Number Behaves

Restrictions

Only input of numbers supported. Values with numbers and characters are not supported.

(tick) Valid: 10.5
(error) Not valid: PP10.5

Considerations

You might think number fields are best suited for GTN or EAN numbers. Picturepark NumberFilter, however, does only allow numbers in ranges, which is not suitable for GTN/EAN numbers. We recommended using text fields. 

Examples

  • The exchange rate for Currency

  • Product prices

  • Phone numbers

Number Value Handling

Picturepark Setup Example

Layer: Corporate Information (ID: CorporateInformation)

Field: Product Price (ID: productPrice, decimal) 

Fieldpath

corporateInformation.productPrice

Advanced search for

field Include PageIL:_Query Field ExistsIL:_Query Field Exists Include PageIL:_Query Field is EmptyIL:_Query Field is EmptyAdvanced search for

the field value

corporateInformation.productPrice:84

  • The syntax finds all Content Items with the field "Product Price" available with the value "84". Wildcards 8* do not work in this case. 

Use in Display Pattern

Include PageIL:_DP NumberIL:_DP Number
Filter by label (Content by label)
showLabelsfalse
cqllabel = "display-pattern" and label = "number" and space = "SOL"

Returned field value

Returns the number as a whole number or decimal, depending on the field setting "Decimal". 

Number Field Settings

Name

No special considerations.

ID

No special considerations.

Checkbox "Decimal"

Enabled: Users can input decimal numbers.
Disabled: Users can input whole numbers.

Once set and saved, this cannot be changed!

Pattern

The input check for the number value e.g., checks for the correct phone number format. 

Use a JSON Schema regex for the pattern. See here for valid examples:

https://spacetelescope.github.io/understanding-json-schema/reference/regular_expressions.html

Min. value

The minimum value when editing this field, greater or equal the "min. value" setting. 

Example: numberFieldValue >= Minimum Value

Define a value up to a trillion (minus or plus).
Decimal values are not supported.

Max. value

The minimum value when editing this field, less or equal the "max. value" setting. 

Example: numberFieldValue <= Maximum Value

Define a value up to a trillion (minus or plus), which must be higher than the min value.
Decimal values are not supported.

Required

Include Page
IL
TERMS:
_Field
Required
IL
TERMS:
_Field Required
Required

UI required

Include Page
TERMS:UI required
TERMS:UI required

Sortable

Include Page
IL
TERMS:
_Field
Sortable
IL
TERMS:
_Field IL:_Field Search
Sortable

Sort items based on the number entered to find the smallest or largest number.

Include in filters

Enable to use the numbers in filters. It is required to define ranges for numbers, like for the Product Price define ranges like: 

  • 0 - 100: displayed as "low-price."

  • 101 - 1000: displayed as "high-price."

When working with product numbers, ranges are not sufficient, but the configuration of filters in the Content Browser does not allow number filters without ranges. We recommend using text fields for product numbers. 

Include in search

Include Page
IL:_Field Search
TERMS:Include in search
TERMS:Include in search

Boost value

Include Page
IL
TERMS:
_Field Boost
Boosting
IL
TERMS:
_Field Boost
Boosting