Comments (4)
After having looked at how to configure ColumnFilterWidgets, I believe it's pretty much just building on existing dataTables.js APIs (i.e., it greatly simplifies the workflow provided by the per-column fnFilter API and adds some fanciness via drop-downs).
I'll need to look at how it interacts with requests made while bServerSide = true
, though. Ideally, the DatatableView
could extract those column-specific filters and apply them automatically.
from django-datatable-view.
Have you had a chance to look into this anymore? I will dig a little further into it in the coming weeks hopefully but in the meantime, perhaps you could give me some advice on whats the current simplest way to add column based filters?
from django-datatable-view.
After starting to create a pull request for this I basically came to the conclusion that this is going to be so different for every case that its just easier to do in the get_queryset and use the complex lookups of django to build the queries specifically for your column needs. Its working well for me. Here is an example that basically gives you the column index (ind) and the query string (real_query):
getquery = self.request.GET
sSearches = fnmatch.filter(getquery, 'sSearch_?')
for sS in sSearches:
sQuery = getquery.get(sS, '').strip()
if sQuery:
ind = int(sS.split('_')[1])
real_query = re.search('\(^|,\)\((.*)\)\(,|$\)', sQuery)
from django-datatable-view.
is was reviewing this yesterday, you have to search for sSearch_[column_id] get parameter and apply and if the column type allow search, then search for it like is done in the table search.
A nice feature could be allow to add specific search for colums in the view, so you run the default search if the view has not defined an special search for that column. django-eztables and django-datatables-view has this feature.
from django-datatable-view.
Related Issues (20)
- Double initialization of DatatableView HOT 3
- Table not rendering - compatibility with Django 2 and Python 3? HOT 2
- Can't run in production - Ajax error HOT 1
- GenericIPAddressField HOT 1
- columns based on a queryset HOT 1
- Bootstrap 4 (or later)?
- example_project, when run " manage.py migrate", error occurs!!! HOT 3
- Django 3.1.3 support HOT 2
- ImportError: cannot import name 'get_field_definition (django 3.1.3) HOT 1
- ImportError: cannot import name 'get_datatable_structure' (django 3.1.3) HOT 2
- Unable to search or sort columns with processor but no sources HOT 3
- Performance issues with many (50-100+) x-editable columns
- pypi updates HOT 3
- Column with Foreignkey - limit_choices_to not working as intended
- Selecting rows over several pages with select all HOT 1
- Chain AND searches
- Doesnt work with AWS load balancer HOT 1
- Example Project Missing
- Cannout use distinct on get_initial_queryset()
- How to add buttons for download csv and excel
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from django-datatable-view.