...
...
| Code Block |
|---|
| language | xml |
|---|
| title | schema.xml (document object types) | collapse | true |
|---|
|
...
<typeDocumentDefinition>
<id>appSot:document</id>
<baseId>system:document</baseId>
<contentStreamAllowed>allowed</contentStreamAllowed>
<propertyReference>appSot:DateOfReceipt</propertyReference>
</typeDocumentDefinition>
... |
...
| Code Block |
|---|
| language | xml |
|---|
| title | schema.xml (secondary object types) | collapse | true |
|---|
|
...
<typeSecondaryDefinition>
<id>appSot:INV</id>
<baseId>system:secondary</baseId>
<propertyReference>appSot:invoiceNo</propertyReference>
</typeSecondaryDefinition>
<typeSecondaryDefinition>
<id>appSot:DEL</id>
<baseId>system:secondary</baseId>
<propertyReference>appSot:deliverySlipNo</propertyReference>
</typeSecondaryDefinition>
<typeSecondaryDefinition>
<id>appSot:SUP</id>
<baseId>system:secondary</baseId>
<propertyReference>appSot:name</propertyReference>
<propertyReference>appSot:address</propertyReference>
<propertyReference>appSot:phone</propertyReference>
</typeSecondaryDefinition>
... |
...
| Code Block |
|---|
| language | xml |
|---|
| title | schema.xml (add reference) |
|---|
| collapse | true |
|---|
|
...
<typeDocumentDefinition>
<id>appSot:document</id>
<baseId>system:document</baseId>
<contentStreamAllowed>allowed</contentStreamAllowed>
<secondaryObjectTypeId static="false">appSot:INV</secondaryObjectTypeId>
<secondaryObjectTypeId static="false">appSot:DEL</secondaryObjectTypeId>
<secondaryObjectTypeId static="false">appSot:SUP</secondaryObjectTypeId>
</typeDocumentDefinition>
... |
...
| Code Block |
|---|
| title | metadata.json (import) | collapse | true |
|---|
|
{
"objects": [{
"properties": {
"system:objectTypeId": {
"value": "appSot:document"
}
"appSot:DateOfReceipt": {
"value": "2020-10-07"
}
}
}]
} |
...
| Code Block |
|---|
| title | metadata.json (add single) | collapse | true |
|---|
|
{
"objects": [{
"properties": {
"system:secondaryObjecttypeIds": {
"add": "INV"
},
"appSot:invoiceNo": {
"value": "K0815-2020-1894834"
}
}
}]
} |
...
| Code Block |
|---|
| title | metadata.json (add multiple) |
|---|
| collapse | true |
|---|
|
{
"objects": [{
"properties": {
"system:secondaryObjecttypeIds": {
"value": ["INV","SUP"]
},
"appSot:invoiceNo": {
"value": "K0815-2020-1894834"
},
"appSot:name": {
"value": "Supplier Smith"
},
"appSot:address": {
"value": "7 Main Street, London"
},
"appSot:phone": {
"value": "004420834029390"
}
}
}]
} |
...
| Code Block |
|---|
| title | metadata.json (import multiple) | collapse | true |
|---|
|
{
"objects": [{
"properties": {
"system:objectTypeId": {
"value": "appSot:document"
}
"system:secondaryObjectTypeIds": {
"value": ["INV","SUP"]
}
"appSot:DateOfReceipt": {
"value": "2020-10-07"
}
}
}]
} |
...
| Code Block |
|---|
| title | metadata.json (remove) | collapse | true |
|---|
|
{
"objects": [{
"properties": {
"system:secondaryobjecttypeids": {
"remove": "INV"
}
}
}]
} |
Searching for Objects
You You search for objects that that use secondary object types by explicitly specifying them in the FROM clause: select * from appSot:INV. The search result delivers the entire object and not only the properties of the specified secondary object type.
...