nexxai Posts - Answer Overflow

nexxai

•Created by nexxai on 12/20/2024 in #❓┊help

Unsure if plugin exists or how I'd do this if one doesn't

We have ingested an Excel spreadsheet's worth of users into our app. As one would expect, many of the fields are missing for various users. What we'd like to do is make it so that upon their next login, if any of these fields are currently null, they will be forced to go to their profile page to fill them out before they may continue using the site. I don't need my hand held if a plugin like this doesn't exist, but I am still fairly new to Filament, so if you can even just point me in the general direction of intercepting a call to the dashboard, that should probably get me going. I looked through the docs and couldn't find anything that seemed to match my searching, but maybe I just wasn't using the correct terms? Thanks!

5 replies

FFilament

•Created by nexxai on 12/9/2024 in #❓┊help

Error when trying to sort table by MorphTo relationship

I have a table with a model (Person) and that model has a MorphTo relationship type called user(). In generating the table, I'm trying to do the following (some fields removed for the example but they do not matter):

        return $table
            ->columns([
                TextColumn::make('user.name')
                    ->label('Name')
                    ->searchable()
                    ->sortable(),
            ])
            ->defaultSort('name', 'asc')

        return $table
            ->columns([
                TextColumn::make('user.name')
                    ->label('Name')
                    ->searchable()
                    ->sortable(),
            ])
            ->defaultSort('name', 'asc')

but when I try to view the table, I get this:

Illuminate \ Database \ QueryException
PHP 8.3.14
11.33.2
SQLSTATE[HY000]: General error: 1 no such column: laravel_reserved_0.
select * from "people" where "people"."deleted_at" is null order by (select "name" from "people" as "laravel_reserved_0" where "laravel_reserved_0"."" = "people"."user_id" and "laravel_reserved_0"."deleted_at" is null) asc limit 10 offset 0

Illuminate \ Database \ QueryException
PHP 8.3.14
11.33.2
SQLSTATE[HY000]: General error: 1 no such column: laravel_reserved_0.
select * from "people" where "people"."deleted_at" is null order by (select "name" from "people" as "laravel_reserved_0" where "laravel_reserved_0"."" = "people"."user_id" and "laravel_reserved_0"."deleted_at" is null) asc limit 10 offset 0

The where "laravel_reserved_0"."" looks suspicious to me (why is the column name blank?), and I suspect it has something to do with the MorphTo relationship, but I'm not clear where to even continue looking and troubleshooting. I have confirmed: - Without the defaultSort(), the table displays the correct user.name value so it's something to do with this call - Every Person has a valid user_id and user_type entry filled in - Every referenced user_id has a valid (non-null) name value I'm also having what I think might be a similar issue with the related form for this table; if I try to add live() to the email address field which lives on the same user relationship, it doesn't actually fire. I can see the network call to /update happening in the Dev Console, but there's no data in the components.0.effects.returns array which I assume is where any validation errors would otherwise appear? Is anyone able to give me a hand?

9 replies

FFilament

•Created by nexxai on 10/30/2024 in #❓┊help

RichEditor - Is there a way to make it scrollable?

I have a RichEditor and the text that it contains is extremely long (think: legal document). That means that if someone goes to edit the contents of that field, the editor box expands to fit the size of the text, rather than limit itself to, say, 15-20 lines, and then have an internal scroll bar just for the editor field. Is there a way to force it to stay a certain size or number of lines with internal scrollbars so that if someone wants to use one of the editor buttons (e.g. Bold) that they don't have to scroll their entire screen back up to the top to press the button, and then scroll their screen all the way back down to wherever they were working?

6 replies

Gaming

Programming