| # |
Jun 18th 2021, 12:47 |
 admad |
https://api.cakephp.org/4.2/class-Cake.Database.Query.html#where() |
| # |
Jun 18th 2021, 12:46 |
admad |
`->where($conds, ['id' => 'string'])` |
| # |
Jun 18th 2021, 12:30 |
alamnaryab |
for now I managed by making an array of `int` type fields, and then inside loop `if(in_array($cols[$i],$int_typed_fileds_array))` .... |
| # |
Jun 18th 2021, 12:25 |
alamnaryab |
I am making `$conds` as below ``` $conds = []; if ( isset($qs['sSearch']) andand $qs['sSearch'] != "" ) { for ( $i=0 ; $i<count($cols) ; $i++ ) { $conds[$cols[$i]." LIKE"]="%".$qs['sSearch']."%"; } }``` |
| # |
Jun 18th 2021, 12:20 |
kevin.pfeifer |
yes, but Fakhr Alam wants to set these filters dynamically and therefore tried to just make it all work with a generic ```'%field% LIKE' => '%value%', ``` which e.g. doesn’t work for integer fields |
| # |
Jun 18th 2021, 12:19 |
erwane |
I'm pretty sure the id filter should be an `=` not a `LIKE` |
| # |
Jun 18th 2021, 12:14 |
kevin.pfeifer |
@neon1024 the fact, that you didn’t continue your sequence with `101` hurt me a little… |
| # |
Jun 18th 2021, 12:07 |
neon1024 |
So if I queried for `id = 1` I would get `1`, `10`, `11`, `100`, `11011`. It’s a curious way to filter |
| # |
Jun 18th 2021, 12:05 |
alamnaryab |
because I want to do server side coding for jquery datatable filter, to check the term in all feilds |
| # |
Jun 18th 2021, 12:02 |
erwane |
if your column id is `int` why using like ? |
| # |
Jun 18th 2021, 11:23 |
kevin.pfeifer |
then I would exclude certain columns (like the id field when you have a string search param) from that search depending on what is the given search parameter type. |
| # |
Jun 18th 2021, 11:20 |
alamnaryab |
here I posted only 2 fields actually it is dynamic term to be checked in all fields of table. same as datatable search |
| # |
Jun 18th 2021, 11:15 |
kevin.pfeifer |
@alamnaryab do you really want to query the `id` column with a `LIKE`? |
| # |
Jun 18th 2021, 11:13 |
alamnaryab |
Hi All using cakephp 4.2.2 getting below error `Cannot convert value of type `string` to integer` ```$conds = [ 'id LIKE' => '%a%', //int field 'name LIKE' => '%a%', //varchar field ]; $conds= ['OR'=>$conds]; $query = $this->Students->find('all') ->where($conds) ->select($cols); $data = $this->paginate($query);``` |
| # |
Jun 18th 2021, 11:08 |
neon1024 |
Hopefully shouldn’t need a template |
| # |
Jun 18th 2021, 11:08 |
neon1024 |
Yeah, I am implementing some OAuth, so just trying to get my head around the flow at the moment |
| # |
Jun 18th 2021, 11:07 |
kevin.pfeifer |
@neon1024 just FYI: If you manually return a response inside your action then you don't need to do that (like when returning ajax directly) |
| # |
Jun 18th 2021, 11:06 |
neon1024 |
Ace, thanks @kevin.pfeifer |
| # |
Jun 18th 2021, 11:05 |
kevin.pfeifer |
```$this->autoRender = false;``` |
| # |
Jun 18th 2021, 11:05 |
neon1024 |
I still get a missing template exception |
| # |
Jun 18th 2021, 11:05 |
neon1024 |
How do I disable a template render for a controller action? I’ve tried `$this->render(null)` `$this->viewBuilder->disableAutoLayout()` and `$this->viewBuilder()->setTemplate(null)` |
| # |
Jun 18th 2021, 08:38 |
paolo.bragagni |
ajax |
| # |
Jun 18th 2021, 08:10 |
paolo.bragagni |
there is a way? |
| # |
Jun 18th 2021, 08:04 |
paolo.bragagni |
hi I'm trying to get in form.twig the name of the 'title' in associated table |
| # |
Jun 18th 2021, 06:01 |
admad |
@angelxmoreno Debug if the crud action is using your table class |
| # |
Jun 18th 2021, 02:45 |
angelxmoreno |
next CRUD Q: I am on friendsofcake/crud 5.5.1 and cakephp/cakeph 3.9.10, I need help debugging why CRUD wont validate my request data https://gist.github.com/angelxmoreno/0581c7ddc95325c40fd42a9166450670 |
| # |
Jun 18th 2021, 01:58 |
angelxmoreno |
@admad just wanted to follow up on your assist. Your point gave me insight and I went with a simpler solution than i originally anticipated. Route rules did the job just like you implied! |
| # |
Jun 18th 2021, 01:56 |
davinci |
I'm not sure either. :) Hoping someone here might know |
| # |
Jun 18th 2021, 01:50 |
bmudda |
Not sure you can create migration snapshot for single table. You might have to write it manually. |
| # |
Jun 18th 2021, 01:46 |
davinci |
@bmudda that seems to be talking about an entire snapshot, not a single table migration |
| # |
Jun 18th 2021, 01:45 |
bmudda |
@davinci https://book.cakephp.org/migrations/2/en/index.html#generating-migrations-from-an-existing-database |
| # |
Jun 18th 2021, 01:20 |
davinci |
(via CLI, not just by looking at it :) |
| # |
Jun 18th 2021, 01:16 |
davinci |
Can I create a migration file from an existing table? |
| # |
Jun 17th 2021, 18:41 |
kevin.pfeifer |
@joey.mukherjee well I was just referring to a belongsToMany connection, but if you are happy saving the json in your column then go for that :) |
| # |
Jun 17th 2021, 18:30 |
joey.mukherjee |
That is what I want... Neat! I'm not sure why it says something about time zones in the beginning. Thank you for the pointer! |
| # |
Jun 17th 2021, 18:26 |
admad |
https://book.cakephp.org/4/en/orm/associations.html#using-the-through-option |
| # |
Jun 17th 2021, 18:25 |
admad |
s/file type/field type |
| # |
Jun 17th 2021, 18:25 |
admad |
https://book.cakephp.org/4/en/orm/saving-data.html#saving-complex-types |
| # |
Jun 17th 2021, 18:24 |
joey.mukherjee |
@ndm I do have a junction table! Can I use that somehow? @admad That sounds useful! Is there a routine in the middle where I can modify the input/output? How do I set the file type in the schema anyway? Is that a MySQL thing? I am converting from old saved data to my new more efficient save that I would like to modify the data a bit... |
| # |
Jun 17th 2021, 18:19 |
admad |
"I save them as a json_encoded string in the database" Set the file type to "json" in table's schema, then cake will handle the string to array and array to string conversion for you |
| # |
Jun 17th 2021, 18:17 |
kevin.pfeifer |
@joey.mukherjee so you don’t have a junction table which connects your main table with the “other” table? |