queryUsingPrimaryKeys()

Syntax

Concept[] queryUsingPrimaryKeys(String conceptURI, SimpleEvent pKeyEvent, boolean queryChildren)

Here conceptURI is the URI of the concept type, pKeyEvent is a simple event that contains primary key values to be used. Properties must match primary key properties in the result concept. If queryChildren boolean is set to true, concept properties are recursively queried. The function returns an array of result concepts.

Example

Database.setCurrentConnection("/SharedResources/ibmi");
Database.beginTransaction();
  EventsNew.ADBTEST1.TABLE_REFRING event = Event.createEvent("xslt://{{/EventsNew/ADBTEST1/TABLE_REFRING}}<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<xsl:stylesheet xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\" version=\"1.0\" exclude-result-prefixes=\"xsl xsd\">\n    <xsl:output method=\"xml\"/>\n    <xsl:template match=\"/\">\n        <createEvent>\n            <event>\n                <ID2>\n                    <xsl:value-of select=\"10\"/>\n                </ID2>\n            </event>\n        </createEvent>\n    </xsl:template>\n</xsl:stylesheet>");
Concepts.ADBTEST1.TABLE_REFRING [] parent = Database.queryUsingPrimaryKeys("/Concepts/ADBTEST1/TABLE_REFRING",event,true);
for(int k = 0 ; k < parent@length ; k++ ) {
   System.debugOut(Instance.serializeUsingDefaults(parent[k]));
}
Database.unsetConnection();