F
Filament•5mo ago
NikkiP

How to get the record id of the table record when using a query with inner joins.

I'm planning to put an action button to my table but my table has query that is using inner joins. When I tried putting an edit/view action, it gets the base table of the resource. How to edit the custom records returned by the getEloquentQuery with inner join.
No description

advisory.php

6 Replies
Brian Kidd
Brian Kidd•5mo ago
Do you have relationships defined in your models?
NikkiP
NikkiP•5mo ago
yes I do have relationship. But I think its only limited to 2 tables? I'm listing records by inner joining the other tables @Brian Kidd
Dennis Koch
Dennis Koch•5mo ago
You shouldn't select ambigious columns. In that case don't select the ids of the joined tables
NikkiP
NikkiP•5mo ago
So I should just select the needed column right? Then the table will use the id of the parent model?
Dennis Koch
Dennis Koch•5mo ago
Yes. Currently SQL doesn't know which id to select
NikkiP
NikkiP•5mo ago
Thank you @Dennis Koch!
Want results from more Discord servers?
Add your server
More Posts
protected function getTableColumns(): arrayUsing loop in the getTableColumns and repeat the TextColumn according to the record from the getTablToday PageHi all I’m a little stumped on the best route here. To simplify things I have a journal type app. IPanel Authentication Route not definedWhen performing `artisan route:list`, the following are defined: ```bash GET|HEAD admin ..........Description List - InfolistIs there someway we can make Infolist entry to have a similar view as that in Tailwindcss UI page (oReport in FilamnetHow to create a report with chart and filters on all columns in filament in best optimised way for lSlide Over Broken on safari mobileHi , On Safari mobile the heading and the footer of a slide over appear outside the screen. Tested how to force students to change password on the first time loginHow to implement this in the panel to force the students to change their password when they logged iI can't show selected item on repeater componentI have made courses management by modules. but i cant show selected lesson on repeater.however the Ihow do i sum a column across all rows of a repeater from a function in the Resource?I can't glean this from the docs. I would like to loop through all rows of my repeater field and sumSorting a custom attributeHow would one add a sortable() column that is pointing to an attribute of a model? It shows up fine