[Resolved] Query custom field

[Author]

Posts

[davidm-13]

Hi, I have a Toolset custom field:
wpcf-plant-notes.
How would I query this field to display all existing values?
Can I find it using PHPMyAdmin?

Your help much appreciated

[Minesh]

Hello. Thank you for contacting the Toolset support.

Can you please tell me where exactly you want to display all the existing values for your custom field "wpcf-plant-notes"?

Do you want to add view filter or you have different usage?

In addition to that - Could you please send me debug information that will help us to investigate your issue.
=> https://toolset.com/faq/provide-debug-information-faster-support/

[davidm-13]

Hi Minesh, thanks for reply.
I just need to query wpcf-plant-notes to see where it's used, not important if it's from the front or back end.

Thanks

[Minesh]

Toolset post custom field stored in postmeta database table.

So you can query the postmeta table where meta key equal to your desired key i.e. wpcf-plant-notes

And you will be able to see all the values.

[davidm-13]

Hi Minesh,
Followed you instructions and arrived to attached image, but can't find the (plant) post specified by post_id.
Any ideas?

Thanks

[Minesh]

You can click on "Search" tab and search for your key as well as for your desired post id.

[davidm-13]

Hi Minesh,
Added this to functions.php:

function add_column( $columns ){
$columns['post_id_clmn'] = 'ID'; // $columns['Column ID'] = 'Column Title';
return $columns;
}
add_filter('manage_posts_columns', 'add_column', 2);

function column_content( $column, $id ){
if( $column === 'post_id_clmn')
echo $id;
}
add_action('manage_posts_custom_column', 'column_content', 2, 2);

to see post ID in plants - but the post ID for wpcf-plant-notes doesn't appear, also if i enter an ID that exists and click "Search" nothing is found - what am I doing wrong?

[Minesh]

You should be using admin columns plugin to add such columns and search for it.
- https://wordpress.org/plugins/codepress-admin-columns/