CODEWITHSUNDEEP
djangodjango-datatable
snoba
snoba

Reputation: 173

Define Filter on django-datatable-view

I am using django-datatable-view to show my data. I have a scenario that I need to retrieve records from a model, that satisfy certain conditions. For example, the request could be described as:

"SELECT * FROM model WHERE column_1='value_1' AND column_2='value_2'

How could I implement this? Actually, I saw the examples, but I don't have an efficient idea to do this. Would you please help me in View definition or refer to proper sample?

Upvotes: 1

Views: 968

Answers (2)

snoba
snoba

Reputation: 173

It seems that we should implement a get_queryset(self) method to apply on targeted filters:

def get_queryset(self):
    return Entity.objects.filter('item_1'='value_1')

While this could results in proper table values, but, the performance of loading decreases significantly. Maybe other solutions could save the performance, or we should use other techniques like caching.

Upvotes: 1

Hristiyan Bonev
Hristiyan Bonev

Reputation: 82

I think that the correct answer is pointed out in official documentation

You can filter QuerySet as it's shown in the example:

Entry.objects.filter(pub_date__year=2006)

For your case it could be:

Entry.objects.filter(column_1='value_1').filter(column_2='value_2')

Also it is possible duplicate of this topic

Upvotes: 0

Related Questions