queryUsingConceptProps()

The queryUsingConceptProps() queries database using the property values in a concept instance.

Note: You cannot use queryUsingConceptProps() by specifying a value in the property that maps to a CLOB column.

Syntax

Concept[] queryUsingConceptProps(Concept qConcept, boolean queryChildren)

In this example, qConcept indicates that the concept database is queried for matching values from this concept. If queryChildren boolean is set to true, concept properties are recursively queried. The function returns an array of concepts.

Example

Database.setCurrentConnection("/SharedResources/MySQLConnection.sharedjdbc");
Database.beginTransaction();
  Concepts.test.test.test testConcept=Instance.createInstance("xslt://{{/Concepts/test/test/test}}<?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        <createObject>\n            <object>\n                <col_1>\n                    <xsl:value-of select=\"1\"/>\n                </col_1>\n                <col_2>\n                    <xsl:value-of select=\"&quot;Hi&quot;\"/>\n                </col_2>\n            </object>\n        </createObject>\n    </xsl:template>\n</xsl:stylesheet>");
Concepts.test.test.test[] result=Database.queryUsingConceptProps(testConcept,true);
for (int i=0;i<result@length;i++)
{
   System.debugOut("properties from DB are " + result[i].col_1 + " ," + result[i].col_2);
}
Database.unsetConnection();
Related reference