Working with Fluent Query Result Sets

Use the .field() method to get field values from a row in the result set.

Copy

var E = server.query.getAlias('entity');

var rows = server.query.from('entity', E)
    .top(5)
    .execute();

let output = '\n\nThe following entities were found:\n';
            
rows.map(function(r)
{
    output += (' ' + r.field(E.Name) + '\n')
});
            
log(output);

The code above will log an output similar to the following in the trace_roll.log file:

Copy

-[START]---------------------------------------
Timestamp: 7/2/2020 1:15:34 PM
 Message: INFO [CID=200524bb-8d28-4079-80c3-a003a9ecad7d] 

The following entities were found:
 entityBWTransitionActionGroup
 SystemUserSecurityRole
 BW
 optionset
 lookupCorrelationAttribute

 Severity: Information
-[END]---------------------------------------

Map result sets to POCO objects

Use the .executeAndMap() method to map a fluent query result set to an entity alias. This creates a plain old CLR object (POCO) which allows you to access field values as object properties, instead of using the .field() method.

Copy

var E = server.query.getAlias('entity');

var rows = server.query.from('entity', E)
    .top(5)
    .executeAndMap(E);

let output = '\n\nThe following entities were found:\n';
            
rows.map(function(r)
{
    output += (' ' + r.Name) + '\n')
});
            
log(output);

To map a fluent query result set to multiple entity aliases, use the .executeAndMapComplex() method.

Copy

var E = server.query.getAlias('entity');
var A = server.query.getAlias('attribute');

var rows = server.query.from('entity', E)
    .innerJoin('attribute', A)
        .on(E.EntityId.eq(A.EntityId))
    .top(20)
    .selectColumns(
        E.Name,
        A.Name)
    .executeAndMapComplex({ entity : E,  attribute : A});

rows.map(function(r)
{
    var entityName = r.entity.Name;
    var attrName   = r.attribute.Name;
            
    // do
            
});