Log message #4157405

# At Username Text
# Jul 10th 2018, 10:27 josbeir but maybe i'll get back to work now
# Jul 10th 2018, 10:26 josbeir np np i like to share my ES knowledge
# Jul 10th 2018, 10:26 josbeir :) i'll send you an invoice
# Jul 10th 2018, 10:26 james.phillips i feel like a leech...draining you of all your knowledge
# Jul 10th 2018, 10:25 josbeir but in maybe, in your case i'm thinking about typing out a universal document schema and use 1 index to store all your stuff
# Jul 10th 2018, 10:24 josbeir there's no specific way or 'good' way to do the indexing
# Jul 10th 2018, 10:24 josbeir uhu
# Jul 10th 2018, 10:23 james.phillips I have events, publications, podcasts etc so i wanna be able to put them in ES do keyword searches on them and match that result set back to the mysql tables
# Jul 10th 2018, 10:23 josbeir well.. maybe not a blob :)
# Jul 10th 2018, 10:23 josbeir can be an integer, a string, whatever
# Jul 10th 2018, 10:23 josbeir no real 'rules' of the type
# Jul 10th 2018, 10:23 josbeir an _id in ES must be something unique, it can be your database PK or something other
# Jul 10th 2018, 10:22 james.phillips I get u
# Jul 10th 2018, 10:22 josbeir if you add them to it :slightly_smiling_face:
# Jul 10th 2018, 10:22 josbeir sure
# Jul 10th 2018, 10:22 james.phillips and those documents can have the ID that relates to the primary key of my tables?
# Jul 10th 2018, 10:22 josbeir you can use aggregations to do more complex grouping, facetting, that sort of stuff
# Jul 10th 2018, 10:22 josbeir it returns documents you queried for
# Jul 10th 2018, 10:21 josbeir if you want it to ? :)
# Jul 10th 2018, 10:21 josbeir what do you mean?
# Jul 10th 2018, 10:21 james.phillips does the ES plugin return a list of matching Ids?
# Jul 10th 2018, 10:20 james.phillips thanks Josbier I will try get some time booked in to do it.. very helpful to get a rough time line cheers
# Jul 10th 2018, 10:20 josbeir ecommerce platform
# Jul 10th 2018, 10:20 josbeir medium sized project
# Jul 10th 2018, 10:20 josbeir i did a migration a few weeks ago from 3.5 to 3.6 and it took me less then a day to get it production ready
# Jul 10th 2018, 10:20 james.phillips I can keep my existing codebase and then for keyword searches search against ES?
# Jul 10th 2018, 10:18 james.phillips in thery thou using https://github.com/cakephp/elastic-search is easy rite? I can do what i need?
# Jul 10th 2018, 10:18 Martin` I still need to do that :P
# Jul 10th 2018, 10:17 james.phillips thanks all
# Jul 10th 2018, 10:17 james.phillips nothing is ever easy...
# Jul 10th 2018, 10:17 james.phillips cheers
# Jul 10th 2018, 10:17 james.phillips unfortunally not.. I will look at https://book.cakephp.org/3.0/en/appendices/3-6-migration-guide.html
# Jul 10th 2018, 10:16 lorenzo no, it will take you more than that. Unless you are just starting with your roject
# Jul 10th 2018, 10:16 james.phillips is updating 3.5 to 3.6 a five min job?
# Jul 10th 2018, 10:14 james.phillips I agree stupid there time to do some afterwards but not before....Guess I will suggest two options....
# Jul 10th 2018, 10:14 josbeir :rocket: @lorenzo
# Jul 10th 2018, 10:14 lorenzo @josbeir added to the readme
# Jul 10th 2018, 10:13 Martin` Hmm I've a tree, I created an index with just sorting tree bij de lft, and making a nice tree, but now I have a problem with the search plugin. I want to always show all folders. how can I do this? I already tried adding ->orWhere(['folder' => 1]) to the query, but then it only finds folders :(
# Jul 10th 2018, 10:13 josbeir randd on such things should be a bigger part of the budget then ;)
# Jul 10th 2018, 10:11 james.phillips yeah sucks have to say to client what we recommend but dont have time to investigate it fully..
# Jul 10th 2018, 10:11 josbeir but yeah.. money