Finance | Project Operations, Human Resources, ...

Answered

selectionChange() not working as expected

(0) Share

Report

Posted on by Faqruddin

1,883

Dears,

I have a basic simplelist form with a query as its data source, which includes two data tables with a common relation. My goal is to filter the grid using the bound controller WeekDays. Initially, it filters the records as expected. However, when I reload the form for the second time and try to filter, it throws an error: /Cannot create a record in RouteData (RouteData). The record already exists. I am puzzled as to why the selectionChange() function is not working as expected. Kindly review my code and provide insights.

Form Class :

QueryBuildRange qrWeek;
RoutMaster routMaster;

Form init():

public void init()
{
    super();

//   routMaster = element.args().record();
// Day.selection(WeekDays::Sunday);

// info(strFmt(/Day %1/,Day.valueStr()));
}

FormDataSource

public void executeQuery()
{

    QueryBuildDataSource queryBuildDataSource;
            queryBuildDataSource = this.query().dataSourceTable(tablenum(RoutMaster));
            queryBuildDataSource.clearRanges();
            queryBuildDataSource.addRange(fieldnum(RoutMaster, WeekDays)).value(queryValue(RoutMaster_1_WeekDays.selection()));

         super();

/* qrWeek = SysQuery::findOrCreateRange(this.query().dataSourceTable(tableNum(RoutMaster)), fieldNum(RoutMaster, WeekDays));

    if(RoutMaster_1_WeekDays.selection())
    {
        qrWeek.value(int2str(RoutMaster_1_WeekDays.selection()));
    }
    else
     {
    qrWeek.value(SysQuery::valueUnlimited());
   }
     super();*/

}

Combo Box:

public int selectionChange()
{
int ret;

ret = super();

RouteData_1_DS.executeQuery();
return ret;
}

I have the same question (0)

All responses (2)

Answers (1)

Martin Dráb 237,795 Most Valuable Professional on at

Like (0)

Report
First of all, let me make your code easier to read. I see that most of it is commented out and it can be simplified a bit.

RoutMaster_1 data source:

public void executeQuery() { QueryBuildDataSource qbds = this.queryBuildDataSource()); qbds.clearRanges(); qbds.addRange(fieldnum(RoutMaster, WeekDays)).value(queryValue(RoutMaster_1_WeekDays.selection())); super(); }

Combo Box:

public int selectionChange() { int ret = super(); RouteData_1_DS.executeQuery(); return ret; }
The error you mentioned is related to saving, not filtering. What is its stack trace?

By the way, the name of RoutMaster_1_WeekDays control suggests that it's a control bound to WeekDays field of RoutMaster_1 data source. If it's unbound, as you mentioned, you should change the name to avoid confusion.

Was this reply helpful? Yes No
Verified answer

Faqruddin 1,883 on at

Like (0)

Report

Its unbound control. The issue has been solved recompile the project.

Thank you.

Was this reply helpful? Yes No

Join the conversation

Community site session details

selectionChange() not working as expected

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

selectionChange() not working as expected

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