Documentum REST Services supports multiple select statements in a single request

Karthikeyan.Vaiyapuri

I have a requirement to fetch attributes information from data dictionary of different object types and construct a JSON response, I would like to know is there a way I can make a single request to Documentum dql rest services and get different set of results in single JSON.

Ex :

I have a different set of select statements which will query information from data dictionary object

a. select label_text,attr_name,read_only,is_hidden,not_null,domain_type,domain_length from dmi_dd_attr_info where type_name=<some_type_1> and attr_name in ('object_name','owner','custom_attr_specific_for_this_type')

b. select label_text,attr_name,read_only,is_hidden,not_null,domain_type,domain_length from dmi_dd_attr_info where type_name=<some_type_2> and attr_name in ('object_name','owner','custom_attr_specific_for_this_type')

I know we can make two different service request and get the response like mentioned below:

http://localhost:8080/dctm-rest/repositories/sandbox?dql="select label_text,attr_name,read_only,is_hidden,not_null,domain_type,domain_length from dmi_dd_attr_info where type_name=<some_type_1> and attr_name in ('object_name','owner','custom_attr_specific_for_this_type')"

http://localhost:8080/dctm-rest/repositories/sandbox?dql="select label_text,attr_name,read_only,is_hidden,not_null,domain_type,domain_length from dmi_dd_attr_info where type_name=<some_type_2> and attr_name in ('object_name','owner','custom_attr_specific_for_this_type')"

Instead is there a way to make request like http://localhost:8080/dctm-rest/repositories/sandbox?dql="select label_text,attr_name,read_only,is_hidden,not_null,domain_type,domain_length from dmi_dd_attr_info where type_name=<some_type_1> and attr_name in ('object_name','owner','custom_attr_specific_for_this_type'):select label_text,attr_name,read_only,is_hidden,not_null,domain_type,domain_length from dmi_dd_attr_info where type_name=<some_type_2> and attr_name in ('object_name','owner','custom_attr_specific_for_this_type')"

Thanks

Karthikeyan

bacham2

I don't know the answer but in your particular example, you could use a DQL UNION. You just need to add type_name to the select list to identify to which type each record belongs.