PHPackages omanshardt/doctrine-datatables - PHPackages - PHPackages [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register) 1. [Directory](/) 2. / 3. [Database & ORM](/categories/database) 4. / 5. omanshardt/doctrine-datatables ActiveLibrary[Database & ORM](/categories/database) omanshardt/doctrine-datatables ============================== Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering. 1.7.0(2y ago)079MITPHPPHP >=8.0 Since Sep 14Pushed 2y ago1 watchersCompare [ Source](https://github.com/omanshardt/doctrine-datatables)[ Packagist](https://packagist.org/packages/omanshardt/doctrine-datatables)[ Docs](https://github.com/omanshardt/doctrine-datatables)[ RSS](/packages/omanshardt-doctrine-datatables/feed)WikiDiscussions master Synced 1mo ago READMEChangelog (7)Dependencies (2)Versions (15)Used By (0) omanshardt/doctrine-datatables ============================== [](#omanshardtdoctrine-datatables) Helper library to implement [Doctrine](http://www.doctrine-project.org/) powered server-side processing for [jquery-datatables](https://github.com/DataTables/DataTables) with joins, search, filtering and ordering. [![Latest Version](https://camo.githubusercontent.com/32c727931b719ec498f99e656c82e3968ae53743f8121604b7b9d856d2873cb6/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f72656c656173652f6f6d616e7368617264742f646f637472696e652d646174617461626c65732e7376673f7374796c653d666c61742d737175617265)](https://github.com/omanshardt/doctrine-datatables/releases) [![SensioLabsInsight](https://camo.githubusercontent.com/6d6e495cb35e789543618496440cea30ff2f99571abf090b8869ac53f978e633/68747470733a2f2f696e73696768742e73656e73696f6c6162732e636f6d2f70726f6a656374732f34616331616136612d613439352d343965302d623564362d6437623832626532613566362f6d696e692e706e67)](https://insight.sensiolabs.com/projects/4ac1aa6a-a495-49e0-b5d6-d7b82be2a5f6) [![Total Downloads](https://camo.githubusercontent.com/ff1518a3cb3cc9729221f22ee27d4cd25b804f7a8af919a351f0be2e221659fe/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f6f6d616e7368617264742f646f637472696e652d646174617461626c65732e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/omanshardt/doctrine-datatables) [![Software License](https://camo.githubusercontent.com/55c0218c8f8009f06ad4ddae837ddd05301481fcf0dff8e0ed9dadda8780713e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](LICENSE.md) Install ------- [](#install) ``` composer require omanshardt/doctrine-datatables ``` Usage with [doctrine/dbal](https://github.com/doctrine/dbal): Usage with [doctrine/orm](https://github.com/doctrine/doctrine2): This is a clone from with some intenal modifications. So please refer to the original tool for usage. See [LICENSE.md](https://github.com/omanshardt/doctrine-datatables/blob/master/LICENSE.md) file. This one supports ``` Doctrine\ORM\Tools\Pagination\Paginator ``` To search from datatables there are nine different search modes \*% (LIKE '…%') -> default This performs a **LIKE '…%'** search where the start of the search term must match a value in the given column. This can be archived with only providing the search term (because it's default) or by prefixing the search term with "\[\*%\]" **(\[\*%\]searchTerm)**. %% (LIKE '%…%') This performs a **LIKE '%…%'** search where any part the search term must match a value in the given column. This can be archived by prefixing the search term with "\[%%\]" **(\[%%\]searchTerm)**. = (Equality) This performs a **= …** search. The search term must exactly match a value in the given column. This can be archived by prefixing the search term with "\[=\]" **(\[=\]searchTerm)**. != (No Equality) This performs a **!= …** search. The search term must not exactly match a value in the given column. This can be archived by prefixing the search term with "\[!=\]" **(\[!=\]searchTerm)**. > (Greater Than) This performs a **> …** search. The search term must be smaller than a value in the given column. This can be archived by prefixing the search term with "\[>\]" **(\[>\]searchTerm)**. < (Smaller Than) This performs a **< …** search. The search term must be greater than a value in the given column. This can be archived by prefixing the search term with "\[<\]" **(\[<\]searchTerm)**. < (IN) This performs an **IN(…)** search. One of the provided comma-separated search terms must exactly match a value in the given column. This can be archived by prefixing the search terms with "\[IN\]" **(\[IN\]searchTerm,searchTerm,…)**. < (OR) This performs multiple OR-connected **LIKE('%…%')** searches. One of the provided comma-separated search terms must match a fragment of a value in the given column. This can be archived by prefixing the search terms with "\[OR\]" **(\[OR\]searchTerm,searchTerm,…)**. >< (Between) This performs a **BETWEEN … AND …** search. Both search terms must be separated with a comma. This operation can be archived by prefixing the comma-separated search terms with "\[><\]" **(\[><\]searchTerm,searchTerm)**.Prefixes are case-insenstive (IN, in, OR, or). Provided search terms were trimmed. ### Health Score 32 — LowBetter than 71% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity9 Limited adoption so far Community9 Small or concentrated contributor base Maturity76 Established project with proven stability Bus Factor1 Top contributor holds 58.3% of commits — single point of failure How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window. **Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores. **Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement. **Maturity (30%)** — Project age, version count, PHP version support, and release stability. ### Release Activity Cadence Every ~215 days Recently: every ~525 days Total 13 Last Release 937d ago PHP version history (2 changes)1.0PHP >=5.3.0 1.7.0PHP >=8.0 ### Community Maintainers ![](https://www.gravatar.com/avatar/a05050911fad0f19b33310587c50794be3d2fd9937c4e618750c58f38cd39fa7?d=identicon)[omanshardt](/maintainers/omanshardt) --- Top Contributors [![omanshardt](https://avatars.githubusercontent.com/u/5845310?v=4)](https://github.com/omanshardt "omanshardt (14 commits)")[![vaibhavpandeyvpz](https://avatars.githubusercontent.com/u/6647172?v=4)](https://github.com/vaibhavpandeyvpz "vaibhavpandeyvpz (10 commits)") --- Tags doctrinejquerydatatables ### Embed Badge ![Health badge](/badges/omanshardt-doctrine-datatables/health.svg) ``` [![Health](https://phpackages.com/badges/omanshardt-doctrine-datatables/health.svg)](https://phpackages.com/packages/omanshardt-doctrine-datatables) ``` ### Alternatives [scienta/doctrine-json-functions A set of extensions to Doctrine that add support for json query functions. 58523.9M35](/packages/scienta-doctrine-json-functions)[omines/datatables-bundle Symfony DataTables Bundle with native Doctrine ORM, Elastica and MongoDB support 2851.4M6](/packages/omines-datatables-bundle)[laravel-doctrine/orm An integration library for Laravel and Doctrine ORM 8425.3M87](/packages/laravel-doctrine-orm)[martin-georgiev/postgresql-for-doctrine Extends Doctrine with native PostgreSQL support for arrays, JSONB, ranges, PostGIS geometries, text search, ltree, uuid, and 100+ PostgreSQL-specific functions. 4485.3M4](/packages/martin-georgiev-postgresql-for-doctrine)[damienharper/auditor-bundle Integrate auditor library in your Symfony projects. 4542.8M](/packages/damienharper-auditor-bundle)[vaibhavpandeyvpz/doctrine-datatables Helper library to implement doctrine powered server-side processing for jquery-datatables with joins, search, filtering and ordering. 2157.0k](/packages/vaibhavpandeyvpz-doctrine-datatables) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)