$XmlRepository.Query
Overview
Performs an xquery on repository and returns the results as string array.
Array<string> $XmlRepository.Query(xquery: string, parameters: object, collection: string)
Arguments
string xquery
Specifies the query to perform on the database.
object parameters
Specifies the binding parameters on xquery string.
string collection
Specifies the collection name to query. If not specified, the domain database will be queried.
Remarks
If query does not return any result than return value is empty array.
The examples below shows how to query the domain database.
The syntax of the query is quite detailed. More information can be found on xquery standard page. ,
Example
Find all customers
var results = $XmlRepository.Query('//Customer');
$Xml.InnerXml( 'Customer', results.join() );
Example
Find customer by id
var results = $XmlRepository.Query('//Customer[Id=$id]', {
id : $Xml.Evaluate('CustomerId')
});
$Xml.InnerXml( 'Customers', results.join() );
Example
Query Update
$XmlRepository.Query('for $customer in //Customer[Id=$id] return replace value of node $customer/Name with "Lady Gaga"', {
id : $Xml.Evaluate('CustomerId')
});
Example
Query Insert
Example
Query Delete
If you want to query the database of a process, you can use the collection keyword. You have to give the name of the database which is a GUID. For process databases, you can have that GUID by $Instance.ProcessId.
Example
See Also
XML+Database
Copyright © 2010 - 2023 Emakin. All rights reserved.