jacksonp
11/14/2019, 6:48 PMSandii
11/14/2019, 8:11 PMvar memberJoin = kitQuery.joinTo({
fieldId: 'member',
target: 'memberitem'
})
Sandii
11/14/2019, 8:13 PMtarget
from the xml object it provides for you if memberitem
is not correct.Sandii
11/14/2019, 8:17 PMvar queryMain = query.create({
type: query.Type.TRANSACTION
});
queryMain.condition = queryMain.and(
queryMain.createCondition({
fieldId: 'type',
operator: query.Operator.ANY_OF,
values: ['TrnfrOrd']
}),,
queryMain.createCondition({
fieldId: 'transactionlines.item^item.locations.location',
operator: query.Operator.ANY_OF,
values: fromLocation
})
)
queryMain.columns = [
queryMain.createColumn({
fieldId: 'transactionlines.item'
}),
queryMain.createColumn({
fieldId: 'transactionlines.units'
}),
queryMain.createColumn({
fieldId: 'transactionlines.units',
context: query.FieldContext.DISPLAY
}),
queryMain.createColumn({
fieldId: 'transactionlines.rate'
})
]
Sandii
11/14/2019, 8:17 PM