SalesTableListPage query extension through X++

(0) Share

Report

Posted on by Hein Marx

G'day experts,

I'm currently struggling with an issue related to the SalesTableListPage query that is used on the SalesTableListPage form.

I'm trying to join a temporary table to the SalesTableListPage query based on records with a certain value linked to a financial dimension. When extending the existing SalesTableListPage query and adding the new temp table on SalesTable.SalesId == TmpTable.SalesId the records are correctly filterd but I need to do this through conditions in X code related roles linked to the current user.

Essentially, I need to do this, but conditionally in code:

The code I've tried so far assuming that it should happen on FormDataSourceEventType::QueryExecuting:

[ExtensionOf(formStr(SalesTableListPage))]
final class ACCSalesTableListPage_Extension
{

    [FormDataSourceEventHandler(formDataSourceStr(SalesTableListPage, SalesTable), FormDataSourceEventType::QueryExecuting)]
    public static void SalesTable_OnQueryExecuting(FormDataSource sender, FormDataSourceEventArgs e)
    {

        QueryBuildDataSource  queryBuildDataSource;

        queryBuildDataSource = sender.query().dataSourceTable(tablenum(SalesTable));
        queryBuildDataSource.clearRanges();
        queryBuildDataSource.addDataSource(tableNum(ACCRestrictCampusDimensionValueVCGPPTTmp_SalesTable));
        queryBuildDataSource.addLink(fieldnum(SalesTable, SalesId),fieldnum(ACCRestrictCampusDimensionValueVCGPPTTmp_SalesTable, SalesId));

    }

}

What am I missing here because the query doesn't seem to execute at all not even with an error?

Kind regards,

Hein

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

GirishS 27,843 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Hein Marx`,

Refer the sales table list page interaction class. In the initializeQuery method they will be adding the ProjTable to the query based on the condition. You can refer to that. You can create COC for initializeQuery method and add you temp table as datasource.

Interaction class will be mapped at SalesTableListPage form properties.

ClassName : SalesTableListPageInteraction.

Method name: initializeQuery.

Thanks,

Girish S.

Was this reply helpful? Yes No
Martin Dráb 239,118 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You definitely shouldn't add an extra ACCRestrictCampusDimensionValueVCGPPTTmp_SalesTable data source every time when the form query executes, such as when user filters or sorts the records. It should be done just once, when initializing the form.

By the way, why don't you simply add a table relation instead of using addLink()?

Was this reply helpful? Yes No