>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #1909634. --> Reported by: [bucefal91](https://www.drupal.org/user/504128) >>> <p>Please review this sandbox <a href="http://drupal.org/sandbox/bucefal91/1909506">http://drupal.org/sandbox/bucefal91/1909506</a> project.</p> <p>The repository can be found here: git clone <a href="http://git.drupal.org/sandbox/bucefal91/1909506.git">http://git.drupal.org/sandbox/bucefal91/1909506.git</a> numeric_field_filter</p> <p>Drupal version: 7.x</p> <p>Link for PAReview.sh: <a href="http://ventral.org/pareview/httpgitdrupalorgsandboxbucefal911909506git-7x-1x">http://ventral.org/pareview/httpgitdrupalorgsandboxbucefal911909506git-7x-1x</a><br> There are some coding standard errors, but I left them intentionally to follow general views handler naming approach.</p> <h2>Description</h2> <p>Numeric Field Filter introduces ability to filter numeric fields attached to any entity not only against a constant factor (like it does standard views numeric filter), however also to filter against another numeric field attached to the entity.</p> <p>For example: you have a field "Distance to sea" and a field "Distance to the capital". Using this filter you can build up a view that will get you all the entities that are closer to sea than to its capital, i.e. it allows you to build queries like <em>...WHERE field_distance_sea &gt; field_distance_capital</em>. It supports all basic operators for number comparison like:</p> <ul> <li>less than (&lt;)</li> <li>less than or equal to (&lt;=)</li> <li>equal (=)</li> <li>not equal (!=)</li> <li>greater than or equal to (&gt;=)</li> <li>greater than (&gt;)</li> <li>between</li> <li>not between</li> </ul> <p>Apart from its ability to filter against values of another field, it also introduces ability of simple mathematical operations between fields before they are compared. Recalling to our previous example, a slightly more advanced version would be to get all entities that are closer to the sea at least by 1.5 times than to its capital. This kind of filtering is also possible with Numeric Field Filter module. Thus it would build a query like <em>...WHERE field_distance_sea &gt; 1.5 * field_distance_capital</em>. Right now filter allows you to execute the following operations on the fields before comparing them:</p> <ul> <li>summation (+)</li> <li>substraction (-)</li> <li>multiplication (*)</li> <li>division (/)</li> </ul> <p>I see this module as a useful feature and I will be using this module in one of my projects, that's essentially the reason I created this module.</p>