Forums

Hello to all,
I have this problem, could it possibly be a bug?

In View I have defined a Table that shows numerous entries, for this I also use the Paginator Widget.
Still in View I also imported a Widget Search to possibly retrieve data faster.
The problem is that if I search from the first page everything works fine.
If, on the other hand, I search after having changed the page through the paginator, the serach does not return anything.


In View:
Element Type: Paginator
Name: pg_colorinoems
Display: Navigation & Length switcher

Element Type: Search
Name: src_colorinoems

Element Type: Table
Name:tb_colorinoems
Data Provider:{var:fnrd_colorinoems}


In Events
Name: Index
Content:{fn:fnrd_colorinoems}
{view:src_colorinoems}
{view:tb_colorinoems}
{debug:}


In Function
Name: fnrd_colorinoems
Model: mod_colorinoems
Select type: All matching records.
Paging for multiple results: Enable
Page limit: empty
Offset: empty
Where conditions: mod_colorinoems.codice LIKE {data:keywords}%
OR
mod_colorinoems.abbr LIKE {data:keywords}%
​
Enabling debugging I see the following queries on the DB.

Search from the first page:
​
Array
(
[option] => com_chronoconnectivity6
[cont] => manager
[conn] => ccColoriNoEms
[startat] => 0
[keywords] => YOR b- S
)
Array
(
[fnrd_colorinoems] => Array
(
[log] => Array
(
[0] => SELECT COUNT(`mod_colorinoems`.`id_colorenoems`) AS `mod_colorinoems.count` FROM `Colori_no_ems` AS `mod_colorinoems` WHERE `mod_colorinoems`.`codice` LIKE 'YOR b- S%' OR `mod_colorinoems`.`colore` LIKE 'YOR b- S%' OR `mod_colorinoems`.`abbr` LIKE 'YOR b- S%';
[1] => SELECT `mod_colorinoems`.`id_colorenoems` AS `mod_colorinoems.id_colorenoems`, `mod_colorinoems`.`codice` AS `mod_colorinoems.codice`, `mod_colorinoems`.`colore` AS `mod_colorinoems.colore`, `mod_colorinoems`.`abbr` AS `mod_colorinoems.abbr` FROM `Colori_no_ems` AS `mod_colorinoems` WHERE `mod_colorinoems`.`codice` LIKE 'YOR b- S%' OR `mod_colorinoems`.`colore` LIKE 'YOR b- S%' OR `mod_colorinoems`.`abbr` LIKE 'YOR b- S%' ORDER BY `mod_colorinoems.id_colorenoems` ASC LIMIT 100;
)

[var] => Array
(
[0] => Array
(
[mod_colorinoems] => Array
(
[id_colorenoems] => 2723
[codice] => YOR b- S
[colore] => York Chocolate and White Bicolour
[abbr] => Chocolate and White Bicolour
)
)
)
)
)
​
Search from the second (or another) page:
​
Array
(
[option] => com_chronoconnectivity6
[cont] => manager
[conn] => ccColoriNoEms
[startat] => 100
[keywords] => YOR b- S
)
Array
(
[fnrd_colorinoems] => Array
(
[log] => Array
(
[0] => SELECT COUNT(`mod_colorinoems`.`id_colorenoems`) AS `mod_colorinoems.count` FROM `Colori_no_ems` AS `mod_colorinoems` WHERE `mod_colorinoems`.`codice` LIKE 'YOR b- S%' OR `mod_colorinoems`.`colore` LIKE 'YOR b- S%' OR `mod_colorinoems`.`abbr` LIKE 'YOR b- S%';
[1] => SELECT `mod_colorinoems`.`id_colorenoems` AS `mod_colorinoems.id_colorenoems`, `mod_colorinoems`.`codice` AS `mod_colorinoems.codice`, `mod_colorinoems`.`colore` AS `mod_colorinoems.colore`, `mod_colorinoems`.`abbr` AS `mod_colorinoems.abbr` FROM `Colori_no_ems` AS `mod_colorinoems` WHERE `mod_colorinoems`.`codice` LIKE 'YOR b- S%' OR `mod_colorinoems`.`colore` LIKE 'YOR b- S%' OR `mod_colorinoems`.`abbr` LIKE 'YOR b- S%' ORDER BY `mod_colorinoems.id_colorenoems` ASC LIMIT 100 OFFSET 100;
)

[var] => Array
(
)
)
)
​
I think the problem is related to the OFFSET added at the bottom of the query.
How can I go about deleting it?