Finance | Project Operations, Human Resources, ...

How to correctly display the sum of the fields of selected rows in the form grid?

(0) Share

Report

Posted on by Shooowtek

845

Hello,

I have a requirement to display the total quantity sum of selected rows on my custom form. I used MultiSelectionHelper and it works for me, but not quite as required. It only works if I select the rows with using the SHIFT button.... If I select individual rows by selecting the blue checkmark (blue circle), the values do not sum up....

  public void markChanged()
        {
            MultiSelectionHelper helper = MultiSelectionHelper::construct();
            helper.parmDatasource(InventTrans_ds);
            InventTrans InventTransTmp;

            Qty qtySum;
            super();
            
            InventTransTmp = helper.getFirst();
            
            if (InventTransTmp.RecId)
            {
                while (InventTransTmp.RecId)
                {
                    qtySum -= InventTransTmp.Qty;
                    InventTransTmp = helper.getNext();
                }
            }
            plannedqty.realValue(qtySum);
        }

Can anyone suggest something?
Thanks.

All responses (13)

Answers (0)

Sort by

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

Like (0)

Report
Copy link

Link copied!
InventTransTmp = InventTrans_ds.getFirst(1)? InventTrans_ds.getFirst(1):InventTrans_ds.cusrsor(); while (InventTransTmp) { info (InventTransTmp.fieldname); InventTransTmp= InventTrans_ds.getNext(); }

Try this instead of multiselect class.
Shooowtek 845 on at

Like (0)

Report
Copy link

Link copied!

Hello Bharani Preetham Peraka,

Unfortunately, it doesn't work.
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you send the error or code? It is working I have tested it now.
Shooowtek 845 on at

Like (0)

Report
Copy link

Link copied!
I don't getting any error. It just doesn't sum up the quantity when I select the rows one by one, by selecting the blue marker (blue circle). It works as before, i.e. when I use SHIFT to select several rows....

public void markChanged() { InventTrans InventTransTmp; Qty qtySum; super(); InventTransTmp = InventTrans_ds.getFirst(1) ? InventTrans_ds.getFirst(1):InventTrans_ds.cursor(); while (InventTransTmp) { qtySum -= InventTransTmp.Qty; InventTransTmp = InventTrans_ds.getNext(); } plannedqty.realValue(qtySum); }
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

Have you debugged it? You are saying sum, but your code seems to be subtraction. The code will work like if you select multiple lines at a time like on clicking all rows select in form or by clicking ctrl and selecting a row. If it is not working means you need to debug it or give a info log for every loop. Then check what is mistake in you code.
Shooowtek 845 on at

Like (0)

Report
Copy link

Link copied!

Yes, in this case there is subtraction, because I only have negative values in the table.

I did some debugging and found that selecting a row by clicking on the blue marker does not trigger the markChanged method. Selecting a row by clicking directly on the row triggers this method.

Now the question if is a standard operation, or does my form have a bug? Because it is a bit strange....
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

So if this issue is resolved you can close the question and mark the answer which ever is worked and for your other question please open a new thread.
Shooowtek 845 on at

Like (0)

Report
Copy link

Link copied!

It was not completely resolved, because the question was left whether it is the correct operation that this method does not run when selecting a line through the blue marker/circle....

I thought it does not matter which way the row is selected
Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, Check this article

erpdax.wordpress.com/.../
Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

Can you let us know which form is that you are working? We cannot confirm if it is a bug from MS side or your custom code until unless we check the same.

Also as you said, it should not matter even if you directly select different records by giving ctrl or by clicking that blue Mark.