Finance | Project Operations, Human Resources, ...

Multi-table AOT query with Query::update_recordset

(2) Share

Report

Posted on by CU29041349-0

626

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)

Sort by

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

Like (0)

Report
Copy link

Link copied!

Please share your code for better understanding.

Was this reply helpful? Yes No
Layan Jwei 8,282 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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,940 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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 626 on at

Like (0)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

How is everything, Any update on it?

Was this reply helpful? Yes No