Printing checked rows

[danh]

Does anyone know how to print the checked rows in a grid, similar to the filterCheckedRows method?

So, I have the checkbox column turned on and an action button in the grid toolbar that calls a report. From there I don't know how to define the filter so it will print only the selected rows.

Any ideas?

[Steve Workings]

Re: Printing checked rows

Dan -

If you use, say, an action button to run a callback, start with this in your callback:

CheckCount = val(e.checkboxRows.countChecked)
check_list = ""
if CheckCount > 0
	check_list = extract_all_strings(e.checkboxFilterArgumentXML,"<Data Type=\"C\">","</Data>",crlf(),.f.)
end if

check_list, in this case, will contain a crlf()-delimited list of the keys that were checked. Also note in this example the keys are Data Type = "C" and yours may well be numeric type.

With that list in hand, there are a few ways to create a SQL filter.

One I use most is to convert the crlf() list:

check_list = crlf_to_comma(check_list)

then use this to construct a SELECT statement

sql = "SELECT . . . . WHERE ID IN('" + check_list + "')"

When using the IN() clause for your SELECT statement, be aware that A5 portable SQL mostly doesn't know what to do with that clause, so set portableSQL off when you execute that.

I think this'll get you started.

[danh]

Re: Printing checked rows

Thanks, Steve

Yea, I can assemble the list of ID's no problem (can even do it in js), but how to get that list into the filer expression of the action that opens the report, in a format that it understands??

If I hard code the filter expression to something like: OrderID IN (1020,1022,1031,1050) it works. (and yes, my primary key is numeric)
but, if I assemble those same ID's and put them in an argument (has to be character and probably the problem) and then reference the argument like: OrderID IN (:whatIDList) it doesn't work!

Or, can I open a report from a callback like you started?

[agillbb]

Re: Printing checked rows

Dan, here's how to handle your filter expression.
Study this attached image.
Clipboard01.jpg
The JobIDList_Dummy is a local argument created using that "Define Arguments" button. It is not actually in the report, but the other 2 arguments are in the report for title display purposes only (nothing to do with the report's query).
Note the SQL Filter contains the IN statement.
Note there is reference to a Before execute event (javascript).

I define a function called beforeUserSelectReportRuns to swap the dummy argument with a list of IDs.

function beforeUserSelectReportRuns(ro) {
	var data = '';

       //your list goes here.....
	data = {Grid.Object}.harvestColumn('JOBID',',');
	//data = '1005,1026,1037';

	if(_AG_setArgumentValue(ro, 'JobIDList_Dummy', data)) {
		//alert('yea');
	}
}

And this function does the actual replacement:

function _AG_setArgumentValue(ro, argName, argValue) {

	//ro.sqlFilter = 'dbo_Jobs.JobID IN (:JobIDList_Dummy)';
	//ro.sqlOrder = 'dbo_Jobs.BQ_ProjectName';
	//ro.arguments = 'MyEmpCode|Character|SESSION.USERCODE||MyTitle|Character|Report - Selected Entries||JobIDList_Dummy|Character|1005,1026,1037';

	argName = ':' + argName;

	if(typeof ro == 'undefined') return false;
	var myfilter = ro.sqlFilter;
	var newfilter = '';

	if(myfilter.indexOf(argName)<0) return false;

	if(argValue.length>0) {
		newfilter = myfilter.replace(argName, argValue);
		ro.sqlFilter = newfilter;
		return true;
	}
	return false;
}

So this should work for you. Good luck.

[GGandhi]

Re: Printing checked rows

hello

this is how i did it and just checked, it works.
place two buttons on the grid,
first one name it " select to print" and the on click event define in text mode - {grid.Object}.filterCheckedRows(); use this to select after selecting the records.
second one name it "print" and on the on click event define an action javascript and select print report and fill in name of the report and the next line fill in "currentGridFilter()"
it will work as expected, at least here it does. please see my version number and build in case you need to know and i use mysql.
only problem i know about this method of printing using check boxes is--
say you have turned on check boxes and selected multiple pages in the check box property and happily you go about selecting few here and few in the next page and want to print it will only print the visible page items, however if you click the button that says all on the top ( i use quicksearch also in the grid) then it will show all the selected records and it will print.
is this you are looking for?
since then i have moved on to better selection of the records, which is what i am using now. not the check boxes any more.

[TheSmitchell]

Re: Printing checked rows

Thanks, Steve

Yea, I can assemble the list of ID's no problem (can even do it in js), but how to get that list into the filer expression of the action that opens the report, in a format that it understands??

If I hard code the filter expression to something like: OrderID IN (1020,1022,1031,1050) it works. (and yes, my primary key is numeric)
but, if I assemble those same ID's and put them in an argument (has to be character and probably the problem) and then reference the argument like: OrderID IN (:whatIDList) it doesn't work!

Or, can I open a report from a callback like you started?

Is this a MySQL database? You cannot use IN with numeric fields in MySQL! It will only compare everything up to the first comma and never look at the remaining list in your argument. I got bit by this recently. Use FIND_IN_SET. This post was super helpful: http://stackoverflow.com/questions/4...d-in-set-vs-in

[danh]

Re: Printing checked rows

Andy,

Your solution works! I did not see the beforeExecute event and not sure I would have known how to use it if I did. I had already figured out how to assemble the list of ID's so it was an easy task to finish it up.

Thank you very much!!

Is this a MySQL database? You cannot use IN with numeric fields in MySQL! It will only compare everything up to the first comma and never look at the remaining list in your argument.

And Sarah, yes it's a MySQL database. That's true if you are using a character argument type against a numeric field. And you can't really use any other type, because it's a string.
But, this will work, even if the OrderID field is numeric: OrderID IN (1021,1022,1023,1024)
That's where Andy's function comes it.

However, FIND_IN_SET looks interesting too. I will do some more testing.
I've got some good answers! Thanks to everyone!

[TheSmitchell]

Re: Printing checked rows

And Sarah, yes it's a MySQL database. That's true if you are using a character argument type against a numeric field. And you can't really use any other type, because it's a string.
But, this will work, even if the OrderID field is numeric: OrderID IN (1021,1022,1023,1024)
That's where Andy's function comes it.

However, FIND_IN_SET looks interesting too. I will do some more testing.
I've got some good answers! Thanks to everyone!

Ahhhh. I didn't catch that you were having trouble populating :whatIDList.

Well, at any rate...

WHERE FIND_IN_SET(OrderID, :whatIDList) (MySQL; non-portable; works for all data types)
WHERE OrderID IN :whatIDList (portable; may or may not crap out on you)
WHERE :whatIDList CONTAINS OrderID (portable; irritates A5 SQL Genie)

NOT IN is valid in Portable SQL syntax. I don't see why IN wouldn't be supported?

Of course, if you could find some other solution than using FIND_IN_SET for searching IDs, that'd probably be idea. The algorithm is slower than doing a long EQUAL/OR string: "ID = :val1 OR ID = :val2 OR ID = :val3 . . ."

I've been doing some extra searching today...

[compuaid]

Re: Printing checked rows

I used GGanhi's method of two buttons (Filter Checked Records) and a Print Icon that calls a menu of reports that are all filtered by CurrentGridFilter(). The result is great as it then allows my users to print any number of reports from the resulting filtered records. This also means that they can export to Excel only those records they checked and filtered. Thanks, GGandhi!

I use a custom search UX form and embedded the grid so I added the following inline Javascript to both my Search and Clear Search buttons to clear out any residual checkmarks and filtered records:

{dialog.EmbeddedGrid_GRDPROPERTIES}._selectAllRowCheckboxes(false);

GRDPROPERTIES is the alias I assigned to my embedded grid. This allows for a very customized search form and a really nice option for clients to search and then filter down their results.

[Rod Porter]

Re: Printing checked rows

I am trying to follow Andy's method in post #4 above to set a filter for a report in V-12. Everything seems to be working except I can not figure out how to get the ro argument value in the first function "function beforeUserSelectReportRuns(ro) {" I think this is a reference to the report object but I can't find a way to set it. I am calling this from the Client-side Grid System Events - (afterAjaxCallbackComplete)

Any thoughts would be greatly appreciated.
Thanks, Rod

[agillbb]

Re: Printing checked rows

Hi Rod,
Check the image that I had posted. You should see "beforeUserSelectReportRuns" listed as a event-driven function to be call - it is in the action javascript edit window near the bottom.
The "ro" argument gets passed automatically (by default, as the report object) to whatever function name you place there.
You are free to name it whatever you wish.
Good luck.
Andy.

[Rod Porter]

Re: Printing checked rows

Andy,

Thank you so much, sometimes I need a 2x4 upside the head to see what’s right in front of me. I had studied that image at least a dozen times but had not seen the “Before Execute Event”. I am now dealing with another issue but would never have moved on to this new problem without your help.

Thanks again, Rod