Hi,
Is it possible to order a detail table in the datamapper to the max/min? For example:
I have a page with i dynamic table. The record with the most detail entries is record number 567. It has 12304 detail line entries. Can i move to this record without knowing the record number?
Thanks in advance,
Martijn
Hello Martijn,
Unfortunately at the moment, “moving” between records is not possible, but you do have the ability to add the number of detail lines to your record. Create a new field (line_count, for example), and add a new extract field after your detail line extraction loop with the “Javacript” extraction mode. The expression should be something like: record.tables.details.length;
However, you can use a few things in Connect 1.3 to help you out in other ways, depending on what you’re trying to achieve. First, you can order your output by document length, in the Job Preset Sorting Options. There is a special field called <Document Length> for this purpose. Second, you can create Page Break Groupings in order to generate groups of certain size ranges, for example small, medium and oversized documents (for different enveloppe sizes).
Hope this helps,
~Evie