{"type":"doc","content":[{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":66.66},"content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Installation","type":"text"}]},{"type":"paragraph","content":[{"text":"To use the REST APIs, you need the following microservice from the ","type":"text"},{"text":"enaio® service mananger ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"setup:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"DMS service","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"The microservice must be installed with at least one instance.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Release Information","type":"text"}]},{"type":"paragraph","content":[{"text":"For each released version of the DMS service you will find detailed information in our Documentation Portal (available in English and German):","type":"text","marks":[{"type":"textColor","attrs":{"color":"#404040"}}]}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"9.10 - ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#404040"}}]},{"text":"https://help.optimal-systems.com/enaio/v910/release/trn/de/rn-webclient/microservices/dms-neuerungen.htm","type":"text","marks":[{"type":"textColor","attrs":{"color":"#404040"}},{"type":"link","attrs":{"href":"https://help.optimal-systems.com/enaio/v910/release/trn/de/rn-webclient/microservices/dms-neuerungen.htm"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"10.0 - ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#404040"}}]},{"text":"https://help.optimal-systems.com/enaio/v100/release/trn/de/sr/dms-neuerungen.htm","type":"text","marks":[{"type":"textColor","attrs":{"color":"#404040"}},{"type":"link","attrs":{"href":"https://help.optimal-systems.com/enaio/v100/release/trn/de/sr/dms-neuerungen.htm"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"10.10 - ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#404040"}}]},{"text":"https://help.optimal-systems.com/enaio/v1010/release/trn/de/sr/dms-neuerungen.htm","type":"text","marks":[{"type":"textColor","attrs":{"color":"#404040"}},{"type":"link","attrs":{"href":"https://help.optimal-systems.com/enaio/v1010/release/trn/de/sr/dms-neuerungen.htm"}}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"11.0 - See ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#404040"}}]},{"text":"breaking changes","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}},{"type":"link","attrs":{"href":"#id-1.GeneralInformation-BC-6.0.0"}}]},{"text":" ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#ff0000"}}]},{"text":"section | ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#003366"}}]},{"text":"https://help.optimal-systems.com/enaio/v110/release/trn/de/sr/dms-neuerungen.htm","type":"text","marks":[{"type":"textColor","attrs":{"color":"#003366"}},{"type":"link","attrs":{"href":"https://help.optimal-systems.com/enaio/v110/release/trn/de/sr/dms-neuerungen.htm"}}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Versioning","type":"text"}]},{"type":"paragraph","content":[{"text":"The mentioned microservice does not carry the same version number as enaio®. The following table shows which version is compatible with which enaio® version. It will be extended with each enaio® version released.","type":"text"}]},{"type":"table","attrs":{"layout":"full-width","width":1583.9946,"localId":"8a3612a0-9bdb-4f2c-b505-ff6d98451f1d"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[280.0]},"content":[{"type":"paragraph","content":[{"text":"enaio®","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[265.0]},"content":[{"type":"paragraph","content":[{"text":"DMS service – current version","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"rowspan":1,"colwidth":[386.0]},"content":[{"type":"paragraph","content":[{"text":"First release","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[280.0]},"content":[{"type":"paragraph","content":[{"text":"11.10 Final","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[265.0]},"content":[{"type":"paragraph","content":[{"text":"Version 6.5.0 (","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[386.0]},"content":[{"type":"paragraph"}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[280.0]},"content":[{"type":"paragraph","content":[{"text":"11.0 Final","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[265.0]},"content":[{"type":"paragraph","content":[{"text":"Version 6.2.1 (Mar 2024)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[386.0]},"content":[{"type":"paragraph","content":[{"text":"in July 2023 with version 6.0.0","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[280.0]},"content":[{"type":"paragraph","content":[{"text":"10.10 Final","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[265.0]},"content":[{"type":"paragraph","content":[{"text":"Version 5.5.3 (Mar 2024)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[386.0]},"content":[{"type":"paragraph","content":[{"text":"in July 2022 with version 5.2.2","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[280.0]},"content":[{"type":"paragraph","content":[{"text":"10.0 Final (out of maintenance)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[265.0]},"content":[{"type":"paragraph","content":[{"text":"Version 5.5.3 (Mar 2024)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[386.0]},"content":[{"type":"paragraph","content":[{"text":"in May 2021 with version 4.0.2","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[280.0]},"content":[{"type":"paragraph","content":[{"text":"9.10 Final (out of maintenance)","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[265.0]},"content":[{"type":"paragraph","content":[{"text":"Version 3.2.4","type":"text"}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[386.0]},"content":[{"type":"paragraph","content":[{"text":"in April 2020 with version 3.0.0","type":"text"}]}]}]}]},{"type":"paragraph","content":[{"text":"Our general version management looks like this:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Major","type":"text","marks":[{"type":"strong"}]},{"text":" version number change (","type":"text"},{"text":"2.","type":"text","marks":[{"type":"strong"}]},{"text":"3.4): breaking changes. ","type":"text"},{"text":"NOT","type":"text","marks":[{"type":"strong"}]},{"text":" backwards compatible. Please check the Changelog.","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Minor","type":"text","marks":[{"type":"strong"}]},{"text":" version number change (2.","type":"text"},{"text":"3.","type":"text","marks":[{"type":"strong"}]},{"text":"4): new features plus fixed problems - backwards compatible","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Patch","type":"text","marks":[{"type":"strong"}]},{"text":" version number change (2.3.","type":"text"},{"text":"4","type":"text","marks":[{"type":"strong"}]},{"text":"): fixed problems only - backwards compatible","type":"text"}]}]}]}]},{"type":"layoutColumn","attrs":{"width":33.33},"content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"minLevel":{"value":"1"},"maxLevel":{"value":"4"},"outline":{"value":"false"},"style":{"value":"none"},"type":{"value":"list"},"printable":{"value":"true"}},"macroMetadata":{"macroId":{"value":"38f6d1e7-9b73-4eb7-b778-9db002d76bdd"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"e4f42bee-cf71-4304-9387-7c5e270cff4d"}}]}]},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":100.0},"content":[{"type":"heading","attrs":{"level":1},"content":[{"type":"emoji","attrs":{"id":"atlassian-warning","text":":warning:","shortName":":warning:"}},{"text":" Breaking Changes – DMS service for enaio® version 6.0.0 (as of enaio® 11.0.0)","type":"text"},{"type":"inlineExtension","attrs":{"extensionType":"com.atlassian.confluence.macro.core","extensionKey":"anchor","parameters":{"macroParams":{"":{"value":"3d12f6b2-d635-40eb-9aa3-bf8f9cff9165"},"legacyAnchorId":{"value":"id-1.GeneralInformation-3d12f6b2-d635-40eb-9aa3-bf8f9cff9165"}},"macroMetadata":{"macroId":{"value":"c8f228ed-2f76-4e73-a47e-b45a182c6d81"},"schemaVersion":{"value":"1"},"title":"Anchor"}},"localId":"c13c08bd-9f76-443d-8b1d-cf4f3d8b2a50"}},{"text":" ","type":"text"}]},{"type":"paragraph","content":[{"text":"The DMS service for enaio® 6.0.0 – which is available as of enaio® version 11.0.0 comes with some breaking changes. ","type":"text"},{"text":"They provide a more uniform API and avoid the output of not requested data in the search result. ","type":"text","marks":[{"type":"textColor","attrs":{"color":"#172b4d"}}]},{"text":"Please read the following information carefully and check/adjust your custom code accordingly.","type":"text"}]},{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{"maxLevel":{"value":"2"},"minLevel":{"value":"2"},"type":{"value":"flat"}},"macroMetadata":{"macroId":{"value":"6f8e1e48-3996-47fd-b2b8-558a3fc15c14"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"aeb6747f-7005-48f2-b0a0-c00286c02879"}}]}]},{"type":"layoutSection","content":[{"type":"layoutColumn","attrs":{"width":50.0},"content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"Native Search Endpoint","type":"text"}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"/objects/search/native","type":"text","marks":[{"type":"link","attrs":{"href":"https://enaiodevelop.atlassian.net/wiki/spaces/DA/pages/21399126"}}]},{"text":" search endpoint was removed. Please use ","type":"text"},{"text":"/objects/search","type":"text","marks":[{"type":"link","attrs":{"href":"https://enaiodevelop.atlassian.net/wiki/spaces/DA/pages/21398964"}}]},{"text":" instead.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Default Job Options","type":"text"}]},{"type":"paragraph","content":[{"text":"By default, the following server job options in ","type":"text"},{"text":"GetResultList","type":"text","marks":[{"type":"code"}]},{"text":" are no longer queried in ","type":"text"},{"text":"/objects/search","type":"text","marks":[{"type":"code"}]},{"text":". ","type":"text"},{"type":"hardBreak"},{"text":"It is now necessary to set them manually in the query options (see below).","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Status: 1","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"FileInfo: 1","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Rights: 1","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Variants: 1","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"paragraph","content":[{"text":"By default, the object icon based on an icon catalog on the form is no longer queried in ","type":"text"},{"text":"/objects/search","type":"text","marks":[{"type":"code"}]},{"text":". ","type":"text"},{"type":"hardBreak"},{"text":"It is now necessary to query it manually with the query option:","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"Icon: 1","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Native Options","type":"text"}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"nativeOptions","type":"text","marks":[{"type":"code"}]},{"text":" were replaced by ","type":"text"},{"text":"options","type":"text","marks":[{"type":"code"}]},{"text":" in ","type":"text"},{"text":"/objects/search","type":"text","marks":[{"type":"code"}]},{"text":" query JSON","type":"text"}]},{"type":"paragraph","content":[{"text":"OLD (line 6 onwards)","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":"{\n \"statement\" : \"SELECT * FROM sysemail WHERE email = @emailAddress AND sysfrom IN @from AND CONTAINS(@text)\",\n \"skipCount\" : 0,\n \"maxItems\" : 50,\n \"handleDeletedDocuments\" : \"DELETED_DOCUMENTS_EXCLUDE\",\n \"nativeOptions\": {\n \"includePermissions\": true,\n \"registerContext\": true,\n \"exportDepth\": 5\n }\n}","type":"text"}]},{"type":"paragraph","content":[{"text":"NEW (line 6 onwards)","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":"{\n \"statement\" : \"SELECT * FROM sysemail WHERE email = @emailAddress AND sysfrom IN @from AND CONTAINS(@text)\",\n \"skipCount\" : 0,\n \"maxItems\" : 50,\n \"handleDeletedDocuments\" : \"DELETED_DOCUMENTS_EXCLUDE\",\n \"options\": {\n \"Rights\": 1,\n \"RegisterContext\": 0\n \"ExportDepth\": 5,\n \"Baseparams\": 1\n }\n}","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Top Level Parameters","type":"text"}]},{"type":"paragraph","content":[{"text":"Top level parameters in ","type":"text"},{"text":"/objects/search","type":"text","marks":[{"type":"code"}]},{"text":" query JSON were moved to the above mentioned ","type":"text"},{"text":"options","type":"text","marks":[{"type":"code"}]},{"text":" object:","type":"text"}]},{"type":"paragraph","content":[{"text":"OLD (lines 5/6/7)","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":"{\n \"statement\" : \"SELECT * FROM sysemail WHERE email = @emailAddress AND sysfrom IN @from AND CONTAINS(@text)\",\n \"skipCount\" : 0,\n \"maxItems\" : 50,\n \"baseParameter\" : true,\n \"exportDepth\" : 5,\n \"includePermissions\" : true,\n \"handleDeletedDocuments\" : \"DELETED_DOCUMENTS_EXCLUDE\",\n }\n}","type":"text"}]},{"type":"paragraph","content":[{"text":" NEW (line 6 onwards)","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":"{\n \"statement\" : \"SELECT * FROM sysemail WHERE email = @emailAddress AND sysfrom IN @from AND CONTAINS(@text)\",\n \"skipCount\" : 0,\n \"maxItems\" : 50,\n \"handleDeletedDocuments\" : \"DELETED_DOCUMENTS_EXCLUDE\",\n \"options\": {\n \"ExportDepth\": 5,\n \"Baseparams\": 1,\n \"Rights\": 1,\n }\n}","type":"text"}]},{"type":"paragraph"}]},{"type":"layoutColumn","attrs":{"width":50.0},"content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"System Fields in ","type":"text"},{"text":"/objects/search","type":"text","marks":[{"type":"code"}]}]},{"type":"paragraph","content":[{"text":"In the result JSON, the following system fields are now of type ","type":"text"},{"text":"Integer","type":"text","marks":[{"type":"strong"}]},{"text":" instead of ","type":"text"},{"text":"String.","type":"text","marks":[{"type":"strong"}]},{"text":" ","type":"text"},{"type":"hardBreak"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_FLAGS","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_MAIN","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_CO","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_MEDDOCID","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_LINKS","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_SYSTEMID","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_INDEXHISTFLAGS","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_DOCHISTFLAGS","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_MIMETYPEID","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_SIGNSTATE","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_PDFANNOTATIONCOUNT","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_TXTNOTICECOUNT","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:SDSTA_ID","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:SDREG_ID","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:SDREG_TYPE","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:REG_STAID","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:REG_PARID","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:FOLDERTYPE","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:PARENTREGTYPE","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:REG_COLAB","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:STAMM_COLAB","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_LOCATIONSCOUNT","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"paragraph","content":[{"text":"In the result JSON, the following system fields are now ","type":"text"},{"text":"ISO-DateTime","type":"text","marks":[{"type":"strong"}]},{"text":" strings instead of Unix timestamps.","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_DELETED","type":"text","marks":[{"type":"code"}]}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:OBJECT_CHECKOUTTIME","type":"text","marks":[{"type":"code"}]}]}]}]},{"type":"paragraph","content":[{"text":"The ","type":"text"},{"text":"OBJECT_USERGUID","type":"text","marks":[{"type":"code"}]},{"text":" system field that contains the owner, now contains the user name instead of the user guid. As do the system fields ","type":"text"},{"text":"system:createdBy","type":"text","marks":[{"type":"code"}]},{"text":" and ","type":"text"},{"text":"system:lastModifiedBy","type":"text","marks":[{"type":"code"}]},{"text":" which also contain user names instead of guids.","type":"text"}]},{"type":"paragraph","content":[{"text":"By default, if no search server job options are set, only ","type":"text"},{"text":"three system fields are returned","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:objectId","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:objectTypeId","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"system:baseTypeId","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"A new option is available for ","type":"text"},{"text":"SELECT * FROM MyObjectType WHERE …","type":"text","marks":[{"type":"code"}]},{"text":" to define which system fields are to be returned.","type":"text"}]},{"type":"paragraph","content":[{"text":"To return all system fields for the object type, set the option SystemFields with a star value","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":"{\n\t\"statement\" : \"SELECT * FROM sysemail WHERE email = @emailAddress AND sysfrom IN @from AND CONTAINS(@text)\",\n \"skipCount\" : 0,\n \"maxItems\" : 50,\n \"handleDeletedDocuments\" : \"DELETED_DOCUMENTS_EXCLUDE\",\n \t\"options\": {\n \t\"SystemFields\": [\"*\"]\n}\n}","type":"text"}]},{"type":"paragraph","content":[{"text":"To return only specific system fields in addition to all index data fields (because of the SELECT * FROM …) they can be listed seperated by a semicolon","type":"text","marks":[{"type":"strong"}]}]},{"type":"codeBlock","content":[{"text":"{\n\t\"statement\" : \"SELECT * FROM sysemail WHERE email = @emailAddress AND sysfrom IN @from AND CONTAINS(@text)\",\n\t\"skipCount\" : 0,\n \"maxItems\" : 50,\n \"handleDeletedDocuments\" : \"DELETED_DOCUMENTS_EXCLUDE\",\n \"options\": {\n \t\"SystemFields\": [\n\t\t\t\"system:OBJECT_LOCATIONSCOUNT\",\n\t\t\t\"system:OBJECT_PDFANNOTATIONCOUNT\"\n ]\n}\n}","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Table Conditions","type":"text"}]},{"type":"paragraph","content":[{"text":"A table column condition with a ","type":"text"},{"text":"<>","type":"text","marks":[{"type":"code"}]},{"text":" operator (not equal) will now also include NULL values. ","type":"text"},{"type":"hardBreak"},{"text":"A ","type":"text"},{"text":"conditionGroup","type":"text","marks":[{"type":"code"}]},{"text":" is created for ","type":"text"},{"text":"DMS.GetResultList","type":"text","marks":[{"type":"code"}]},{"text":" like this:","type":"text"}]},{"type":"codeBlock","content":[{"text":"\n \n \n \n \n \n \n \n IS-RR\n \n \n","type":"text"}]},{"type":"paragraph"}]}]}],"version":1}

Browser not supported