| # |
Jul 21st 2017, 14:01 |
gutts |
what about the having, how do i reference comments in relation to that? |
| # |
Jul 21st 2017, 14:00 |
gutts |
got that part |
| # |
Jul 21st 2017, 13:58 |
 chris-andre |
https://book.cakephp.org/3.0/en/orm/query-builder.html#passing-conditions-to-contain |
| # |
Jul 21st 2017, 13:56 |
gutts |
so queryBuilder is a magic keyword? |
| # |
Jul 21st 2017, 13:56 |
chris-andre |
I think you could `->contain(['Comments' => ['queryBuilder' => function ($q) { return $q->where(['Comments.user_id !=' => 2]])` |
| # |
Jul 21st 2017, 13:55 |
gutts |
initially i tried to do this within comments but i need the structure reversed to parse |
| # |
Jul 21st 2017, 13:55 |
gutts |
i have two models - posts and comments. posts has a hasMany->Comments and Comments belongsTo posts |
| # |
Jul 21st 2017, 13:54 |
gutts |
in the overall scheme i need to apply a where clause on a hasMany and also need a having count > 1 of comments. so i want all active posts that have at least one comment and its not written by X user |
| # |
Jul 21st 2017, 13:54 |
chris-andre |
Right, and what column is not found? Comments.user_id? |
| # |
Jul 21st 2017, 13:53 |
gutts |
sorry, i meant posts |
| # |
Jul 21st 2017, 13:53 |
chris-andre |
@gutts Singular Post, Is it a typo in your code or just here? |
| # |
Jul 21st 2017, 13:48 |
chris-andre |
You want to find active posts containing comments where the comments are not written by an $user_id. |
| # |
Jul 21st 2017, 13:48 |
gutts |
so what are my options? |
| # |
Jul 21st 2017, 13:47 |
gutts |
oh, i guess it's because hasMany relations aren't left joined? |
| # |
Jul 21st 2017, 13:46 |
gutts |
should I define that condition in a duplicate relation with that extra condition, or what? |
| # |
Jul 21st 2017, 13:46 |
gutts |
and $this->find() is within Post model |
| # |
Jul 21st 2017, 13:46 |
gutts |
err, with a $this->find()->contain('Comments') |
| # |
Jul 21st 2017, 13:46 |
gutts |
chris-andre - for ex my 'Post' model hasMany 'Comments', now im trying to $this->find()->where(['Post.is_active' => 1, 'Comments.user_id IS NOT' => 2 ]); |
| # |
Jul 21st 2017, 13:44 |
rquadling |
Hi @gutts |
| # |
Jul 21st 2017, 13:44 |
chris-andre |
@gutts Tried ->where([Table.column]) ? |
| # |
Jul 21st 2017, 13:44 |
gutts |
hi rquadling |
| # |
Jul 21st 2017, 13:40 |
gutts |
i assume that's what I have to do |
| # |
Jul 21st 2017, 13:40 |
gutts |
should I create a new relation with special conditions? |
| # |
Jul 21st 2017, 13:40 |
gutts |
I contained a hasMany relation table in my model, but when I do a ->where it says the column doesnt exist |
| # |
Jul 21st 2017, 13:25 |
adriencs |
thanks @chris-andre @neon1024 |
| # |
Jul 21st 2017, 13:20 |
maymeow |
how can i share access rights to folder between docker containers??? i have git containers and need write access for php-fpm container |
| # |
Jul 21st 2017, 13:17 |
cleptric |
Just ask your question here and someone may help you :slightly_smiling_face: |
| # |
Jul 21st 2017, 13:16 |
leso |
can sum1 help me |
| # |
Jul 21st 2017, 13:16 |
leso |
hello |
| # |
Jul 21st 2017, 13:07 |
rquadling |
I'm Richard Quadling. Been involved with Phinx for a couple of years. Contributor level.. |
| # |
Jul 21st 2017, 13:06 |
cleptric |
Hi :wave: |
| # |
Jul 21st 2017, 13:04 |
rquadling |
Hello all. |
| # |
Jul 21st 2017, 13:02 |
jay |
cheers |
| # |
Jul 21st 2017, 13:01 |
cleptric |
> You can invite someone to the CakePHP slack via the invite app: http://cakesf.herokuapp.com/ |
| # |
Jul 21st 2017, 13:00 |
jay |
Is cakesf invite only now? Colleague is getting 'contact admin for an invitation' ? |
| # |
Jul 21st 2017, 12:59 |
mirec |
inoas: you saying it may cause my problem or I should use some to avoid this problem? |
| # |
Jul 21st 2017, 12:57 |
inoas |
there are apache modules to auto-map subdirectories / subdomains |
| # |
Jul 21st 2017, 12:56 |
cleptric |
Nope, sorry |
| # |
Jul 21st 2017, 12:56 |
cleptric |
Ok, the problem comes from the `AssetMiddleware` |
| # |
Jul 21st 2017, 12:54 |
mirec |
to stay on "localhost/honey3/hiveadmin" and load "hiveadmin" controller |
| # |
Jul 21st 2017, 12:54 |
cleptric |
What are you expecting from happening? |