QR type

Overview

This type store text and display it as QR in read only view.

Available features

Type rules

Minimum length

The minimum number of characters that values can have.

Maximum length

The maximum number of characters that values can have.

Exact length

The value must have exactly this number of characters.

Regular expression

If set you can write a regular expression to validate the value of the field. This expression should follow regular expressions in Java.

You will see the following options:

• Expression: this is the regular expression to validate values.
• Hint: if there is a validation error, here you can write a message that will be displayed to the user to help him.
• Case insensitive: if this flag is set, matching will be case insensitive. Keep in mind this is only taken into account for simple characters in the expression. For example if you have [a-z] it will require the letter to be in lower case even when this flag is set, but if you put ab in the expression, things like Ab or AB will work.

Display options

Representation

How this field should be displayed. This only has effect on edit view. Options are:

• Input box: a single-line input box will be displayed.
• Text area: a text area will be displayed. There is another option to indicate the number of rows the text area should have.

Limit number of characters

This will limit the number of characters to display, showing a More button to expand the content.

Keep in mind that this option only has effect when the field is read-only.

Error correction level

There are 4 error correction levels used for QR codes, with each one adding different amounts of “backup” data depending on how much damage the QR code is expected.

• Level L – up to 7% damage
• Level M – up to 15% damage
• Level Q – up to 25% damage
• Level H – up to 30% damage

Color

Hex color of QR code. By default #000000

Background Color

Hex background color of QR code. By default #ffffff

Width

The width in pixels of the image to be generated. By default 128.

Height

The height in pixels of the image to be generated. By default 250.

REST API

Read format

The format is a simple string:

"name": "test1"

Write format

You should pass a string:

"name": "new name"

Javascript API

Read format

The val() method in the wrapper will return a plain string:

// this will print something like "name: test1"
log('name: '+record.field('name').val());

Write format

You should pass a plain string to set the value:

record.field('name').val('new name');

Wrapper

Export/Import

Export format

The export format is a simple string:

"textField1","textField2"
"value1","this is a long text"

Import format

The import format is a simple string:

"textField1","textField2"
"value1","this is a long text"

Queries

Please check the documentation for Query language for more information.

Available operators

Query formats

You should pass the text as a plain string. For example:

• JS Query Map
• JS Query Builder
• REST API

// finds companies with name like 'ae'
var records = sys.data.find('companies', {'name': 'like(ae)'});
log('total: '+records.count());
while (records.hasNext()) {
  log(records.next().label());
}

// finds companies with name like 'ae'
var query = sys.data.createQuery('companies')
    .field('name').like('ae');
var records = sys.data.find(query);
log('total: '+records.count());
while (records.hasNext()) {
  log(records.next().label());
}

finds companies with name like 'ae'

GET /data/companies?name=like(ae)

Aggregate queries

Please check the documentation for Aggregate queries for more information.

Available operators

UI queries

Please check the documentation for UI queries for more information.

Matching of values

Available operators