动态QueryRange

[ExtensionOf(classStr(SysQueryRangeUtil))]
final class SBXSysQueryRangeUtilClass_Extension
{
    [QueryRangeFunctionAttribute]
    public static str customerDefault()
    {
        return CustParameters::find().SBXAccountNum;
    }

}

 

 

测试：

class SBXRunableClass
{        
    /// <summary>
    /// Runs the class with the specified arguments.
    /// </summary>
    /// <param name = "_args">The specified arguments.</param>
    public static void main(Args _args)
    {
        Query q = new Query(queryStr(SBXSalesTable));
        QueryRun qr = new queryRun(q);
        SalesTable salesTable;
        while(qr.next())
        {
            salesTable = qr.get(tableNum(SalesTable));
            Info(strFmt("%1 -- %2", salesTable.SalesId, salesTable.CustAccount));
        }
    }

}

 

Advanced filtering and query syntax：

 

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/advanced-filtering-query-options?toc=/dynamics365/commerce/toc.json

Configure and filter workspaces：

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/fin-ops/get-started/configure-filter-workspaces?toc=/dynamics365/commerce/toc.json

Configuring a workspace

You can change the appearance and behavior of some workspaces by updating settings that apply to the whole workspace. When a workspace can be configured, the Action Pane includes a button that instructs you to click it to make configuration changes. For example, in the following illustration, the button is named Configure my workspace.

When you click the button, a dialog appears, where you can modify the predefined settings for the workspace. The specific settings that you see in this dialog vary by workspace, and depend on the specific controls and business data that are available in the workspace.

Filtering a workspace

Many workspaces let you filter the content that appears in them. The controls that are available might let you filter all the content in the workspace or only the content in a specific section of the workspace. The filters on workspaces can be lookups, combo boxes, free-form text fields, or other types of controls. However, every type of filter has the same effects, as described in the following sections.

Workspace-wide filters

You can filter the whole workspace by using a workspace-wide filter. A workspace-wide filter appears in the upper-left corner of the workspace. When you select a specific value in the drop-down list, the contents of the workspace are filtered based on that selection.

When you click to open the filter, you're presented with several options.

Select an option to filter the workspace based on that option.

Workspace section filters

If individual sections of the workspace have filters, you can filter each section separately. In the following illustration, the filter (the field that contains the text "Filter") is an example of a free-form text field filter.

 

 

As with a workspace-wide filter, select or enter a value in the field to filter the contents of the section.