Thread

Does anyone know how to orderby a custom field thats populated with numbers. (IE price) Either through a addon or changing the mysql field to integer or numeric.

The EE orderby parameter works but because it’s a text field it doesn’t read the integer correctly.

Exploring the database it seems that changing the type would effect ALL custom fields, not just the specific one im trying to target. I couldn’t find a FieldFrame field type out there either.

Thanks

N/M, I was looking at the wrong database field.

Hey Michael, been awhile since I’ve seen you here.  I hope you’re doing well!

You’ve got this all sorted out now?

Hi Lisa, all is well thanks.

Actually I only have half of this sorted out. I changed the custom field to INT and now I’m trying to get the field to format properly with commas. Do you know if the query module accepts the FORMAT function? I can’t seem to get it to work. Or any other suggestions you may have. Thanks Mrs. Senior Director of Operations 😊

Hi Michael,

Ms, not Mrs. But that’s ok. =)

The query module is limited to certain functions.  If you need to do more with it, it may b best to use direct SQL or PHP to format your results.

Did you want me to move this to community help to get some assistance with that?

Thanks Lisa

Yeah thats what I thought. If you want to move it over I’ll try to post something once I build the query.

Thanks for your help