Good Day,

Can anyone enlighten me on my problem? I need a function or property of Grid to determine the Total Record Found(Filtered, not the total record in the table). I'm working with Offset/Pagination Grid

e.g.
I have 1 million records paginated by 100's

Then, for example: filtering the grid with bunch of filters, I want to know the total filtered record (say for example, the filtered records are 500,110). Is there any simple way to do or get the 500,110 without executing query? My filters consist of at least 50 filters., It is so hard to generate query from it.

Thank you in advance.

402

(11 replies, posted in SQL queries)

Any update on this? I'm on the same page with thezimguy.
I need to show the filtered record but I don't know what function to use.
It is also tedious work to query all filters just to show the total number of filtered record.
I have here a json on one of my PHP project.
Filtering the 4804 record, then paginating the filtered record (199) by 10.
I want to know if there's an existing function to use to get the recordsFiltered on the grid.
Thanks in advance.

403

(1 replies, posted in General)

Good Day!

Is there a way for me to comment couple/several of lines with just a shortcut e.g. Ctrl+/ after selecting the lines?

Thanks in advance

404

(2 replies, posted in General)

Thank you Dmitry.

405

(2 replies, posted in General)

Good Day!

I'm having trouble in report with filters  >, >=, < and <=. Other filters are working fine such as =, <>, etc.

Attached here is my sample.

Thank you.

PS: I'm using version 5.0