Showing results for 
Search instead for 
Did you mean: 
Nintex Newbie

Build data structure in apex for 3 related objects

Hello. I would like to generate document in DocGen with such data structure:

Opportunity -> CustomProducts -> CustomServices -> Vendors

So opportunity has many customProducts, and each customProduct has many custom services and so on.

I could do this in DocGen UI, but user wants to select vendor, and depends on the vendor we should have only customProducts and customServices related to particular vendor. This kind of filter I cannot do in DocGen UI.

So i decided to write apex code, which will do that filter and give me records by some field value on opportunity. I took example from here:


And, first of all, this example with mistake (there should be OpportunityLineItem, not Opportunity, as there is no connection between Product2 and Opportunity).


Secondly, it is very basic, there is no proper information, how to build such structure. There is no documentation i could find, for example, if i add object names to this method:


public Set<string> getChildRelationships(string objectName) {
        // Return a set of object names corresponding to the children for the objectName specified
        // In this example, there are no child objects.
        return new Set<string>();

How can i connect or use this (lets say i returned there Set of CustomProduct, CustomService strings) in method with SOQL query? I dont understand, how i should connect each related record to its parent in this method!

    public Loop.ExternalData.QueryResultSet query(Loop.ExternalData.QueryRequestInfo requestInfo) {
        // Provide data for each object in requestInfo.GetObjectNames()
        // Assume that the Document Package is run from the Opportunity
        Id opportunityId = requestInfo.RecordId;
        // Declare the variable to be returned.
        Loop.ExternalData.QueryResultSet queryResultSet = new Loop.ExternalData.QueryResultSet();
        // Loop through all objects requested. The QueryResultSet instance returned needs to contain a QueryResult instance for each object requested.
        for (string objectName : requestInfo.GetObjectNames()) {
            // Declare fields list for QueryResult instance
            List<string> fields = new List<string>();
            // Declare query result to add to QueryResultSet instance
            Loop.ExternalData.QueryResult queryResult = new Loop.ExternalData.QueryResult(objectName, fields);
            // set up fields list and query to get data for QueryResult instance
            if (objectName == opportunityProductObjectName) {
                List<string> queryFields = new List<string>();
                // Get list of fields from the Opportunity and Product objects
                Map<String, Schema.SObjectField> fieldMap = Schema.SObjectType.Opportunity.Fields.getMap();
                for (string fieldKey : fieldMap.keySet()) {
                fieldMap = Schema.SObjectType.Product2.Fields.getMap();
                for (string fieldKey : fieldMap.keySet()) {
                    fields.add(productFieldPrefix + fieldKey);
                    queryFields.add('Product2.' + fieldKey);
                // Since we added fields to the list, update the QueryResult instance
                queryResult = new Loop.ExternalData.QueryResult(objectName, fields);
                string query = string.format(
                    'SELECT {0} FROM Opportunity WHERE Id = Smiley SurprisedpportunityId',
                    new List<string>{ string.join(queryFields, ',') }
                // for each row of data returned by the query
                for (SObject record : Database.query(query)) {
                    // Store the values (as strings) from the record in the same order of the fields defined in the QueryResult instance
                    List<string> recordValues = new List<string>();
                    for (string field : queryFields) {
                        recordValues.add(getFieldValue(record, field));
                    // Add the values to the QueryResult instance rows
            // Add the QueryResult instance to the QueryResultSet instance
            // This needs to be done for every object specified in requestInfo.GetObjectNames(), regardless of whether data is required for the request.
        return queryResultSet;

Can you please provide some code example in my situation?! Or maybe better solution.



Labels: (1)
0 Kudos