Start records from 5th based on drag sort order.

3 posts by 2 authors in: Forums > CMS Builder
Last Post: December 15, 2008   (RSS)

By rjbathgate - December 15, 2008

Hello,

I have a list page which does this:

Show Record 5
Show Record 6
Show Record n....

I.e. the first four records are not displayed – everything from 5 onwards is.

The records are to be displayed by Drag Sort Order (rather than num).

If they were sorted by num, I could just make the records section start from num = 5 (i.e. where num is at least 5).

However as they are ordered by drag sort order instead, is there any way I can make the records displayed start from the fifth record based on drag sort – something which will say:

Where dragsort order is at least 5.

Alternatively, where dragsort is not 1,2,3 or 4.

The problem I’m having is that the display order needs to be dragsortable – so I can’t just say where num is not 1,2,3 or 4.

On a side note, If it’s relevant, the first four records are displayed elsewhere on the page, but in a separate <foreach> run, which is limited to 4 records with ‘limit’ => ‘4’. They need to remain separate from the 5 + records.

I hope that makes sense,

Many thanks
Rob

Re: [rjbathgate] Start records from 5th based on drag sort order.

By Dave - December 15, 2008

Hi Rob,

Try adding the "offset" option like this:

'offset' => 5,

Let me know if that works for you.
Dave Edis - Senior Developer
interactivetools.com