// Load dataset
var myLoadedQuery = query.load({
id: ‘custworkbook237’
});
// Add joins
var mySalesRepJoin = myLoadedQuery.autoJoin({
fieldId: ‘salesrep’
});
// Add the condition
var thirdCondition = mySalesRepJoin.createCondition({
fieldId: ’email,
operator: query.Operator.START_WITH_NOT,
values: ‘foo’
});