limit the list in master-detail page to detail records

kurt2000 · Post by **kurt2000** » Sat Feb 22, 2014 3:15 am

how can i limit the list in master-detail page to detail records

thankx

mobhar · Post by **mobhar** » Sat Feb 22, 2014 9:02 am

Use "Recordset_Selecting" server event that belongs to detail table in order to filter the recordset based on the number of records you desire.

kurt2000 · Post by **kurt2000** » Sat Feb 22, 2014 7:56 pm

i mean how can i put record limit like 100 records for listing detail page

danielc · Post by **danielc** » Mon Feb 24, 2014 1:25 pm

If you use MySQL, use LIMIT to return specific number of records, see dev.mysql.com/doc/refman/5.0/en/select.html.

kurt2000 · Post by **kurt2000** » Mon Feb 24, 2014 7:27 pm

i am using postgresql 9.3 with postgis
and in view state it is impossible to use limit functions with spatial queries

of course i know how to do it in db but i ve to do it in phpmaker cause queryy sends me 4000 row that kills the page

if any one knows it pls help

mobhar · Post by **mobhar** » Mon Feb 24, 2014 7:37 pm

You don't have to limit too strict only 100 records for the listing page. However, as suggested before, try to use "Recordset_Selecting" by customizing the $filter parameter in the server event. For example, you may display only the records that match with your criteria filter, such as display all records that have the datetime of last updated yesterday only, etc.

Read "Server Events and Client Scripts" in the help file for more information.

kurt2000 · Post by **kurt2000** » Mon Feb 24, 2014 7:39 pm

hmm ok
that meas if i create seq in view and $seq_di < 100 is enough
thx alot

edigital · Post by **edigital** » Tue Feb 25, 2014 9:12 pm

How about to use database "view" (with only few records) instead table on listmaster ?

Problem is when you try to edit/add on that view..??? mmm

edigital · Post by **edigital** » Tue Feb 25, 2014 9:50 pm

mobhar wrote:
You don't have to limit too strict only 100 records for the listing page.
However, as suggested before, try to use "Recordset_Selecting" by
customizing the $filter parameter in the server event. For example, you may
display only the records that match with your criteria filter, such as
display all records that have the datetime of last updated yesterday only,
etc.

Read "Server Events and Client Scripts" in the help file for more
information.

Filter with LIMIT doesn't work...you must use another one...

edigital · Post by **edigital** » Tue Feb 25, 2014 11:02 pm

danielc wrote:
If you use MySQL, use LIMIT to return specific number of records, see
dev.mysql.com/doc/refman/5.0/en/select.html.

LIMIT filter doesn't work on Master/Detail list because LIMIT is already defined on number of records per page...

mobhar · Post by **mobhar** » Wed Feb 26, 2014 9:43 am

edigital wrote:
Filter with LIMIT doesn't work...you must use another one...

Yes, that's why I recommend to use "Recordset_Selecting" server event to modify the $filter that match with the search/filter criteria.