Notifications
Announcements
Hi all,
I want to write a batch class that allows it to add a line according to the objectid to the work order that has no line for all workorders. The code I wrote only adds for a work order. How can I return all work orders?
public void run() { EntAssetWorkOrderTable workOrder ; EntAssetObjectTable objecttable; EntAssetWorkOrderLine workOrderLine; ; #OCCRetryCount try { ttsbegin; while select workOrder { select firstonly objecttable where objecttable.ObjectID == workOrder.ObjectID_WM; if(objecttable) { if(workOrderLine.RecId == 0) { //workOrderLine.selectForUpdate(true); workOrderLine.WorkOrder = workOrder.RecId; workOrderLine.Object = objecttable.RecId; workOrderLine.JobType = workOrder.JobType; workOrderLine.insert(); } } } ttscommit; }
As Martin said, you are not selecting data before the control line. So it's empty.
But after the first insertion the line table has value. In the second loop (and other loops) it never skips the control because the table has first inserted record
You never put any value to workOrderLine variable, therefore it'll always be empty.
If you want to check if a record exists, you need tp make a request to database. Maybe you can use one of find*() methods on EntAssetWorkOrderLine table.
But I want it to run the insert if there is no record in the line. That's why I added the if condition line. How should I change it taking this into consideration?
public void run() { EntAssetWorkOrderTable workOrder ; EntAssetObjectTable objecttable; EntAssetWorkOrderLine workOrderLine; ; #OCCRetryCount try { ttsbegin; while select workOrder { select firstonly objecttable where objecttable.ObjectID == workOrder.ObjectID_WM; if(objecttable) { //clear workOrderLine or next line will create problem for you workOrderLine.clear(); if(workOrderLine.RecId == 0) { //workOrderLine.selectForUpdate(true); workOrderLine.WorkOrder = workOrder.RecId; workOrderLine.Object = objecttable.RecId; workOrderLine.JobType = workOrder.JobType; workOrderLine.insert(); } } } ttscommit; }
You need clear workOrderLine or you can delete workOrderLine.RecId control (it's meaningless anyway)
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 843 Super User 2025 Season 2
André Arnaud de Cal... 503 Super User 2025 Season 2
Martin Dráb 288 Most Valuable Professional
