How can I get the returned result count from a search (Searc

Hi Byron,

You mean amount is a decimal field and when doing search you want to get the total of its column?

Regards,

Orchid

Didnt explain well, functional example:

On Account --> Records List Account I have a detailed search, after searching you get redirected to the Search Results Account page with list of matches. I want to count the number of rows returned and do something if there are no results returned and something else if there are results returned. Basically a record count.

I see, you have to create a detailed search too in the search result page then by code get the value of the field being filtered and assign that value the rbf_getCount2.

- Below image is a search result page, I also specified a detailed search above the list.
- When a user click the search button it takes over the value in the search field so there you assign that value the getCount. See code below, it works for me.

Note: It only works for "equal" and not for "contains"

<script>
	var filterVal = $("input[name='opValueDet1']").val();
	rbf_getCount2("137279", "product_code", filterVal, function(data) {
		alert(data);
	});
</script>

Hope this may help.

Regards,
Orchid

Thanks Orchid

Would there be an alternate solution for "starts with" or "contains" as we do not have one condition with "equal" as exact match searching isnt practical. I just really want the number or rows returned and display a message accordingly.

1. Edit the list view and go to "Totals and Subtotals" section > Specify the object name for counting.

2. After saving the list view this will add new rows at the bottom part says Grand total, beside it the # or record rows in the list. Now, in your search result page specify the code below.

<script>
$(document).ready(function() {
		var x = $("tr.listItem:last td.rbs_listSummaryNumber:eq(1)").text();
		if(parseInt(x) > 0) {
			alert("There are results: "+x);
		}
		else {
			alert("NO results: "+x);
		}
});
</script>

---------------ANOTHER WAY---------------

If you don't need the # or rows and just simply identify whether there are results, you can use the code below into your search result page.

<script>
$(document).ready(function() {
	var x = $("tr.listItem").length;
	if(x > 0) alert("There are results");
	else  alert("NO results");
});
</script>

Hope this may help.

Regards,
Orchid

Very nice thank you :-)

You're welcome!

Cheers,

Orchid