How to set the relation of data source using query?

(0) Share

Report

Posted on by Marykate

139

Hello,

I have 2 tables, salesTable and custPackingSlipTrans.

How do I set the relation of datasource to the relation salesTable.salesId == CustPackingSlipTrans.OrigSalesId?

I tried the ff code below but it does not get the relations I need.

query = new Query();
qbds = query.addDataSource(tableNum(SalesTable));

qbds = qbds.addDataSource(tableNum(CustPackingSlipTrans));
qbds.relations(true);

info(query.dataSourceNo(1).toString());

This returns the query as

"SELECT * FROM SalesTable JOIN * FROM CustPackingSlipTrans ON SalesTable.SalesId = CustPackingSlipTrans.SalesId"

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Martin Dráb 237,926 Most Valuable Professional on at

Like (0)

Report
You can use addLink() to specify fields in code:

Query query = new Query(); QueryBuildDataSource salesTableDs = query.addDataSource(tableNum(SalesTable)); QueryBuildDataSource transDs = salesTableDs.addDataSource(tableNum(CustPackingSlipTrans)); transDs.addLink(fieldNum(SalesTable, SalesId), fieldNum(CustPackingSlipTrans, OrigSalesId));

Was this reply helpful? Yes No