Does Grouping provides footer total

QuestionsDoes Grouping provides footer total
Jayashri Patil asked 11 years ago

Does Grouping provides footer total as well does it provide facility to add WHERE conditions to query?

11 Answers
Abu Ghufran answered 11 years ago

The grouping feature is somewhat limited in JQGrid (js component from github) as it works with paging.
You need to have high number of records in grid page to work properly.

Footer summary is doable but with some code level changes.

Jayashri Patil answered 11 years ago

So this mean, in grouping we can use sql query with where clause, correct? Also can you please provide code to show Footer summary?
Thanks in Advance

Abu Ghufran answered 11 years ago

Footer summary with grouping is not ready to release. It's still in development.
However another version of footer summary without grouping is available, that shows listing total, sub-total, grand total etc.

Jayashri Patil answered 11 years ago

Ok will wait for release of footer summary with grouping. But still for grouping I am unable to use where condition with dynamic variables. Like for example: "SELECT * FROM table WHERE id=".$id, if we hardcode id then its works but not for dynamic. Please help
Thanks

Abu Ghufran answered 11 years ago

Please check faq question in faq page.
Q) How to load grid based on $_POST data from other page?

Jayashri Patil answered 11 years ago

yes now post values work with version, can you please provide code for
"footer summary without grouping is available, that shows listing total, sub-total, grand total etc."
Thanks

Abu Ghufran answered 11 years ago

I've emailed you the demo.

Jayashri Patil answered 11 years ago

Thanks for demo, but the script doesn't work for me nothing shows in footer, I think JS functions of to set footer Data doesn't work. Please help.
Thanks

Abu Ghufran answered 11 years ago

This is available as a part of paid version.

Here is the link for demo
http://www.phpgrid.org/demo/demos/appearence/footer-row.php

PRANAV BATRA answered 11 years ago

can you please provide code for
"footer summary without grouping is available, that shows listing total, sub-total, grand total etc."
Thanks

Abu Ghufran answered 11 years ago

I've emailed you latest build.

Your Answer

20 + 14 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?