SymQL
Symphony Query Language
Pending#1: Pagination problems
-
-
- Nils
- Comment #1
- 07 Jun 10, 4:20 am
-
-
- nickdunn
- Comment #2
- 07 Jun 10, 7:56 am
Could you try:
var_dump(SymQL::getDebug());die;
This should dump out the JOIN and WHERE strings SymQL is creating. Sounds a bit like this hack isn’t working perhaps.
-
-
- nickdunn
- Comment #3
- 07 Jun 10, 7:57 am
While my data source returns the correct entries the pagination goes mad as it return the following information
Are you 100% sure the entries are correct but pagination not? SymQL doesn’t do anything clever with pagination values, it just gets them from the EntryManager. So if there’s a bug with this, it sounds like it could be with EntryManager.
-
-
- brendo
- Comment #4
- 07 Jun 10, 9:09 am
From what I understand there is a long running bug with the Taglist field that I think is causing this issue, not SymQL.
-
-
- Nils
- Comment #5
- 07 Jun 10, 3:11 pm
Brendan, do you know where this bug is caused inside the taglist field?
-
-
- Nils
- Comment #6
- 07 Jun 10, 4:28 pm
This is how the debug looks like:
Array
(
[queries] => Array
(
[Resolve section and fields] => 0
[Fetch entries] => 2
[Total] => 2
)
[sql] => Array
(
[joins] =>
LEFT JOIN
`sym_entries_data_13` AS t13_1
ON (e.id = t13_1.entry_id)
LEFT JOIN
`sym_entries_data_14` AS t14_1
ON (e.id = t14_1.entry_id)
LEFT JOIN
`sym_entries_data_18` AS t18_3
ON (e.id = t18_3.entry_id)
[where] =>
AND (
t13_1.value IN ('calendar')
OR t13_1.handle IN ('calendar')
)
OR (
t14_1.value IN ('calendar')
OR t14_1.handle IN ('calendar')
)
AND (
t18_3.value IN ('Nils')
OR t18_3.handle IN ('Nils')
)
)
)
-
-
- Nils
- Comment #7
- 07 Jun 10, 4:32 pm
The resulting variable $where returns this:
AND ( t37_1.value IN ('Nils') OR t37_1.handle IN ('Nils') ) AND ( t18_1.value IN ('Texte') OR t18_1.handle IN ('Texte') )
-
-
- Nils
- Comment #8
- 07 Jun 10, 4:32 pm
The resulting variable $where returns this:
AND ( t37_1.value IN ('Nils') OR t37_1.handle IN ('Nils') ) AND ( t18_1.value IN ('Texte') OR t18_1.handle IN ('Texte') )
-
-
- Nils
- Comment #9
- 07 Jun 10, 4:33 pm
Sorry - the edit function seems to be broken …
-
-
- nickdunn
- Comment #10
- 09 Jun 10, 7:27 pm
Brendan, could you elaborate on the Taglist bug please? Haven’t come across that one before.
-
-
- nickdunn
- Comment #11
- 08 May 11, 7:22 pm
To be closed.
I’m using this extension to build some custom data sources. In this case I’m trying to fetch entries that match the following conditions:
deutsche-tags) OR English tags (englische-tags)bereich).While my data source returns the correct entries the pagination goes mad as it return the following information
This would be the correct information:
I suppose the wrong entry count is a result of tags with the same name in the German and the English list but I’m not sure. Any idea how/where to fix this?
This is how the
grab()function of my data source looks like:public function grab(&$param_pool=NULL){ require_once(EXTENSIONS . '/symql/lib/class.symql.php'); $dsPage = ($this->_env['env']['url']['seite'] ? $this->_env['env']['url']['seite'] : 1); // Query $query = new SymQLQuery('stichwort'); $query->select(implode(', ', array( 'primaertitel', 'primaertext: formatted', 'sekundaertitel', 'primaersprache', 'bereich', 'bilder', 'datum', 'deutsche-tags', 'englische-tags' ))); $query->from('inhalte'); $query->where('deutsche-tags', $this->_env['env']['url']['tag']); $query->where('englische-tags', $this->_env['env']['url']['tag'], SymQL::DS_FILTER_OR); $query->where('bereich', $param_pool['ds-kontext'], SymQL::DS_FILTER_AND); $query->orderby('datum', 'desc'); $query->perPage(10); $query->page($dsPage); // Result $result = SymQL::run($query); return $result; }