How to change the Select target of SQL execution in Form

(0) Share

Report

Posted on by Ko Yamazaki

Hi Experts

The SQL by Form is taking a long time due to the execution of fields that are not needed.
(All items in the included data sources are being selected.)
To speed up the process, I would like to execute SQL only for the necessary fields.

My code is like this.

I am having trouble running the process even with the following code.

[ExtensionOf(formStr(SalesLineBackOrder))]
final class SalesLineBackOrder_Extension
{
/// <summary>
///
/// </summary>
/// <param name=/args/></param>

[DataSource]
class salesline
{
public void executeQuery()
{
QueryBuildDataSource qbds;
QueryBuildFieldList qbfl;

qbds = this.query().dataSourceTable(tablenum(salesline));
qbfl = qbds.fields();
qbfl.dynamic(false);
qbfl.clearFieldList();

super();
}
}
}