Author: david
Date: Wed Aug 22 14:31:39 2012
New Revision: 12169

Log:
Add identifier to left and right side of select expression when looking for 
previous values in identifer+title sort.  Refs issue 1327.

Modified:
   trunk/lib/model/QubitInformationObject.php

Modified: trunk/lib/model/QubitInformationObject.php
==============================================================================
--- trunk/lib/model/QubitInformationObject.php  Wed Aug 22 13:52:23 2012        
(r12168)
+++ trunk/lib/model/QubitInformationObject.php  Wed Aug 22 14:31:39 2012        
(r12169)
@@ -1714,10 +1714,12 @@
           {
             $criteria->add('title',
               'CONCAT(
+                COALESCE(identifier, ""),
                 COALESCE((CASE WHEN (current.TITLE IS NOT NULL AND 
current.TITLE <> "") THEN current.TITLE ELSE source.TITLE END), ""),
                 LPAD(lft, 12, 0))
                 <
                CONCAT(
+                
COALESCE('.Propel::getConnection()->quote($current->identifier).', ""),
                 COALESCE('.Propel::getConnection()->quote($current->title).', 
""),
                 LPAD('.Propel::getConnection()->quote($current->lft).', 12, 
0))',
               Criteria::CUSTOM);

-- 
You received this message because you are subscribed to the Google Groups 
"Qubit Toolkit Commits" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/qubit-commits?hl=en.

Reply via email to