Welcome, Guest
Username: Password: Remember me

TOPIC: Capabilty to define LIMIT 0,30 in Grid Properties

Capabilty to define LIMIT 0,30 in Grid Properties 11 Aug 2012 19:38 #3100

  • e-struct
  • e-struct's Avatar
  • Offline
  • Senior Member
  • Posts: 76
  • Thank you received: 4
  • Karma: 5
Actually in Collection Definition Layout there is no capability to define LIMIT in the SQL call.
So by default the full database table is dumped by JCOOK collection layout.
How do you define this in COOK ... I mean what the way to setup this limit ?

SELECT *
FROM `joomla_table1`
LIMIT 0 , 30
Last Edit: 12 Aug 2012 08:42 by admin.
The administrator has disabled public write access.

Re: Capabilty to define LIMIT 0,30 in Grid Properties 12 Aug 2012 00:57 #3101

  • VeCrea
  • VeCrea's Avatar
  • Offline
  • Platinum Member
  • Absolute JCook fan
  • Posts: 473
  • Thank you received: 100
  • Karma: 30
If you really want to do that, try the "models" directory
The administrator has disabled public write access.

Re: Capabilty to define LIMIT 0,30 in Grid Properties 12 Aug 2012 06:47 #3103

  • e-struct
  • e-struct's Avatar
  • Offline
  • Senior Member
  • Posts: 76
  • Thank you received: 4
  • Karma: 5
Can you give a little more details?
What do you mean ? By coding .. I know..
But I mean from the interface adding this as a property if not already existing.
This is a thing to put on the TODO list.
Best case is to avoid most of edits after generation...
Last Edit: 12 Aug 2012 06:48 by e-struct.
The administrator has disabled public write access.

Re: Capabilty to define LIMIT 0,30 in Grid Properties 12 Aug 2012 07:43 #3104

  • BTB300
  • BTB300's Avatar
  • Offline
  • Moderator
  • Posts: 414
  • Thank you received: 130
  • Karma: 46
You Can Specify a field value range in Cook
In filters the { } filter = range
it is not configurable as part of the design process
but the range is then configurable in collection layouts
perhaps you could pre define the limits in the respective model

+1 for me
to specify the range / limit values in cook, perhaps in properties where we specify the range label...
Last Edit: 12 Aug 2012 07:43 by BTB300.
The administrator has disabled public write access.

Re: Capabilty to define LIMIT 0,30 in Grid Properties 12 Aug 2012 08:33 #3106

  • e-struct
  • e-struct's Avatar
  • Offline
  • Senior Member
  • Posts: 76
  • Thank you received: 4
  • Karma: 5
OK Thanks.
The administrator has disabled public write access.
Time to create page: 0.109 seconds

Get Started