WebsiteBaker Community Forum

WebsiteBaker Support (2.13.x) => Modules => Topic started by: CodeALot on October 29, 2025, 10:11:34 PM

Title: OneForAll AnyItems snippet - skip first 1, 2 or 3 items?
Post by: CodeALot on October 29, 2025, 10:11:34 PM
I'd like to use the OneForAll Anyitems where it reads the records of a OFA section but skips the first X items. Any tips on how to achieve that? Maybe another parameter to tell Anyitems to do that?
Title: Re: OneForAll AnyItems snippet - skip first 1, 2 or 3 items?
Post by: sternchen8875 on October 30, 2025, 01:39:54 AM
i think, its a easy job, but i cannot test it

i add a 4th parameter and call it offset. offset specifies, how many records to skip from the beginning of a result set before starting to return the data

the other parameters

section_id - the section_id  ;-)
limit - How many items do you want to show?
order - true == ASC, false == DESC

some examples

the first 3 items
Code: [Select]
oneforall_anyitems(123, 3);
or
Code: [Select]
oneforall_anyitems(123, 3, true, 0);
the next 3 items, but not item #1 - #3
Code: [Select]
oneforall_anyitems(123, 3, true, 3); // LIMIT 3, OFFSET 3
only item #5
Code: [Select]
oneforall_anyitems(123, 1, true, 4); // LIMIT 1, OFFSET 4
i hope, it works