Schilly
Schilly
FFilament
Created by Schilly on 11/1/2024 in #❓┊help
Import Action - "unknown column '' in `where clause` "
Managed to get it to work - had to add a id column to the pivot table that increments. Not sure if this is intended behavior or not but seems to work fine now.
7 replies
FFilament
Created by Schilly on 11/1/2024 in #❓┊help
Import Action - "unknown column '' in `where clause` "
This was the code I used for the "update only" attempt:
return OperationWarehouse::query()
->where('warehouse_id', $this->data['warehouse_id'])
->first();
return OperationWarehouse::query()
->where('warehouse_id', $this->data['warehouse_id'])
->first();
- Still throws the same error of cannot find the column ''. Here is afull stack trace error ouput - not sure if it will help or not (attached)
7 replies
FFilament
Created by Schilly on 11/1/2024 in #❓┊help
Import Action - "unknown column '' in `where clause` "
Get the same error message when I try to do "update only" as directed in the docs as well
7 replies
FFilament
Created by Schilly on 11/1/2024 in #❓┊help
Import Action - "unknown column '' in `where clause` "
The only part that does not seem to work - is for the updating existing rows based on what is in the CSV
7 replies
FFilament
Created by Schilly on 11/1/2024 in #❓┊help
Import Action - "unknown column '' in `where clause` "
Also - I have tested to see if it works to straight up create "new" entries into the pivot table - this works 100% as expected without error.
7 replies
FFilament
Created by Schilly on 11/1/2024 in #❓┊help
Import Action - "unknown column '' in `where clause` "
Additionally - I have checked to ensure the warehouse_id is being set via dd($this->date['warehouse_id']); and this returns as expected an integer of the warehouse as listed in the imported CSV file.
7 replies
FFilament
Created by vahnmarty on 7/15/2023 in #❓┊help
How to modify ToggleColumn function?
Danke!
7 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
easy peasy 😛
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
->orderBy('is_primary','desc')
->orderBy('is_primary','desc')
on the relationship(s)
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
Lol! thanks
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
Now if only the badges were ordered to have the primary show up first... 😛
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
Same. Thanks man much appreciated 😄
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
I need to work on my code refactoring thats for sure lol
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
much cleaner lol
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
Yes
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
No description
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
But now i get:
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
as find is just a where on only the ID column
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
not that should make a difference
100 replies
FFilament
Created by Schilly on 2/6/2024 in #❓┊help
Text Column Badge Color based on Pivot attribute
and also used a where isntead of find()
100 replies