"Order by" inside shortcode is allllmost there

Resolved Shoptutor
(@shoptutor)

11 years, 2 months ago
Hello,

I have the following shortcode in my page:
```
[pods name="ofertas" where="idprogram.meta_value='12011' and sessioncheck.meta_value='1'" limit="50" orderby="price.meta_value"  template="oferta"]
```
The result I’m getting is something like:
R$ 1.000
R$ 1.130
R$ 1.200
R$ 12.500
R$ 1.300

So, the record with 12,5 thousand, sould be on the botton of the results.
How can I correct it?
Thanks, best.

https://wordpress.org/plugins/pods/

Viewing 5 replies - 1 through 5 (of 5 total)

Nikhil Vimal
(@nikv)

11 years, 2 months ago

Howdy,

You can try ordering them in a different way by adding an extra parameter to orderby=”price.meta_value” so it looks like this:

orderby=”price.meta_value DESC”, which would mean the values are descending. Not sure if this helps, but it’s a start if you are aiming to restructure the result.

Plugin Contributor Josh Pollock
(@shelob9)

11 years, 2 months ago

The issue here is that WordPress stores all meta fields in the database as strings, so as you have seen, they are being sorted alphabetically. Since you are using a shortcode there is no way in your shortcode to convert the values to a decimals, since that would require using a MySQL function that you can’t use in the post editor.

But you can filter your the parameters, from the shortcode, before they are passed to Pods::find(), to do just that.

I used your case to write up some example code:

https://github.com/pods-framework/pods-code-library/blob/master/example/hooks/filters/pods_shortcode_findrecords_params/orderby_number.php

Thread Starter Shoptutor
(@shoptutor)

11 years, 2 months ago

That is awesome Josh, is this kind of help that are making me happy to had chosen pods. 🙂

The only thing is that I’m not sure where to put this code, since I’m using the shortcode inside the post editor.

Thanks again, best.

Plugin Contributor Josh Pollock
(@shelob9)

11 years, 2 months ago

Take a look at this: http://pods.io/tutorials/creating-pods-plugins/put-code-use-pods/

Thread Starter Shoptutor
(@shoptutor)

11 years, 2 months ago

Awesome, thanks!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘"Order by" inside shortcode is allllmost there’ is closed to new replies.

Tags