Скачать или смотреть How to Exclude Certain Rows in Flask-Admin Views?

Discover how to easily filter out unwanted rows in Flask-Admin views to customize your application's data presentation.
---
This video is based on the question https://stackoverflow.com/q/68370609/ asked by the user 'Hussein Hammoud' ( https://stackoverflow.com/u/2490737/ ) and on the answer https://stackoverflow.com/a/68370844/ provided by the user 'Hussein Hammoud' ( https://stackoverflow.com/u/2490737/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How can we NOT display certain rows in a flask-admin view?

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Excluding Certain Rows in Flask-Admin Views

Flask-Admin is a powerful library that allows developers to rapidly create administrative interfaces for their Flask applications. However, at times, you might want to customize the data displayed in your admin views, like excluding specific rows based on particular conditions. This guide addresses the common issue of how to exclude certain rows in a Flask-Admin view and provides a straightforward solution.

The Problem

You may have set up your Flask-Admin view to display certain data fields, for example:

[[See Video to Reveal this Text or Code Snippet]]

However, there may be situations where you want to exclude specific rows from being displayed. For instance, you might want to filter out entries where first_name is "John" and last_name is "Doe".

The key question here is: How can I display only rows where the first_name is not "John" and the last_name is not "Doe"?

The Solution

To achieve this functionality, you’ll need to override the get_query() method in your view class. This method allows you to specify the query that will be used to fetch the data for your view.

Here’s how you can do that:

Step 1: Override get_query()

Add a custom implementation of the get_query() method. This allows you to filter the results based on your specified conditions.

Sample Code

Here’s an example of how to implement this:

[[See Video to Reveal this Text or Code Snippet]]

Breakdown of the Code

Return Statement: The get_query() function returns a database query that retrieves all records from self.model.

Filtering Conditions: The filter() method is used to specify the conditions under which data should be included. You use the != operator to exclude entries with a first_name of "John" and a last_name of "Doe".

Combining Conditions: Note the use of & instead of and to combine the conditions. In SQLAlchemy, the & operator is used for combining multiple filter conditions.

Testing the Implementation

After you've added the get_query() method with the appropriate filters, run your Flask application. Navigate to the admin view, and you should now see that entries with first_name as "John" and last_name as "Doe" are excluded from the displayed results.

Conclusion

Customizing your Flask-Admin views to exclude certain rows is a straightforward process that can greatly enhance the usability of your admin interface. By overriding the get_query() method, you can easily filter the data based on your requirements.

If you run into any challenges or have further questions, feel free to reach out or comment below!