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 236,394 Most Valuable Professional on at

Like (0)

Report
RE: How to set the relation of data source using query?

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