Notifications
Announcements
Hi all,
I have2 datasourcesi want to exclude all fields from datasource 2 (EcoResProduct)
just showing ItemId field in a first datasource (InventTable)this my code
query1 = new query(); qbds = query1.addDatasource(tableNum(InventTable)); qbds.addSelectionField(fieldNum(InventTable,ItemId)); qbds1 = qbds.addDataSource(tableNum(EcoResProduct)); qbds1.relations(true); qbds1.joinMode(JoinMode::InnerJoin);
Please explain what exactly you want to achieve. You talk about showing fields, but you code is about a database query. These are two separate things.
You may want to select fields from database that you won't show in a form or report.
But if you know that you don't need any fields from EcoResProduct and you need this table just for some filters, don't use InnerJoin. Choose ExistsJoin instead.
thank you
I fully agree with goshoom . Here's an example:
static void Job1(Args _args) { InventTable inventTable; ItemId itemId; Query query; QueryBuildDataSource qbsInventTable, qbsEcoResProduct; QueryRun qr; ; query = new Query(); qbsInventTable = query.addDataSource(tableNum(InventTable)); qbsInventTable.addSelectionField(fieldNum(InventTable, ItemId)); qbsEcoResProduct = qbsInventTable.addDataSource(tableNum(EcoResProduct)); qbsEcoResProduct.relations(true); qbsEcoResProduct.joinMode(JoinMode::ExistsJoin); info(query.dataSourceNo(1).toString()); //SELECT ItemId FROM InventTable(InventTable_1) //EXISTS JOIN * FROM EcoResProduct(EcoResProduct_1) // WHERE InventTable.Product = EcoResProduct.RecId qr = new QueryRun(query); while (qr.next()) { inventTable = qr.get(tableNum(InventTable)); itemId = inventTable.ItemId; } }
thanks for this helpfull answer
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 763 Super User 2025 Season 2
André Arnaud de Cal... 413 Super User 2025 Season 2
Martin Dráb 284 Most Valuable Professional
