Finance | Project Operations, Human Resources, ...

Multi-table AOT query with Query::update_recordset

(2) Share

Report

Posted on by CU29041349-0

604

Hello,

Not sure if it's possible - I haven't seen examples of this. I have an AOT query joining ProjTable, ProjForecastCost, and a custom table (MyProjTable) linked by ProjId. I'm trying to update a boolean flag on MyProjTable if it is returned in the query. I provide the field mapping to MyCustTable for this boolean flag field. When Query::update_recordset() is called, I get an error (something to the affect of "field 'projects' is not found on table 'projtable'"). Doesn't appear Query::update_recordset is widely used -- maybe for a reason?

I have the same question (0)

All responses (6)

Answers (0)

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

Please share your code for better understanding.

Was this reply helpful? Yes No
Layan Jwei 8,118 Super User 2025 Season 2 on at

Like (0)

Report

Please show us your full code and maybe take screenshot of your query and if u have any ranges

Was this reply helpful? Yes No
Anton Venter 20,346 Super User 2025 Season 2 on at

Like (0)

Report

Why don't you just use the regular update_recordset statement instead?

Was this reply helpful? Yes No
Suggested answer

RT-23081044-0 6 on at

Like (0)

Report

It looks like Query::update_recordset() might not be ideal for your complex join scenario. Instead, try using a while select loop to update the Boolean flag in MyProjTable

MyProjTable myProjTable; ProjTable projTable; ProjForecastCost projForecastCost;

while select forUpdate myProjTable join projTable on projTable.ProjId == myProjTable.ProjId join projForecastCost on projForecastCost.ProjId == projTable.ProjId { myProjTable.BooleanFlag = true; myProjTable.update(); }

thanks,

ramjee

Was this reply helpful? Yes No
CU29041349-0 604 on at

Like (0)

Report

@Bharani @Layan,

I will try to get some details in hopes you can help.

@Anton,

I did try a solution using SQL and update_recordset (yet to be validated) but as my form uses the AOT query, I was hoping to utilize Query::update_recordset instead. Otherwise, I would have to find all the range values and plug them into the SQL.

@RT-23081044-0,

This approach is just too slow for my needs.

Was this reply helpful? Yes No
CU07100805-0 2 on at

Like (0)

Report

How is everything, Any update on it?

Was this reply helpful? Yes No