symql

symql copied to clipboard

Where criteria gets overruled if there is a $query->where('system:id', 15);

1

Usually you use the where criteria to select a record, but we would like to check if this record 15 has also a date equal to or later than today,...

wdebusschere

Cannot filter by Date/Time field

3

I can filter using datasources and in the admin interface with the query string `?filter%5Bdates%5D=end:%20earlier%20than%20today`. But using SymQL `->where('dates', 'end: earlier than today')` does nothing (does not filter results).

patrickyan

Multiple where conditions giving SQL error

4

Version: 0.6.2 (Symphony 2.2.5) I have the following in an event: ``` $products_query = new SymQLQuery(); $products_query ->select('name, brand, instances') ->from('products') ->perPage(999); foreach ($_SESSION['sym-cart'] as $key => $item) { $products_query->where('instances',...

DavidOliver

Exception when querying an empty section.

1

Error code: $query->select("*")->from("TestNewSection"); This causes an exception to be thrown from class.symql.php with the message: "SymQL: field '' does not exist" when referencing an empty section in Symphony 2.3. The...

jetbackwards

Count queries used for pagination may be very expensive

6

I recently had a massive performance issue with a rather big system, @brendo and @creativedutchmen will remember... MySQL was consuming way too much processor time. In the end it turned...

michael-e

Weird pagination results

2

As soon as I use a second "where" with "SymQL::DS_FILTER_OR", the number for "total-entries" in the pagination get's totally messed up. I think this might even be a bug in...

ghost