[Gelöst] decimal value not filtering

[Author]

Artikel

[Akhil]

hi. i read this post :
https://toolset.com/forums/topic/parametric-search-results-are-wrong-because-cast-as-decimal-return-wrong-values/

i am having the same issue now too.

my case is i have value such as 1,1.5 ,2,2.5,3,3.5 etc.

my custom search could not filter value between 1-2. i have result of 2.5 too.which is wrong.

Please advice.

[Akhil]

another related post :https://toolset.com/forums/topic/views-filter-on-numeric-field-not-working/

[Shane]

Hello,

Thank you for contacting our support forum.

This issue should've been fixed in our views plugin since version 2.2.1

However could you try this filter below and let me know if it helps.

function wpv_filter_query_cast_as_decimal_fix( $query, $view_settings, $view_id ) {
        if ( isset($query['meta_query']) ) {
            foreach ( $query['meta_query'] as $key => $value ) {
                if ( isset( $value['type'] ) ) {
                    if ( strtoupper( $value['type'] ) == 'DECIMAL' ){
                        $query['meta_query'][$key]['type'] = 'DECIMAL(11,2)';
                    }
                }
            }
        }

        return $query;
    }
add_filter( 'wpv_filter_query', 'wpv_filter_query_cast_as_decimal_fix', 99, 3 );

Add the above to your functions.php file.

Thanks,
Shane

[Akhil]

Yes i do see decimal field after selecting number, it appear only after i edit that field back.

Btw may i know how do i confirm that the attributes are applied well.?
i believe is at database? could you point me the location please. thanks

[Shane]

Hello,

The field would be in the database, does your view filter correctly with the decimals now ?

Could you confirm this ?

Thanks,
Shane

[Akhil]

Yes It does, thanks.

I am also hard-coding the field as i need other attributes which is not in the options, thus i need to check the database that the attributes are stored correctly, could you point me a sample please. thanks

[Shane]

Hello,

The field should be stored in the post_meta table in your database under the name wpcf-{custom field slug}

Try searching your database for this. However it should be stored correctly without any issues.

THanks,
Shane