Log message #4180783

# At Username Text
# Mar 25th 2019, 21:10 chrisshick I would think it would build the query and let MySQL return the result
# Mar 25th 2019, 21:09 ricksaccous if you are just connecting records, then it depends on how the form looks, but i don't see a problem with patchEntity @marek.sebera
# Mar 25th 2019, 21:08 marek.sebera cool, no problem
# Mar 25th 2019, 21:08 chrisshick Yeah... it seems the subquery executes first and then cake injects into the main query
# Mar 25th 2019, 21:08 ricksaccous yeah that's kind of a weird use case i guess, wew
# Mar 25th 2019, 21:08 ricksaccous oh
# Mar 25th 2019, 21:08 chrisshick For cake
# Mar 25th 2019, 21:08 ricksaccous take a look at query expressions i think that would help
# Mar 25th 2019, 21:07 chrisshick I noticed that the default way subqueries work is that they are executed first and then injected into the main query
# Mar 25th 2019, 21:07 ricksaccous yeah there is
# Mar 25th 2019, 21:07 chrisshick Is there a way to run a subquery that uses data from the main query?
# Mar 25th 2019, 21:07 ricksaccous and you wanted to connect the old records that weren't connected yet
# Mar 25th 2019, 21:06 ricksaccous i thought you had an old dataset and you just added in this relationship
# Mar 25th 2019, 21:06 ricksaccous oh i think i was confused
# Mar 25th 2019, 21:02 marek.sebera or I don't understand what you're asking for
# Mar 25th 2019, 20:58 marek.sebera they are already contained in join-table, in action where user can upload new file to existing document, i create physically and validate the file, and add the file entity to document entity link using the described way
# Mar 25th 2019, 20:53 ricksaccous was the data hasMany before?
# Mar 25th 2019, 20:53 ricksaccous and how do you know how to assign them based on existing data?
# Mar 25th 2019, 20:52 marek.sebera well i have `document BTM files`, as one document (along with more associations) can consist of multiple physical files, and files can be assigned within multiple documents, standard BTM relation i think
# Mar 25th 2019, 20:49 ricksaccous i don't really understand the nature of your associations but you might be able to just put this together with sql, but yeah, that might hurt the caching however you have that set up
# Mar 25th 2019, 20:48 marek.sebera @ricksaccous now I collect existing ids iterating association field, add the id of new entity i've created before, patchEntity and save, but I felt there must be a better way
# Mar 25th 2019, 20:47 ricksaccous @marek.sebera, depends on your use case, patchEntity in a loop doesn't sound too crazy as a one-off script
# Mar 25th 2019, 20:38 marek.sebera maybe adding new record into BTM join-table, but that might break some in-cakephp caching
# Mar 25th 2019, 20:37 marek.sebera What is the best way to add BTM connection to existing ones? Because using patchEntity with _ids retrieved before + the new entity id, seems unpractical
# Mar 25th 2019, 20:27 challgren @feliruc https://github.com/UseMuffin/Footprint
# Mar 25th 2019, 20:22 feLiruc How can I get the user logged information in the entity?
# Mar 25th 2019, 20:20 admad there is be first alpha next month
# Mar 25th 2019, 20:20 admad https://github.com/cakephp/cakephp/wiki/4.0-Roadmap
# Mar 25th 2019, 20:05 ricksaccous '(mySqlEquation) > 3'
# Mar 25th 2019, 20:05 ricksaccous @devito I think you just have to have the whole thing in one string if you want to do that
# Mar 25th 2019, 20:01 vjnvisakh when is it launching
# Mar 25th 2019, 20:00 vjnvisakh what is new in cakephp 4
# Mar 25th 2019, 19:58 devito is that valid?
# Mar 25th 2019, 19:58 devito ive got some crazy query that i want to use as a where condition. does a bunch of mat can I have where=>[“(mySqlEquation) >“=>3]
# Mar 25th 2019, 19:56 vjnvisakh Hey
# Mar 25th 2019, 19:40 daniel.upshaw I might have found a way to do it.... Make templates with only `<?= $html ?>` and `<?= $text ?>` and just send it the entire contents
# Mar 25th 2019, 19:33 daniel.upshaw Although, that was in 2015
# Mar 25th 2019, 19:33 daniel.upshaw Without using .ctp templates
# Mar 25th 2019, 19:32 daniel.upshaw Looks like there's no straightforward way to set the Plain Text version and HTML version manually
# Mar 25th 2019, 19:32 daniel.upshaw https://stackoverflow.com/questions/32860252/cakephp-3-x-can-we-use-emailformat-both-without-using-template
# Mar 25th 2019, 19:31 ricksaccous yeah beforeMarshall