| Table Name: Saxon XSLT - 14 Fields |
| PrimaryKey |
Normal, Text |
Auto-Enter:
Validation:
- Only during data entry
- Not empty
- Unique
- Strict validation
Storage:
- Repetitions: 1
- Indexing: Minimal
- Automatically create indexes as needed
- Index Language: Unicode Raw
|
Unique identifier of each record in this table |
|
|
|
|
| CreationTimestamp |
Normal, Timestamp |
Auto-Enter:
Validation:
- Only during data entry
- Strict data type: 4 digit year
- Not empty
- Strict validation
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
Date and time each record was created |
|
|
|
|
| CreatedBy |
Normal, Text |
Auto-Enter:
Validation:
- Only during data entry
- Not empty
- Strict validation
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
Account name of the user who created each record |
|
|
|
|
| ModificationTimestamp |
Normal, Timestamp |
Auto-Enter:
Validation:
- Only during data entry
- Strict data type: 4 digit year
- Not empty
- Strict validation
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
Date and time each record was last modified |
|
|
|
|
| ModifiedBy |
Normal, Text |
Auto-Enter:- Modification account name
Validation:
- Only during data entry
- Not empty
- Strict validation
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
Account name of the user who last modified each record |
|
|
|
|
| XML |
Normal, Text |
Auto-Enter:
- Allow editing
- Context table: Saxon XSLT
Calculation: Let ( [
xmlFormatted = MBS("XML.Format"; Self);
xmlFormatFailed = MBS("IsError");
xmlText = If(xmlFormatFailed; Self; xmlFormatted);
result = MBS("XML.Colorize"; xmlText)
]; result )
// put this calculation into a field, so the field gets formated and colorized whenever the field is changed and the record gets commited.
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: German
|
|
|
|
|
|
| Query |
Normal, Text |
Auto-Enter:
- Allow editing
- Context table: Saxon XSLT
Calculation: TextFormatRemove ( Self )
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Result |
Normal, Text |
Auto-Enter:
- Allow editing
- Context table: Saxon XSLT
Calculation: Let ( [
xmlFormatted = If( Left(Self; 1) = "<"; MBS("XML.Format"; Self); Self);
xmlFormatFailed = MBS("IsError");
xmlText = If(xmlFormatFailed; Self; xmlFormatted);
result = MBS("XML.Colorize"; xmlText)
]; result )
// put this calculation into a field, so the field gets formated and colorized whenever the field is changed and the record gets commited.
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Description |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: German
|
|
|
|
|
|
| XSL Messages |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| ResultTidy |
Normal, Text |
Auto-Enter:
- Allow editing
- Context table: Saxon XSLT
Calculation: Let ( [
vSelf = Saxon XSLT::Result ;
resultFormatted = If( Left(vSelf; 1) = "<"; MBS("XML.Format"; vSelf); vSelf);
resultFormatFailed = MBS("IsError");
resultText = If(resultFormatFailed; vSelf; resultFormatted);
result = MBS("XML.Colorize"; resultText)
];
result
)
// put this calculation into a field, so the field gets formated and colorized whenever the field is changed and the record gets commited.
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Params |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
| Keywords |
Normal, Text |
Auto-Enter:
Validation:
Storage:
- Repetitions: 1
- Indexing: All
- Index Language: German
|
|
|
|
|
|
| Sort |
Normal, Number |
Auto-Enter:
- Allow editing
- Serial: Generate: On creation, Next value: 330, Increment: 10
Validation:
Storage:
- Repetitions: 1
- Indexing: None
- Automatically create indexes as needed
- Index Language: German
|
|
|
|
|
|
