In Progress

WordPress Queries for Custom Fields and Tags

I want to be able to run different reports on posts from our WordPress site.

The posts of interest have a "custom field"

with the key as 'contract_value'

and the value as a number as high as the millions/billions.

First, I want to be able to sort posts by custom field numeric value.

I've tried to setup a page template (see attached [url removed, login to view]).

However, i am having problems getting them to be in numerical order because of way WordPress enters the meta_value as a string.

Take a look at the attached [url removed, login to view] and a screenshot (Picture [url removed, login to view]).

I have looked over these topics.

[url removed, login to view]

[url removed, login to view]

I would like to find out how we should enter the custom field values.

Should it be 1000000 or can we use 1,000,000

In any case the final report should read 1,000,000

Let me know if you have any questions.

Skills: PHP, SQL, WordPress

See more: wordpress questions, wordpress codex, string problems, sample problems, find template wordpress, codex wordpress org, codex wordpress, wordpress custom fields tags, rtf, numeric, custom reports, custom field, case support, wordpress topic, sql final, topic picture, sql rtf, string find, custom sql queries, wordpress order field, topics reports, wordpress screenshot, reports topics, different custom, wordpress topics

About the Employer:
( 11 reviews ) Vienna, Austria

Project ID: #564615

5 freelancers are bidding on average $42 for this job

TakeReal

I can sort output by 'contract_value'. You can input 'contract_value' as string. "1000000" and "1,000,000" - both acceptable as long as you use 0-9 signs and "," separator. I need FTP access to your site to show my More

$40 USD in 1 day
(1275 Reviews)
7.5
dice8up

Let my team handle this. We will do a custom query and do some coding in WP core.

$200 USD in 5 days
(76 Reviews)
6.5
neanton

Please see PM for details

$30 USD in 0 days
(93 Reviews)
6.0
phpkim88

we can handle this project. we are wordpress experts team. we focus on wordpress project. we have developed many wordpress themes, plugins. we are very familiar with the wordpress framework. we aslo know how to de More

$30 USD in 1 day
(6 Reviews)
3.1
fxjtanggq

Hi, I am a php expertI can handle this! That requires testing the format of fields and transferring it when page form submitted! and when the page output, it can be formated to united styl!

$80 USD in 2 days
(0 Reviews)
0.0
dev88hhh

HI, its dev here. i am sending some of my sample for wordpress below http://lastminuteconcerttickets.com http://www.hf-wealth.com http://www.lotterynumbers.com

$30 USD in 3 days
(0 Reviews)
0.0