# |
Jun 8th 2019, 15:48 |
loginews |
now it says: Unknown column 'cshdet.DOCNO' in 'where clause' |
# |
Jun 8th 2019, 15:46 |
loginews |
let me remove it and see |
# |
Jun 8th 2019, 15:46 |
loginews |
yeah, it refuses. |
# |
Jun 8th 2019, 15:45 |
graziel |
also cant use contain in there |
# |
Jun 8th 2019, 15:45 |
loginews |
let me try... |
# |
Jun 8th 2019, 15:45 |
graziel |
$this->Rep06->deleteAll() |
# |
Jun 8th 2019, 15:44 |
loginews |
I have tried this, but it throws call to undefined function deleteAll |
# |
Jun 8th 2019, 15:41 |
graziel |
its table method not query https://book.cakephp.org/3.0/en/orm/deleting-data.html#bulk-deletes |
# |
Jun 8th 2019, 15:39 |
loginews |
:,( |
# |
Jun 8th 2019, 15:35 |
loginews |
Or do I need to put use Cake\ORM\something in my controller ? |
# |
Jun 8th 2019, 15:34 |
loginews |
I have tried to put this function in the controller, but it throws the error i mentioned |
# |
Jun 8th 2019, 15:30 |
loginews |
I keep getting "unknown method deleteAll" |
# |
Jun 8th 2019, 14:57 |
loginews |
@challgren Rep06 is not a table but a query based on cptran and cshdet tables. See snippet. My difficulty is just how to call DeleteAll from a function repair() in Rep06Controller |
# |
Jun 8th 2019, 08:41 |
challgren |
Are you trying to delete from the Repo06 table or the cshdet table? |
# |
Jun 8th 2019, 08:29 |
loginews |
thanks I will try later |
# |
Jun 8th 2019, 08:21 |
challgren |
The deleteAll accepts the same finder conditions |
# |
Jun 8th 2019, 08:20 |
challgren |
@loginews yes you can delete records returned by find, you just need to rerun your find in the other controller action |
# |
Jun 8th 2019, 07:57 |
loginews |
I had been to those docs. Apparently the entity will have to select the records already... We apparently cannot delete records returned by Find() |
# |
Jun 8th 2019, 07:55 |
loginews |
I don't want to. Have not been here for a long time. I had a specific difficulty today. Sorry to disturb the great minds. |
# |
Jun 8th 2019, 07:55 |
dakota |
@loginews https://book.cakephp.org/3.0/en/orm/deleting-data.html#bulk-deletes |
# |
Jun 8th 2019, 07:54 |
megan |
@loginews please don't tag specific people - rather just ask your question and if someone is available that can help, they will |
# |
Jun 8th 2019, 07:52 |
loginews |
@chris-andre: are you part of the support team ? |
# |
Jun 8th 2019, 07:51 |
loginews |
@dereuromark you here ? |
# |
Jun 8th 2019, 07:46 |
loginews |
I have a model between table cptran and table cshdet. The index displays a subset returned by the find() function. I want to add a function in the controller called repair() which will delete all the records returned by find().Is that possible? |
# |
Jun 8th 2019, 06:19 |
JDD_Canada |
That is coming up 404 |
# |
Jun 7th 2019, 22:38 |
challgren |
Debug it as much as possible and if you can fix it do a PR |
# |
Jun 7th 2019, 22:37 |
rightscoreanalysis |
looks like a problem with the TinyAuth plugin |
# |
Jun 7th 2019, 22:36 |
challgren |
Ohh ok I was just wondering if maybe it was a Plugin and you didnt have your allow_auth to include the Plugin, Sorry cant be much more help than that |
# |
Jun 7th 2019, 22:30 |
rightscoreanalysis |
I have other controllers in the same directory add to the acl as: [api/datatables/Users] |
# |
Jun 7th 2019, 22:29 |
rightscoreanalysis |
but the function uses a Plugin |
# |
Jun 7th 2019, 22:28 |
rightscoreanalysis |
@challgren not itself no |
# |
Jun 7th 2019, 22:09 |
challgren |
@rightscoreanalysis is datatables a plugin? |
# |
Jun 7th 2019, 21:29 |
rightscoreanalysis |
if i login the route work so 100% the allow_auth is not working, other allowed urls work fine |
# |
Jun 7th 2019, 21:23 |
rightscoreanalysis |
but I always get a redirect to login |
# |
Jun 7th 2019, 21:23 |
rightscoreanalysis |
in my allow auth: datatables/Listings = * |
# |
Jun 7th 2019, 21:22 |
rightscoreanalysis |
I have a prefixed route: /datatables/listings/filter.json?string=foobar |
# |
Jun 7th 2019, 21:22 |
rightscoreanalysis |
hi @dereuromark I am using TinyAUth and I want to allow as action |
# |
Jun 7th 2019, 21:12 |
challgren |
I needed the CSV imports before the rest of the app so it was whipped together in about 10 minutes for the client so I could actually work on the other stuff. It wasn’t too hard to do. They upload through the website and it creates a Queue Job that then does the data import since I can sometimes see large files +1000 records |
# |
Jun 7th 2019, 21:03 |
hollistergraham123 |
Yeah, I’ve got requests for CSV imports and i’ve been putting it off lol |
# |
Jun 7th 2019, 20:41 |
challgren |
Ok cool, This script is a Shell Task so it was a bit screwy when I first wrote it |
# |
Jun 7th 2019, 20:40 |
hollistergraham123 |
Just heads up looks like $this is still available inside the transaction function and references the table model so we don’t need to pass that in |