Recid Count in real time when using modified method

(1) Share

Report

Posted on by Awaxx

229

Hi i need to count recId in real time in a modified method,

Is it possible or not ?

Because, i m counting element checked in a grid but when i m using modified method to perform some process and using count in there i didnt have the real count, if i unchecked a row i always have a difference of 1 in my count.

How to reach my goal please ?

Thanks.

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Waed Ayyad 9,214 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

What do you mean by in real time?

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
Martin Dráb 240,357 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You'll need to give us more information. We don't know what you mean by "not the real count", what you're counting at all and so on.

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report
Copy link

Link copied!

i'm counting the number of element which are checked in my grid on total of element of my grid to calculate percent of element checked in my grid and update a field to display the value

so when i modify my grid by checking or unchecking and element i want the value displayed to be refreshed with the real count

Was this reply helpful? Yes No
Martin Dráb 240,357 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Let me try to help to describe your situation.

You mentioned some database queries, therefore it seems that you store the information about "checked" records in database. If so, is it a field in the table with "elements" or in a separate table? If in a separate table, is it a persistent table or a temporary one? If you store it in a normal table, it means that the information about checked records is the same for all users. Please confirm these things.

Then please explain what problem you have with counting. How are you doing it and what result is your code giving instead of what you intended?

Was this reply helpful? Yes No
Martin Dráb 240,357 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

We already discussed this in a duplicate thread, but it disappeared. Maybe someone deleted the wrong one by mistake. [Update: for some reason, no replies were shown to me for some time.]

Let me quickly repeat what I said there. The description isn't good enough; we can't help you until you do a better job in explaining your implementation and your problem. Let me try to help you with that.

It seems that you store information about checked records in database. Is it correct? If so, where you store it? In the table of "elements", or in a separate table? If a separate one, is it a persistent table or temporary? If you use a persistent table, it means the checking of records is shared by all users.

Regarding the calculation, didn't you forget that the current record hasn't been saved yet if you run your calculation in modified()? I think you should calculate it after saving the record. If you agree with me, you've used a wrong method. modified() is run before saving; do it in write() (below super()) instead.

If you insist on calculating the value before saving, you must add or subtract the current record from the number you get from database.

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report
Copy link

Link copied!
here's the code of my modified method :

public boolean modified() { boolean ret; EUKChinaOrders chinaOrders = EUKChinaOrders_ds.cursor(); ret = super(); // Complete update order when checked and calculate score EUKChinaOrdersHelper.completeOders(chinaOrders); EUKChinaOrdersHelper.calculatePartOfCheckedOrders(chinaOrders.ordersId); return ret; }

and there how i calculate :

Public void calculatePartOfCheckedOrdersOrdersId _ordersId) { EUKchinaOrders totalOrders, ordersChecked, updateOrders; EUKScore score; int totalOrdersCount; int ordersCheckedCount; select count(RecId) from totalOrders where totalOrders.ordersId== _ordersId; totalOrdersCount = totalOrders.RecId; select count(RecId) from ordersChecked where ordersChecked.ordersId== _ordersId && ordersChecked.checked == true; ordersCheckedCount = ordersChecked.RecId; score = round((ordersCheckedCount /totalOrders) * 100, 0.1); select forupdate updateOrders where updateOrders == _ordersId if(updateOrders) { updateOrders.score = score; updateOrders.update(); } }

Was this reply helpful? Yes No
Verified answer

Martin Dráb 240,357 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Please respond to this part of my previous reply:

Regarding the calculation, didn't you forget that the current record hasn't been saved yet if you run your calculation in modified()? I think
you should calculate it after saving the record. If you agree with me, you've used a wrong method. modified() is run before saving; do it in
write() (below super()) instead.

Also, updating the table in calcCompletedScoreCoverage() is a bug. It assumes that the record was saved, but modified() gets calls before the record was saved and it may never be (because a validation fails, there is a network error or so). This may cause data inconsistencies.

And try to compile your code; you'll see that it doesn't even compile. When you make it compilable and runnable, you may spot another bug: you're updating a random record in EUKchinaOrders. According to the other code, there may be more than one record with the same ordersId while you're updating just one of them (without choosing which one). It might mean that even the data model is wrong.

Was this reply helpful? Yes No
Awaxx 229 on at

Like (0)

Report
Copy link

Link copied!

Ok i get it. I have migrate the calculation after the modification is done on the write() method now i have the real. I fixed the other points too it was juste a mistake when i paste my code it was missing a part for having the good id.

thank you martin

Was this reply helpful? Yes No