How to find Selected Row's count?

Dynamics 365 for Finance and Operations/AX Technical Forum
1

Hi,

I can loop through in Clicked method as below,

for (inv = InventTable_ds.getFirst(true) ? InventTable_ds.getFirst(true) : InventTable_ds.cursor(); inv; inv = InventTable_ds.getnext())
{

}

but before going through this loop, i want to find how may recoreds are selected on Grid.

How to accomplish this task?

Regards,

Mehul Thacker

2

Hello Mehul,

You can get the count of the number of records of the form’ s datasource shown on the form’s grid after the form is opened by the method numberOfRowsLoaded() on the form’s datasource:

public int numberOfRowsLoaded()

int numOfDSRecs;

;

numOfDSRecs = InventTable_ds.numberOfRowsLoaded();

3

Hi Shankar,

I have used this method, it gives total row count on grid!

i need Selected row count, could you suggest any othor approch?

Regards,

Mehul Thacker

4

void clicked()
{
FormDataSource fds;
Common common;
int counter;
;
super();

fdS = InventTable_DS;
for (common = fdS.getFirst(true) ? fdS.getFirst(true) : InventTable_DS.cursor(); common; common = fdS.getNext())
{
counter++;
}
info(int2str(counter));
}

5

Hi Fabricio,

I think this is the simplest way to get Selected row count, but this will lead to TWO FOR loops in code, one specially to get Selected row count & another for logic purpose!!

I think there should be some another way to reach at Selected row count…!

Regards,

Mehul Thacker

6

Hi Mehul!

I’m new in DAX, and my English is too bad …

select COUNT(RecId) from TableName where …

counter= TableName.RecId

It isn’t good for you?

If I don’t understand your question, then sorry! [:)]

7

I think there is no other way to do that , as fabrico suggested. Rather than using the same loop for two times use a map and insert the recid into that, so that you can even implement the remaining business logic in a class by using that map.

8

Hi Zoltan,

This will not give Selected Row Count insted it will result in LoadedRowCount.

9

Hi Zoltan,

This will not give Selected Row Count insted it will result in LoadedRowCount.

10

Hi Kranthi,

Ya, i didnt find any other way to do this.

And in case of MAP,

if i go with MAP then also Second loop will be needed to process MAP items one by one

so this will not reduce any code!!! there should be something to process selected items on the form!!!

it is very ugly that we are not able to get “selected rows count” straight a way! :frowning:

11

You need to process them, to know the count. Why do you want to know the count before processing?

Why do you think of reducing the code? Are you facing any bottlenecks in the code execution?

What exactly you are doing by selecting them?

12

I want to show progress bar while processing items, so to set progressbar count i need how many number of rows user has selected!

no i am not facing any bottlenecks in code execution but as good programming there should be one loop only to process items & any how we shuold get Selected Row count directly.!

13

You can get the number of in a grid selected rows by using

InventTable_ds.recordsMarked().lastIndex()

hope this helps

regards,

Max Dobbelstein

14

hi

i want show record when i am onelye selecteds how can i write a code .could u any ideas plz share me.

15

Hi there this might solve your problem

fsd = formdatasource

(fds.recordsMarked().lastIndex() > 1)

the recordsMarked returns an array with the selected records and the lastIndex method get’s the index of the last record in the array.

Kind regards,

Sparaxa