| # |
Feb 3rd 2018, 22:50 |
hmic |
did you repair the tree to get the lft/rgt values right? |
| # |
Feb 3rd 2018, 22:49 |
hmic |
have you read how to query the tree in the docs? |
| # |
Feb 3rd 2018, 22:49 |
ahmed_bodi |
i need 2 and 3 |
| # |
Feb 3rd 2018, 22:49 |
ahmed_bodi |
Now when i do users->get(id, ['contain' => ['Referrals.Users']]) I only get myself |
| # |
Feb 3rd 2018, 22:48 |
ahmed_bodi |
@hmic yeah im having issues lol, So i've done all that. Created an app root and 3 additional items in the tree. with each of those referencing the last e.g. app->1->2->3 and the user i'm logged into is number 1. |
| # |
Feb 3rd 2018, 22:47 |
hmic |
i'm not on slack |
| # |
Feb 3rd 2018, 22:47 |
hmic |
fail! |
| # |
Feb 3rd 2018, 22:45 |
 davinci |
File uploaded https://cakesf.slack.com/files/U3J95PPD5/F93JP36DB/-.txt / https://slack-files.com/T053DPNCM-F93JP36DB-19b48354af - \Cake\Error\Debugger::log($response-andgt;getSelectTypeMap()); just returns this. |
| # |
Feb 3rd 2018, 22:43 |
davinci |
will try that. I couldn't change the depth Thought it'd be , just `... ::log($response, 7, 4);` |
| # |
Feb 3rd 2018, 22:40 |
hmic |
davinci: try $query->getSelectTypeMap(), maybe? |
| # |
Feb 3rd 2018, 22:40 |
davinci |
nm - found in book |
| # |
Feb 3rd 2018, 22:38 |
davinci |
how do I "increase the depth"? |
| # |
Feb 3rd 2018, 22:37 |
hmic |
but sometimes you need to tell it |
| # |
Feb 3rd 2018, 22:37 |
hmic |
cake usually guesses your types very well |
| # |
Feb 3rd 2018, 22:37 |
hmic |
it makes a hell lot of a difference if you bound value is 0 or '0' |
| # |
Feb 3rd 2018, 22:36 |
hmic |
but, i am very certain it does, but it's of the wrong type! |
| # |
Feb 3rd 2018, 22:36 |
hmic |
to see it in the dump, just increase the depth |
| # |
Feb 3rd 2018, 22:36 |
hmic |
:D |
| # |
Feb 3rd 2018, 22:36 |
hmic |
! |
| # |
Feb 3rd 2018, 22:36 |
hmic |
i can tell you? |
| # |
Feb 3rd 2018, 22:36 |
davinci |
trying to determine why the query doesn't appear to be using the value I think it should be using |
| # |
Feb 3rd 2018, 22:34 |
hmic |
davinci: whats the usecase? |
| # |
Feb 3rd 2018, 22:33 |
davinci |
Cake 3's query object has 'sql', which you can get by `->sql()`, and it also has 'params', which I cannot figure out how to access. Details of my problem here. Any help GREATLY appreciated. https://stackoverflow.com/questions/48602025/how-to-get-params-from-query-object-in-cakephp-3 |
| # |
Feb 3rd 2018, 22:11 |
hmic |
rather a nice explanation on who to think of working with the tree... |
| # |
Feb 3rd 2018, 22:11 |
hmic |
;) |
| # |
Feb 3rd 2018, 22:11 |
ahmed_bodi |
thats a nice solution |
| # |
Feb 3rd 2018, 22:10 |
hmic |
this way you can get a tree of all users of you app too :D |
| # |
Feb 3rd 2018, 22:10 |
hmic |
just make evey user level 1 below your "app" root-node |
| # |
Feb 3rd 2018, 22:10 |
ahmed_bodi |
hm? how so? |
| # |
Feb 3rd 2018, 22:10 |
hmic |
you dont need that |
| # |
Feb 3rd 2018, 22:10 |
hmic |
why? |
| # |
Feb 3rd 2018, 22:09 |
ahmed_bodi |
each user would be a root node |
| # |
Feb 3rd 2018, 22:09 |
ahmed_bodi |
for now yes, in the future nope |
| # |
Feb 3rd 2018, 22:08 |
hmic |
there is only one root node in the table, isn't it? :p |
| # |
Feb 3rd 2018, 22:07 |
ahmed_bodi |
:P |
| # |
Feb 3rd 2018, 22:07 |
ahmed_bodi |
haha, would do if i wasnt allowing user signups |
| # |
Feb 3rd 2018, 22:05 |
hmic |
just dont insert the root through the ORM :p |
| # |
Feb 3rd 2018, 22:05 |
ahmed_bodi |
@hmic the default buildrules for my model, its checking existsIn for the parent_id but its set to null as it should for the root node, safe to remove? |
| # |
Feb 3rd 2018, 22:00 |
greenjam94 |
Setting the display field works perfectly, thanks for the help (and for answering my earlier question) |
| # |
Feb 3rd 2018, 21:59 |
hmic |
additionally, you can change the find('list') call in the controller and provide the valueField parameter to its options array, to specify which field to use |
| # |
Feb 3rd 2018, 21:59 |
greenjam94 |
ah! I'll try that |