Friday, July 13, 2018

Example of Modifying a Data Source Query

The following code illustrates the necessary modifications on a form that
contains one data source related to the table InventTrans:



 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
public void init()
{
  QueryBuildDataSource dataSource;
  super();
  dataSource =
 this.query().dataSourceTable(tableNum(InventTrans));
 dataSource.addGroupByField(fieldNum(InventTrans,
ItemId));
 dataSource.addSelectionField(fieldNum(InventTrans,
  Qty), SelectionField::Sum);
}

Best Regards,
Hossein Karimi

No comments:

Post a Comment

Configure the Firewall on the Enterprise Portal Server

After you install Enterprise Portal, enable Web Server (HTTP) in Windows Firewall. If you do not enable the web server in Windows Firewall...