I have added pagination in my view. The pagination is working fine but when I am filtering my data and navigate to the next page it is not paginating through the filtered data, it goes to the next page where the filtering is not happening.
views
class CashFilter(django_filters.FilterSet):
class Meta:
model = NSE_Cash_Trades
fields = {'dates':['lte','gte'],'order_entry_time':['lte','gte'],'trade_entry_time':['lte','gte'],'trade_modified_time':['lte','gte'],'symbol':['exact'],'client_ac':['exact'],'buys_sell_indicator':['exact'],'participant_code':['exact'],'trade_qty':['exact'],'ctcls_id':['exact'],'order_num':['exact'],'trade_no':['exact']}
def NSE_Cash_Trades_Search(request):
f =CashFilter(request.GET, queryset=NSE_Cash_Trades.objects.all())
paginator = Paginator(f.qs,100)
page = request.GET.get('page')
try:
leads = paginator.page(page)
except PageNotAnInteger:
leads = paginator.page(1)
except EmptyPage:
leads = paginator.page(paginator.num_pages)
t = loader.get_template('admin/newftp/search2.html')
ctx=RequestContext(request,{'filter':f,"leads":leads,})
return HttpResponse(t.render(ctx))`
template
{% extends "admin/newftp/change_list.html" %}
{% block content %}
<h2><a href="/admin/newftp/nse_cash_trades?status=">Back to Nse Cash trade page</a></h2>
<form action="" method="get">
<!--Required for dynamic total of a column based on search filter
{% for k,v in result1.items %}
<input type="text" name="result1" value="{{ v }}"/>
{% endfor %}
input type="button" name="result1" value= "Total Value"
-->
{{ filter.form.as_p }}<br>
<input type="submit" />
</form>
<div class="pagination">
<table border="1">
<tr>
<th>Sr.No.</th>
<th>Trade date</th>
<th>Symbol </th>
<th>Client Code </th>
<th>Buy/Sell </th>
<th>Participant Code</th>
<th>Trade qty </th>
<th>CTCL ID</th>
<th>Order Number</th>
<th>Trade no </th>
<th>Order Entry Date Time</th>
<th>Trade Entry Dt Time</th>
<th>Trade modified time</th>
<th>Trade Price</th>
<th>Trade Status</th>
<th>Series</th>
<th>Security Name</th>
<th>Instrument Type</th>
<th>Book Type</th>
<th>Market Type</th>
<th>User ID</th>
<th>Branch ID</th>
<th>Pro/Cli</th>
<th>Auction Part Type</th>
<th>Auction NO</th>
<th>Sett Period</th>
<th>Counter Party Id</th>
</tr>
{% for line in leads %}
<tr>
<td>{{ forloop.counter}}</td>
<td>{{ line.dates|date:"d/m/Y"}}</td>
<td>{{ line.symbol}}</td>
<td>{{ line.client_ac}} </td>
<td>{{ line.buys_sell_indicator}}</td>
<td>{{ line.participant_code}}</td>
<td>{{ line.trade_qty}}</td>
<td>{{ line.ctcls_id}}</td>
<td>{{ line.order_num}}</td>
<td>{{ line.trade_no}}</td>
<td>{{ line.order_entry_time|date:"d/m/Y h:m:s"}}</td>
<td>{{ line.trade_entry_time|date:"d/m/Y h:m:s" }}</td>
<td>{{ line.trade_modified_time|date:"d/m/Y h:m:s" }}</td>
<td>{{ line.trade_price }}</td>
<td>{{ line.trades_status }}</td>
<td>{{ line.series }}</td>
<td>{{ line.security_name }}</td>
<td>{{ line.instruments_type }}</td>
<td>{{ line.books_type }}</td>
<td>{{ line.markets_type }}</td>
<td>{{ line.user_id }}</td>
<td>{{ line.branchs_id }}</td>
<td>{{ line.pros_cli }}</td>
<td>{{ line.auctions_part_type}}</td>
<td>{{ line.auction_num }}</td>
<td>{{ line.sett_period }}</td>
<td>{{ line.counter_party_id }}</td>
</tr>
{% endfor %}
</table>
<span class="step-links">
{% if leads.has_previous %}
<a href="?page={{ leads.previous_page_number }}">previous</a>
{% endif %}
<span class="current">
Page {{ leads.number }} of {{ leads.paginator.num_pages }}.
</span>
{% if leads.has_next %}
<a href="?page={{ leads.next_page_number }}">next</a>
{% endif %}
</span>
</div>
{% endblock %}
Can anyone please help me to find a solution?
