* Update database search query with permissions filter

* Add unit test

* Remove accidentally committed code

* Tidy query

* Refactor query

* Use `check-permissions-for-model` instead for database instead of checking permissions with SQL

* Add extra test before revoking perms

* Fixing Model Metadata and a dashboard test

* removing waits

* Replacing realhover with mouseenter

* adjustments to repro 17160

* update prettier

* update prettier styling

* change metabase_fieldvalues.type from text to varchar so we could have a defaultValue

* change report_card.parameters and report_card.parameter_mappings to nullable

* metabase_fieldvalues.type is not nullable

* varchar(254) -> varchar(32)

* remove duplicate date options
* conditionally show all shortcut options

* handle field values lists with no values

* fix failed to copy dashboard with parameters

* add gh issue to the test description

This reverts commit fa8d88a3.

Co-authored-by: Alexander Polyankin <alexander.polyankin@metabase.com>

* Correct `renderWithProviders` type

* This ensure to test user entity's `getName` function

* Add test for last edited by when render long value

Pursuant to #20863.

Some syncs (viz., the ones in mongo, in the #20863 ticket, but there seem to be others) don't mutate the initial_sync_status in metabase database object properly. I looked into directly fixing in mongodb and then found that this was also the case in some others of the DB's so we can't really 100% trust that initial_sync_status to be set automatically generally.

This creates a pretty unhappy UX where, if you have mongo, that sync spinner just stays there forever. Flamber details a workaround to it in #20863 which is... reaching into metabase app DB and mutating stuff. Not ideal.

This adds a button to the admin panel for a DB that appears if (and only if) the sync status isn't complete to just coerce the sync status of DB and tables under DB to be complete. Screenshot of button existing attached.

* Add test for user list endpoint when user is a sandboxed group manager

* Improve test description

* larger description text

* massage description area styling

* fix spacing in question info sidebar

* Using Emotion for style changes

Co-authored-by: Nick Fitzpatrick <nick@metabase.com>

* Modal tab scroll and styling updates