Extend your site's querying and sorting functionality using custom field values.

Yuichiro ABE

Meta Accelerator

"Meta Accelerator" can speed up metaquery.

PRESSMAN

Hiroshi Sekiguchi

kazunao

pmhirotaka

hommakoharu

Beyond Wpdb

※ Table names have been changed since v2.0.Please delete the meta_json table and reactivate it in the options screen. Are you having trouble with slo …

julian1828

THIS PLUGIN IS IN HEAVY DEVELOPMENT!
Extend your site’s querying and sorting functionality using custom field values.
The following function registers queryable fields. 
 register_custom_queryable_field($fieldName, $options);
Simple Example: 
 register_custom_queryable_field(‘city’); 
(The above registers the custom field ‘city’ to be searchable using query variables) 
 http://www.yoursite.com/?city=Anahiem 
(displays posts which have a meta key ‘city’ and a value of ‘Anahiem’)
Advanced Example: 
 register_custom_queryable_field(“price”, array(“dataType”=>”numeric”)); 
(The above registers the custom field “price” to be searchable as a number using query variables) 
 http://www.yoursite.com/?price=500 
(displays posts which have a meta key ‘price’ and a exact value of ‘500’) 
 http://www.yoursite.com/?price_min=200&price_max=800&order_by=price 
(displays posts, sorted by ‘price’, which have a meta key ‘price’ and a value between ‘200’ and ‘800’)
Available Options:
<ul>
<li>dataType
<ul>
<li>text (default)</li>
<li>numeric (receive min/max query variables, see above example)</li>
</ul>
</li>
<li>order
<ul>
<li>If the user uses the “order_by” query variable then this option determines the order. Available options are “ASC” and “DESC”(default)</li>
</ul>
</li>
<li>compare
<ul>
<li>Compare method for text types. Defaults to ‘=’. Recommend ‘LIKE’</li>
</ul>
</li>
</ul>
There is a “order_by” query var made available. This is used by adding <code>&order_by=price</code> to the URL. In this instance, the query would sort based on the “price” field only.
Note: This plugin does not alter any queries when in the backend.

Alternatives to Custom Query Fields

Top alternatives