Query Capabilities of Governance Registry

zbeothy's picture

Hi,

I am currently evaluating the query capabilities of the Governance Registry and looked at http://wso2.org/project/registry/3.0.1/docs/developer_guide/custom_query.html. My basic understanding is that I am able to query for name, path version and all the other generic attributes, properties, tags, ratings, comments. What I am missing is the possibility to query for resource specific attributes, e.g. give me all services where one of he contact persons is X, for asociations and dependencies, e.g. give me all wsdls and schemas that depend on schema x, and for lifecycle specific information, e.g. give me all services that are in state "designed". How would I implement these kind of queries. One reason why I am evaluating these capabilities is that we want to extend the Governance registries with report capabilities.

Thanks, Zsolt

dimuthuc's picture

Association based queries are possible

Hi, You can query for resources based on association, lifecycle specific information. The only restriction to custom queries is you can only return a resources, tags, comments, ratings from a query. In that documentation we have put details only about the most used tables like resources, tags, comments and ratings. You can refer the complete table structure here, https://wso2.org/repos/wso2/trunk/carbon/distribution/carbon-home/dbscripts/h2.sql For queries with association check the association table. For queries with lifecycles you need to check the properties of the service. (the lifecycle information are stored in that way). Thanks Dimuthu
zbeothy's picture

Hi Dimuthu, seems that I can

Hi Dimuthu, seems that I can specify queries for all my samples but the first one, querying for resource specific attributes. The only solution I see there is to create for all attributes I want to query an additional corresponding property which I then query with all the hassle to keep both in sync. Or is there a smarter way to be able to formulate such queries as "give me all services where one of he contact persons is X". Regards, Zsolt  
library project main code
Learn Cloud
Learn
Cloud

The WSO2 Application Server is a reliable application server that can host your enterprise web applications. The WSO2 Application Server as a Service is offered in StratosLive, the WSO2 Platform as a Service. This article explains how a simple web application can be developed and deployed from Carbon Studio to the WSO2 Application Server...

Latest Webinar
Different groups within an organization need to monitor different Key Performance Indicators (KPIs) - An operations team will be interested in the response times of business services and loads of each service,..
Thursday, February 9th 2012, 09.00 AM (PST)

Thursday, February 9th 2012, 10.00 AM (GMT)