Does anyone know how to group the rows of data with a custom header for each group?
Example:
3 rows for 1-1-2022
3 rows for 1-5-2022
3 rows for 1-9-2022
I am looking to group the rows with a header for each date.
So something like this
header 1-1-2022
data
data
data
header 1-5-2022
data
data
data
header 1-9-2022
data
data
data
sort data
Re: sort data
I think thats not to be achieved within AG standard environment.
Maybe seems to be a topic for the Report Plugin?
Maybe seems to be a topic for the Report Plugin?
Re: sort data
Maybe the (new) clientside grouping functionality for TableViews can help, which will be part of upcoming version of (commercial*) AppGini Helper Javascript Library:
You can see a multi-level nested grouping on multiple fields in the above screenrecording.
There is a first draft of docs here:
https://www.appgini.de/docs/Javascript- ... uping.html
Sample code
* Ahmed has explicitely allowed me to post this answer, allthough the named library is a commercial product. Commercial products shall not be advertised in this community forum due to a community member's complaint.
You can see a multi-level nested grouping on multiple fields in the above screenrecording.
There is a first draft of docs here:
https://www.appgini.de/docs/Javascript- ... uping.html
Sample code
Code: Select all
jQuery(document).ready(function() {
var tv = AppGiniHelper.tv;
let group_by_currency = tv.groupBy("code").setText("Währung");
// apply grouping after adding group-definition(s)
tv.applyGrouping(true);
}
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: sort data
By the way:
There is exactly one "date" field in the example above. Nevertheless, the grouping functionality resolves two levels from that one given date-information: Year and Month.
This means the grouping feature allows you to split single values into parts and build nested groups. This is useful for example for dates (as shown above) and also for strings like "ORDER221206-nnnnnn" which can be split into "ORDER" (voucher type), "22" (year), "12" (month) and "06" (day) using standard javascript string-functions.
This could result in a "tree" like this:
There is exactly one "date" field in the example above. Nevertheless, the grouping functionality resolves two levels from that one given date-information: Year and Month.
This means the grouping feature allows you to split single values into parts and build nested groups. This is useful for example for dates (as shown above) and also for strings like "ORDER221206-nnnnnn" which can be split into "ORDER" (voucher type), "22" (year), "12" (month) and "06" (day) using standard javascript string-functions.
Code: Select all
ORDER221206-nnnnnn
^ ^ ^ ^---- day
| | +---- month
| +---- year
type
This could result in a "tree" like this:
Code: Select all
+ INVOICE
- ORDER
- 22
- 12
- 06
ORDER221206-253623 ...
ORDER221206-248122 ...
ORDER221206-248097 ...
+ 21
+ 20
+ 19
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: sort data
SO COOL!!!!!!!!! I will dive in. Thanks -JS-
Re: sort data
JS,
What file does this code need to go into?
TABLE-TV.js???????
What file does this code need to go into?
TABLE-TV.js???????
Re: sort data
Yes.
But did you read this feature will be part of NEXT version?
But did you read this feature will be part of NEXT version?
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: sort data
By the way: don't use uppercase "-TV" in Linux operating systems. This will work in Windows but not in Linux.
Kind regards,
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
AppGini 24.10 Revision 1579 + all AppGini Helper tools
<js />
My AppGini Blog:
https://appgini.bizzworxx.de/blog
You can help us helping you:
Please always put code fragments inside
[code]...[/code]
blocks for better readabilityAppGini 24.10 Revision 1579 + all AppGini Helper tools
Re: sort data
No I missed that, I was too dang exited. Please let me know when released! Thank you Sir.