Get Record Count of List using javascript

[kingcarol]

I am trying to get the record count in a List Control using javascript before opening a report. This is because I want to prevent opening a report if there are over a certain number of records. I have tried the following 3 things and none of them work...

//the following one is from copying the one supplied by the defined Control to get record count 
var countRec = {dialog.componentname}.list1.RECORDCOUNT;

//I made the following one up
var count = {dialog.Object}._getListRecordCount('LIST1');

//I tried the following based on a thread in the forum
var myOb = {dialog.Object}.getControl('LIST1');
var countRec = myOb._data.length;

[kingcarol]

In case someone is curious, here is the whole thing I am trying to run...

//the following one is from copying the one supplied by the defined Control to get record count 
var countRec = {dialog.componentname}.list1.RECORDCOUNT;

//I made the following one up
var count = {dialog.Object}._getListRecordCount('LIST1');

//I tried the following based on a thread in the forum
var myOb = {dialog.Object}.getControl('LIST1');
var countRec = myOb._data.length;

if(countRec > 5000){
	alert('The report would have '+countRec+' records based on your search.  To prevent server overload, reports cannot be opened if they have more than 5000 records.  Please narrow down your search.');  
} else {
	if(countRec > 1000){
		var answer = confirm('The report requested has over 1000 records and will take several moments to open.  Is it OK to continue?');
		if(answer == true) {
			{grid.object}.runAction('ReportPayrollLedgerByEmp');
		} else {
			alert('The action to open the report has been cancelled.');
		}
	} else {
		{grid.object}.runAction('ReportPayrollLedgerByEmp');
	}
}

[Davidk]

I can never remember if there is a method to get a list count... however, here are a couple of ways to do this...

Your code does work...

var myOb = {dialog.Object}.getControl('LIST1');
var countRec = myOb._data.length;

Outside the List control...

var x = {dialog.Object}._listViewData.LIST1.length;

where LIST1 (I believe in caps) is the name of your list control.

And inside the List, in the onListDraw event you could save the count into a {dialog} namespace variable, and then use it elsewhere.

{dialog.Object}._myListCount = data.length;

[kingcarol]

Thanks, David, but I just tried the code below when 25,000 records were in the list control, and it ignored the count and just ran my action to open the report. This is being called by a button outside of the list control:

var countRec = {dialog.Object}._listViewData.LIST1.length;

if(countRec > 5000){
	alert('The report would have '+countRec+' records based on your search.  To prevent server overload, reports cannot be opened if they have more than 5000 records.  Please narrow down your search.');  
} else {
	if(countRec > 1000){
		var answer = confirm('The report requested has over 1000 records and will take several moments to open.  Is it OK to continue?');
		if(answer == true) {
			{grid.object}.runAction('ReportPayrollLedgerByEmp');
		} else {
			alert('The action to open the report has been cancelled.');
		}
	} else {
		{grid.object}.runAction('ReportPayrollLedgerByEmp');
	}
}

[Davidk]

First of all... yikes... 25,000 in the List control. How long does that take to load?

Anyway... I just tried this with your code... and if countRec is set below the threshold being tested, then the logic is ok. Do you have your List control set to Page data? Do you actually have 25,000 records loaded?

[kingcarol]

The list control is paginated to 50 records at a time, but the deffined control for record count shows the total of records in the query, the 25,000. I need to get the total count of the records because the report is based on CurrentListFilter and I don't want it to have too many records .... So that code I used is just returning the total of the paginated records?

[Davidk]

The List control, when "pageinated" holds that number of records... there are no more records in the list. You say you have a defined control that displays the total count... grab that.

[kingcarol]

I tried, see my first post.. It didn't work. It's the code Aloha gives you in their defined controls list for record count

[Davidk]

Sorry... can't resist... is Aloha the Hawaiian office of Alpha?

var countRec = parseInt($('{dialog.componentname}.LIST1.RECORDCOUNT').innerHTML);

The Defined Control, List-Record count, is a static text control, with data being rendered inside a <span> tag. So you need to get the innerHTML of the tag... where the value it. Then use parseInt to convert it to an integer.

[kingcarol]

David, thanks so much for your time. I tried, but when the defined control shows 23,182 records, your code returns 23

[kingcarol]

Well, now for some reason it is returning NaN

[Selwyn Rabins]

To get the number of rows in the List's Query (as opposed to the number of rows of data that the list is currently displaying) you can do this

var lObj = {dialog.object}.getControl('ID_of_your_list');
var count = lObj._state.recordCount;
alert(count);

obviously, if the list is not paginated then the number of rows shown in the list is the same as the number of rows in the list query (assuming that no client-side filter has been applied).

[Davidk]

And to use your static text control...

var countRec = $('{dialog.componentname}.LIST1.RECORDCOUNT').innerHTML;
countRec = countRec.replace(/,/g,"")
countRec = parseInt(countRec);

[kingcarol]

Thank you, thank you, thank you, Selwyn. That worked. My list is paginated to 50 and the count showed the total of around 25000, AND I used a filter list control to do some searching and it also returned the right count. YAY!!! I'm sure that will help others that are trying to get that list record count into their inline javascript.

[kingcarol]

David, thanks to you too!

[Jay Talbott]

Is there a way to get the count of the number of records in a list AFTER it has been filtered?
Thanks,
Jay

[kingcarol]

Have you tried using the List-Record Count that is under Defined Controls on a ux component?

[kingcarol]

I also use Selwyn's suggestion in this thread to get the count in order to use it in my code.

[Selwyn Rabins]

are you talking about a server-side filter or a client-side filter?

if you are using a server-side filter then my post from 12/18/2014 applies

var lObj = {dialog.object}.getControl('ID_of_your_list');
var count = lObj._state.recordCount;
alert(count);

if you are using a client-side filter then you can read the length of the _rData array property of the list. the _rData is the filtered data in the list

var lObj = {dialog.object}.getControl('ID_of_your_list');
var count = lObj._rData.length;
alert(count);

[Jay Talbott]

Thanks, Selwyn and Carol. Answered in less than 15 minutes. Where else can one get that type of support?
Selwyn, the client side is what I am interested in.
Thanks again.
Jay

[JetLi]

This is the code of Selwyn
var lObj = {dialog.object}.getControl('ID_of_your_list');
var count = lObj._state.recordCount;
alert(count);

How do I count the number of rows in a not yet synchronized data? The above code returns zero , when I tried to save and synchronize the data on a list control and then run the code above in a button the alert says 'undefined'.

[Selwyn Rabins]

This is the code of Selwyn
var lObj = {dialog.object}.getControl('ID_of_your_list');
var count = lObj._state.recordCount;
alert(count);

How do I count the number of rows in a not yet synchronized data? The above code returns zero , when I tried to save and synchronize the data on a list control and then run the code above in a button the alert says 'undefined'.

The code you are using is appropriate when you have applied a server-side query to List. Say for example you have a list that is based on a sql table. Say also that the list is paginated and you are displaying 10 rows of data per page. The query that the list is based on might have a large number of rows, but the List always only shows 10 record (unless you are on the Last 'page' of data - in which case the List might show less than 10 rows). But you want to know how many records are in the List query, not how many records the List is currently showing (which is 10). In this scenario, list._state.recordCount would give you the answer you want.

But your scenario is completely different. You want to know how many rows are in the list. The list data is in an array called _data. So you just need to return the length of this array. For example:

var lObj = {dialog.object}.getControl('ID_of_your_list');
var count = lObj._data.length;
alert(count);

In addition, the List documentation documents a method to get the number of unsynchronized updated, edits and deletes.

http://downloads.alphasoftware.com/A...DetailView.htm


{dialog.object}.countRecordsToSynch(listId)

[JetLi]

The code you are using is appropriate when you have applied a server-side query to List. Say for example you have a list that is based on a sql table. Say also that the list is paginated and you are displaying 10 rows of data per page. The query that the list is based on might have a large number of rows, but the List always only shows 10 record (unless you are on the Last 'page' of data - in which case the List might show less than 10 rows). But you want to know how many records are in the List query, not how many records the List is currently showing (which is 10). In this scenario, list._state.recordCount would give you the answer you want.

But your scenario is completely different. You want to know how many rows are in the list. The list data is in an array called _data. So you just need to return the length of this array. For example:

var lObj = {dialog.object}.getControl('ID_of_your_list');
var count = lObj._data.length;
alert(count);

In addition, the List documentation documents a method to get the number of unsynchronized updated, edits and deletes.

http://downloads.alphasoftware.com/A...DetailView.htm


{dialog.object}.countRecordsToSynch(listId)

Thanks so much! Hope you can point me in the right direction to enable lookup items availability when offline on a list control. the data are available but the problem is that lookup list are not available when offline.what could be the right property setting that I missed here?

[Selwyn Rabins]

Thanks so much! Hope you can point me in the right direction to enable lookup items availability when offline on a list control. the data are available but the problem is that lookup list are not available when offline.what could be the right property setting that I missed here?

unfortunately, i don't understand the question.