[Resolved] Sorting Columns with Dollar Signs & Commas

[Author]

Posts

[marcusC-4]

I previously had a support thread about sorting columns that include numbers with dollar signs & commas. At the time, the support provided worked great. Minesh applied a custom function that allowed sorting to work very well.

However, the code doesn’t appear to be working anymore as I cannot sort the columns as expected.

Here is the original support thread: https://toolset.com/forums/topic/remove-dollar-sign-commas-from-numbers-field-values/

And here is the URL in question: hidden link

I’d love to know how to make these columns sortable again by the total size of the number instead of the first digits displayed.

[Luo Yang]

Hello,

Since it is a custom codes problem, please provide a test site with the same problem, also point out where I can edit your custom PHP codes, I need to test it in a live website, thanks

[Luo Yang]

Thanks for the details, I can log into your website, will update here if there is anything found

[Luo Yang]

Here are what I found, in this website, your database is using $table_prefix "wp_pf_", so the old PHP codes won't work.

I have done below modification in your website:
Edit the your theme file "functions.php", replace the PHP codes as below:

function func_orderby_asking_price( $orderby ) {
	global $WP_Views, $table_prefix;
	
	 if($WP_Views->current_view == 907){
		 $orderby = str_replace( $table_prefix . 'postmeta.meta_value', "cast(replace(trim( leading '$'  from " . $table_prefix . "postmeta.meta_value),',','')  AS UNSIGNED)", $orderby );
	}
    return $orderby;
}
add_filter('posts_orderby', 'func_orderby_asking_price' );

Please test again, check if it is fixed, thanks

[marcusC-4]

My issue is resolved now. Thank you!