General

Re: Sorting a repeating table

nikos_gr — Tue, 09 Apr 2013 21:04:24 GMT

Thank you Patrick, I got it working with the code behind my query button in C# I modified the sql command by adding order by projectId DESC I have another issue though. I am trying to create a tracking mechanism for inserts, updates , deletes for sql. I used an example with database triggers. I have on my form a hidden field that gets the user name (windows login). After I hit the query button and the form populates with the data from the sql database, if I want to update a record and then hit submit, the form resubmits all the records back to sql. I just want to update just one record and send back to sql just this record. It also messes up who modified the records since the hidden field overwrites the rest of the records with the user name that did he update. I have a master detail control on my form and the repeating table is my master and there is a repeating section for the details. Thank you, Nick

Re: Sorting a repeating table

Patrick Halstead — Mon, 08 Apr 2013 04:36:36 GMT

No programming is needed for this, but you do need to either a) modify the view.xsl, or b) use our qRules add-on that has a command for sorting.

The first approach (modifying the xsl to include an xsl:sort operator) requires exporting the XSN as source files and then opening up view.xsl (or whichever view you have the control in). Search for the control. You'll have to add the custom xsl:sort attribute and that can be a little tricky. I am guessing there are a lot of examples in this forum if you search. I believe Greg Collins may have uploaded a sample too. If you can't find them, please send me email.

The second approach is easier (but it does require our qRules library). You can download a free trial of qRules from the Qdabra dot com web site and it will install a user guide that has an example of how to use the sort command.

Best of luck,

Patrick

Sorting a repeating table

nikos_gr — Fri, 05 Apr 2013 17:26:27 GMT

Hello, I have an InfoPath 2007 form and wish to sort by descending order a repeating table on a project number column. I tried several methods that found online that requires quite a lot of programming with no success. Anyone here that willing to help? Thank you