[Configuration Store] Features to Implement

[tharindu-b-hewage]

Remaining features to be implemented in the JDBC based Configuration Store for WSO2 IS

• [x] Multi-database support
• [ ] A Caching layer
• [ ] Support for HTTP PATCH
• [ ] Support for GET Resources, Attribute, Resource Type and File by ID.
• [ ] Pagination support
• [x] File management endpoint
• [ ] GET all resources per resource type and per-tenant domain
• [ ] Search API support: GET resources with multiple key,,value constraints joined by logical operator 'AND'. Ex: Get resources having Attribute1=v1 AND Attribute2=v2
• [ ] Tenant isolation support for Resource type
• [X] API documentation

[tharindu-b-hewage]

Support for a partial search.

Please refer to the https://github.com/wso2/product-is/issues/4426

[emswbandara]

With the PR to add the schemas for all the database types, we need to remove this logic [1] from the code as it becomes redundant in the master branch.

[1] https://github.com/wso2/carbon-identity-framework/blob/master/components/configuration-mgt/org.wso2.carbon.identity.configuration.mgt.core/src/main/java/org/wso2/carbon/identity/configuration/mgt/core/internal/ConfigurationManagerComponent.java#L152-L171