runNamedQueryMultiBoLocalized

Runs a pre-defined query that is stored in the platform in the Report Manager. This method supports queries that are defined with multiple associated business objects.

Parameters

projectName
The name of the project.
moduleName
The name of the module.
objectTypeName
The name of the object type.
queryName
The name of the query.
filters
An array of filter objects for this query. The filters do not need to be runtime filters. Any filters that are already applied to the static query pertain. If a $$RECORDID$$ association filter is predefined in the query, a single associated record ID can be included in the request by specifying $$RECORDID$$ as the field name and the associated record ID as the value.
start
Defines the start position of the search. For example, if a query returns 5 results and you set the start value to 1, all 5 results are returned. If you set the start value to 4, the last 2 results are returned.
maximumResultCount
Limits the number of records returned. The maximumResultCount argument cannot exceed the max integer value of 2147483647, minus the start argument. Since the start argument is base 1, the maximumResultCount cannot exceed 2147483646.

Returns

A QueryMultiBoResult object is returned. The QueryMultiBoResult object contains the resulting records, a total count of the results, and a continuation token, if any. Each resulting record in the QueryMultiBoResult contains QueryMultiBoResponseColumn elements. Each QueryMultiBoResponseColumn element includes the module name, the business object name, and resulting data for the corresponding query defined display column. Each QueryMultiBoResponseColumn also contains a multiBoFieldIndex element. The multiBoFieldIndex element is used as an incremental index for a QueryMultiBoResponseColumn field that has the same name, module, and business object as another QueryMultiBoResponseColumn field. The first time a QueryMultiBoResponseColumn field is used, the multiBoFieldIndex element has a value of zero. The value of the multiBoFieldIndex element increases by one each time it is used. The displayValue element within each QueryMultiBoResponseColumn contains the translated value based on the user's locale.

Errors

ProjectDoesNotExistException
The project does not exist.
ModuleDoesNotExistException
The module does not exist.
ObjectTypeDoesNotExistException
The object type does not exist.
QueryDoesNotExistException
The query does not exist.
InvalidArgumentException
At least one of the arguments is invalid.
AccessException
The user does not have access to the module, business object, or record.
java.lang.Exception
A system error occurred when the request was being processed.

Sample request

<soapenv:Envelope 
	xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" 	xmlns:ws="http://ws.tririga.com" xmlns:dto="http://dto.ws.tririga.com">
   <soapenv:Header/>
   <soapenv:Body>
      <ws:runNamedQueryMultiBoLocalized>
         <ws:projectName></ws:projectName>
         <ws:moduleName>triProject</ws:moduleName>
         <ws:objectTypeName>triFacilitiesProject</ws:objectTypeName>
         <ws:queryName>triFacilitiesProject - Projects And Users Demo</ws:queryName>
                 <ws:filters>
                    <dto:Filter>
                      <dto:fieldName>$$RECORDID$$</dto:fieldName>
                      <dto:value>10596554</dto:value>
                    </dto:Filter>
                   <dto:Filter>
                       <dto:dataType>320</dto:dataType>
                       <dto:fieldName>triNameTX</dto:fieldName>
                       <dto:operator>16</dto:operator>
                       <dto:sectionName>RecordInformation</dto:sectionName>
                       <dto:value>Facility</dto:value>
                   </dto:Filter>
                 </ws:filters>
                 <ws:start>1</ws:start>
         <ws:maximumResultCount>2</ws:maximumResultCount>
      </ws:runNamedQueryMultiBoLocalized>
   </soapenv:Body>
</soapenv:Envelope>

Sample response

<soap:Envelope 
	xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" 	xmlns:xsd="http://www.w3.org/2001/XMLSchema" 	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   <soap:Body>
      <runNamedQueryMultiBoLocalizedResponse xmlns="http://ws.tririga.com">
         <out>
              <continuationToken xmlns="http://dto.ws.tririga.com">
                  <tokenString>B36189CC1AB8D7989B867AC33C218A63-1163464971156-0.9400269990980882</tokenString>
              </continuationToken>
              <queryMultiBoResponseHelpers>   
               <QueryMultiBoResponseHelper>
                  <boId>10003240</boId>
                  <queryMultiBoResponseColumns>
                     <QueryMultiBoResponseColumn>
                        <displayValue>Facility Project Test 1</displayValue>
                        <index>0</index>
                        <module>triProject</module>
                        <bo>triFacilitiesProject</bo>
                        <label>Name</label>
                        <name>triNameTX</name>
                        <multiBoFieldIndex/>
                        <section>RecordInformation</section>
                        <uom/>
                        <value>Facility Project Test 1</value>
                     </QueryMultiBoResponseColumn>
                     <QueryMultiBoResponseColumn>
                        <displayValue>Captital Project Test 1</displayValue>
                        <index>1</index>
                        <module>triProject</module>
                        <bo>triCapitalProject</bo>
                        <label>Name</label>
                        <name>triNameTX</name>
                        <multiBoFieldIndex/>
                        <section>RecordInformation</section>
                        <uom/>
                        <value>Captital Project Test 1</value>
                      </QueryMultiBoResponseColumn>
                     <QueryMultiBoResponseColumn>
                        <displayValue>Captital Project Test 2</displayValue>
                        <index>2</index>
                        <module>triProject</module>
                        <bo>triCapitalProject</bo>
                        <label>Name</label>
                        <name>triNameTX</name>
                        <multiBoFieldIndex>1</multiBoFieldIndex>
                        <section> RecordInformation</section>
                        <uom/>
                        <value>Captital Project Test 2</value>
                     </QueryMultiBoResponseColumn>
                     <QueryMultiBoResponseColumn>
                        <displayValue>John User</displayValue>
                        <index>3</index>
                        <module>triPeople</module>
                        <bo>triPeople</bo>
                        <label>Name</label>
                        <name>triNameTX</name>
                        <multiBoFieldIndex/>
                        <section> Details</section>
                        <uom/>
                        <value>John User</value>
                     </QueryMultiBoResponseColumn>
                  </queryMultiBoResponseColumns>
                  <recordId>10598779</recordId>
               </QueryMultiBoResponseHelper>
            </queryMultiBoResponseHelpers>
            <totalResults xmlns="http://dto.ws.tririga.com">1</totalResults>
         </:return>
      </:runNamedQueryMultiBoLocalizedResponse>
   </soap:Body>
</soap:Envelope>