Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Filter and Sort on Custom Field in Flask-admin ModelView

I want to add filters for amount (custom field) in Model View

class FarmerAdmin(ModelView):

    column_descriptions = dict(amount = "All Transactions Total (Rs.)")

    column_searchable_list = ('name','village','phone')

    column_editable_list = ('phone',)

    column_filters = ('village','area',\
                  filters.FloatGreaterFilter('amount','Amount'))

    inline_models = (Transaction,)

    def get_query(self):
        return self.session.query(
            Farmer.id.label("id"),
            Farmer.name.label("name"),
            Farmer.village.label("village"),
            Farmer.phone.label("phone"),
            Farmer.area.label("area"),
            func.sum(Transaction.total).label("amount")
            ).join(Transaction).group_by(Farmer.id)

    def scaffold_sortable_columns(self):
        return {'id':'id','name':'name','village':'village',\
            'area':'area','amount':'amount'}

    def scaffold_list_columns(self):
        return ['id','name','village','phone','area','amount']


    def __init__(self, session):
        super(FarmerAdmin, self).__init__(Farmer, session)

Sort works great by overriding scaffold_sortable_columns method. Is there a way to add standard filters (greater than, less than) for amount column as well.

like image 673
shmundada Avatar asked Jul 16 '15 14:07

shmundada


1 Answers

I will take greater as an example

from flask_admin.contrib.sqla.filters import FilterGreater

class FarmerAdmin(ModelView):
    FilterGreater(Farmer.amount, u'Amount')

for more information please check http://flask-admin.readthedocs.io/en/latest/_modules/flask_admin/contrib/sqla/filters/

like image 153
huangli Avatar answered Nov 01 '22 13:11

huangli