Finance | Project Operations, Human Resources, ...

How to know which control calls the data source executeQuery method?

(0) Share

Report

Posted on by Ahmed Osama Ibrahim

332

Hello

There is a form named store transaction, this form by default opens with default date range.

Now I created a new button through the extension, this button will add a new range to dataSource

internal final class RetailTransactionTable_handler
{

    [FormControlEventHandler(formControlStr(RetailTransactionTable, ShowEReceipt), FormControlEventType::Clicked)]
    public static void ShowER_OnClicked(FormControl sender, FormControlEventArgs e)
    {
        QueryBuildRange qbrDate,status;

        FormDataSource fds = sender.formRun().dataSource(formDataSourceStr(RetailTransactionTable,TransactionTable));


        //fds.query().dataSourceNo(1).addRange(fieldNum(RetailTransactionTable,TransDate)).
        //   value(queryRange(fromDate,today()));

        fds.query().dataSourceNo(1).addRange(fieldNum(RetailTransactionTable,entryStatus)).
            value(strfmt("%1,%2",enum2str(RetailEntryStatus::Posted),enum2str(RetailEntryStatus::None)));

        fds.query().dataSourceNo(1).addRange(fieldNum(RetailTransactionTable,Type)).
            value(strfmt("%1",enum2str(RetailTransactionType::Sales)));

        fds.executeQuery();
            
    }

}

the standard execute query add range so if I added the range to the button, the standard range will replace my range

so I extended the executeQuery method, now I need to know which one calls the executeQuery method ( my button or standard functionality )

If standard functionality my range will be ignored, if the new button I will remove the standard range and put my range.

Sorry the post in the AX2012 community by wrong

Thanks

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi Ahmed osama

You are writing the code in the event handler or coc for execute query method. So both will be called.

Can you tell which range you want the form to be filtered? I mean only you want filter based on custom range or you need both range to be added?

Thanks,

Girish S.

Was this reply helpful? Yes No
Ahmed Osama Ibrahim 332 on at

Like (0)

Report

Dear Girish S

Thanks, sorry I didn't get it.

Is there any way to know which control calls the method ?

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

executeQuery will be called while opening the form and also during form refresh.

For your scenario you have called the executeQuery method on button clicked method. So the executeQuery method will be called from your button only.

Thanks,

Girish S.

Was this reply helpful? Yes No
Ahmed Osama Ibrahim 332 on at

Like (0)

Report

My code will be in executeQuery (COC) so the code will run twice with the button and while opening the form also

the new range will not be in the button because the executeQuery will replace my range with its range every time

Thanks

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (0)

Report

What you are trying to achieve?

Can you elaborate?

What type of button is "Show recipet"?

Thanks,

Girish S.

Was this reply helpful? Yes No
Ahmed Osama Ibrahim 332 on at

Like (0)

Report

What you are trying to achieve?

I just need to add a date range - but there standard range in the executeQuery, so the standard range replaces my range if I added the range code in the button.

So if I added range in the executeQuery, I will replace the standard range, I don't need to do that.

So I need to know which one calls the executeQuery method, the button, or while the form opens.

Do you know how I can know the executeQuery caller?

the type of showReceipt is button control .

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

If you think custom range is overriding the standard range, just add the standard range along with your custom range in the coc of executeQuery method.

I mean just add the range implemented in the standard along with your custom range.

Hope it's clear now...

Thanks,

Girish S.

Was this reply helpful? Yes No
Ahmed Osama Ibrahim 332 on at

Like (0)

Report

thanks, but I can't do that because I just need one range implemented.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (1)

Report
Normally if you write the code in COC or event handler - Code written by you and standard code will be concatenated. It will not be overridden.

As per your scenario you are adding range to 3 fields.

TransDate

EntryStatus

Type.

Now in the standard they have added below fields as a range.

Store

TransDate

OfflineRange.

All the 6 ranges will be applied as filter to the form except TransDate range. Because you can filter by either start date or end date or both start date and end date.

You cannot merge start date and end added by you and standard. So that's the reason why standard code is overridden and your custom code is added as date range.

So your issue will be related only to date range other ranges will be applied without any issue.

First you try to find out all the ranges applied to the form by adding query to the info log.

Thanks,

Girish S.

Was this reply helpful? Yes No
Ahmed Osama Ibrahim 332 on at

Like (1)

Report

Thanks, Girish S.

I solved it by creating a global variable

I appreciated your effort

Was this reply helpful? Yes No

Join the conversation

Community site session details

How to know which control calls the data source executeQuery method?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

How to know which control calls the data source executeQuery method?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates