Technical Articles
Query folders base on created secondary type on folders of BTP document management service
In the blog Create Automatic UI using Custom Secondary Types using Document Management Service by Tapishnu Sengupta, the method of creating secondary type for Document Management Integration Option has been stated . One of our customers want to use this method to tags folders by function like Sales, Finance, Purchase, etc and then query the folders base on Secondary Type. In this blog , I will demo the steps in this blog and hope it will help :
Prerequisite:
1, You have created service instance and service key for BTP Document Management Service integration Option(BTP SDM) in BTP cockpit subaccount .
2,You have installed postman and Apache Chemistry CMIS Workbench .
Step 1, Get service key information from BTP cockpit .
Step 2 get access token by using service key Oauth2 information in Postman
Step 3, connect to BTP SDM repositary with Chemistry CMIS Work Bench .
Step 4 , Create Secondary type with Json file .
Prepare json file
{
"id": "functiongroup",
"localName": "Function Group",
"localNamespace": null,
"displayName": "Function Group",
"queryName": "functiongroup",
"description": "Function Group",
"baseId": "cmis:secondary",
"parentId": "cmis:secondary",
"creatable": true,
"fileable": true,
"queryable": true,
"fulltextIndexed": false,
"includedInSupertypeQuery": true,
"controllablePolicy": false,
"controllableACL": false,
"typeMutability": {
"create": true,
"update": true,
"delete": true
},
"propertyDefinitions": {
"function": {
"id": "functiongroup",
"localName": "Function Group",
"displayName": "Function Group",
"queryName": "functiongroup",
"description": "Function Group",
"propertyType": "string",
"cardinality": "single",
"updatability": "readwrite",
"inherited": true,
"required": false,
"queryable": true,
"orderable": true,
"openChoice": true
}
}
}
create secondary type by using the json file
Created secondary type
Step 5, Assign secondary type for folder
Step 6, Maintain function group for folder
Step 7, query folders base on function group
The following is the query statement :
SELECT * FROM cmis:folder JOIN functiongroup on cmis:folder.cmis:objectId = functiongroup.cmis:objectId WHERE functiongroup.functiongroup = ‘sales’
The Ends
Best Regards!
Jacky Liu
Nice Blog Jacky 🙂