| # |
Mar 7th 2018, 09:39 |
 neon1024 |
Sure |
| # |
Mar 7th 2018, 09:34 |
birdy247 |
with an 'OR' key? |
| # |
Mar 7th 2018, 09:33 |
neon1024 |
I’d have just used `$query->where()` inside the foreach personally |
| # |
Mar 7th 2018, 09:33 |
neon1024 |
Blimey how complex! |
| # |
Mar 7th 2018, 09:31 |
birdy247 |
Seems to work |
| # |
Mar 7th 2018, 09:31 |
birdy247 |
File uploaded https://cakesf.slack.com/files/U0T295QA3/F9KP76TJ7/-.php / https://slack-files.com/T053DPNCM-F9KP76TJ7-da9fb8d666 |
| # |
Mar 7th 2018, 09:28 |
neon1024 |
Hopefully the Starbucks being built nearby will accept the Starbucks rewards |
| # |
Mar 7th 2018, 09:28 |
neon1024 |
One of the perils of working in the countryside, there is nowhere to pop out to |
| # |
Mar 7th 2018, 09:27 |
neon1024 |
I could really go a pastry this morning for some reason |
| # |
Mar 7th 2018, 09:26 |
admad |
Just adds extra work when upgrading |
| # |
Mar 7th 2018, 09:26 |
admad |
But silly to use it new code knowing it's already deprecated in newer version |
| # |
Mar 7th 2018, 09:24 |
neon1024 |
Might not be in the CakePHP version that Birdy is using |
| # |
Mar 7th 2018, 09:24 |
admad |
Stop using orWhere() it's deprecated |
| # |
Mar 7th 2018, 09:23 |
birdy247 |
I wondered if there was a more SQL way? |
| # |
Mar 7th 2018, 09:23 |
birdy247 |
File uploaded https://cakesf.slack.com/files/U0T295QA3/F9K9QUA4R/-.php / https://slack-files.com/T053DPNCM-F9K9QUA4R-8ffd466716 |
| # |
Mar 7th 2018, 09:23 |
birdy247 |
@admad This is my plan, but I am using this |
| # |
Mar 7th 2018, 09:21 |
admad |
You can by using the callback filter and building query yourself. |
| # |
Mar 7th 2018, 09:17 |
birdy247 |
but was wondering if its possible to instead (in the query), join firstname and lastname and then perform the Like on that? |
| # |
Mar 7th 2018, 09:16 |
birdy247 |
I know I can use a OR query and the like |
| # |
Mar 7th 2018, 09:16 |
birdy247 |
I am using the search plugin, and am wanting to enable a free text search i.e. "firstname lastname" |
| # |
Mar 7th 2018, 09:15 |
birdy247 |
in our users table we model first_name and last_name |
| # |
Mar 7th 2018, 09:13 |
birdy247 |
I am just trying to think up a use case... |
| # |
Mar 7th 2018, 09:12 |
birdy247 |
@admad I see, so its probably designed for the Crud view |
| # |
Mar 7th 2018, 08:59 |
marcusgoede |
File uploaded https://cakesf.slack.com/files/U260GELVA/F9KQXUZC4/-.php / https://slack-files.com/T053DPNCM-F9KQXUZC4-935c85a6f5 |
| # |
Mar 7th 2018, 08:59 |
marcusgoede |
good morning. anyone has an idea why my collection is not sorted? |
| # |
Mar 7th 2018, 08:56 |
admad |
@birdy247 no, on add/edit it popular vars for filling select options for related models |
| # |
Mar 7th 2018, 08:55 |
admad |
@birdy247 hehe, no problem |
| # |
Mar 7th 2018, 08:47 |
birdy247 |
Is this just a time saver over adding contains in the queries |
| # |
Mar 7th 2018, 08:47 |
birdy247 |
The Crud RelatedModels listener |
| # |
Mar 7th 2018, 08:47 |
birdy247 |
Morning @neon1024 |
| # |
Mar 7th 2018, 08:46 |
bravo-kernel |
:+1::skin-tone-3: |
| # |
Mar 7th 2018, 08:46 |
bravo-kernel |
@admad A promise unkept :,( |
| # |
Mar 7th 2018, 08:45 |
neon1024 |
Morning everypone |
| # |
Mar 7th 2018, 08:40 |
birdy247 |
I had to do something fairly urgent yesterday (which the client now doesnt want!), but will pick this up today and provide feedback :slightly_smiling_face: |
| # |
Mar 7th 2018, 08:39 |
birdy247 |
a day is 48 hours right ;) |
| # |
Mar 7th 2018, 08:39 |
admad |
@birdy247 i ain't gonna greet you cause you lied to me :P |
| # |
Mar 7th 2018, 08:13 |
birdy247 |
Morning |
| # |
Mar 7th 2018, 07:40 |
spexi |
Is it possible to add items to breadcrumbs in controller? |
| # |
Mar 7th 2018, 07:28 |
santosh.madeti |
how to get the last excuted query? |
| # |
Mar 7th 2018, 07:27 |
slackebot |
=> array('u.id', 'Patient.first_name', 'Patient.last_name'), 'order' => array('Patient.last_name ASC', 'Patient.first_name ASC')); How can I display the original mysql query? |
| # |
Mar 7th 2018, 07:27 |
slackebot |
$conditions['Patient.user_id'], ), 'u.id' => $conditions['Patient.user_id']), 'OR' => array( array('Patient.first_name LIKE' => '%'.$this -> data['Patient']['search_by_keywords'].'%', ), 'Patient.last_name LIKE' => '%'.$this -> data['Patient']['search_by_keywords'].'%'),'AND' => array('Patient.is_active = 1'),'AND' => array('Patient.user_id = '.$conditions['Patient.user_id'],'Patient.is_active = 1') ), 'fields' |