Retrieving Meta Key and Meta Value

  • Resolved mwambembela

    (@mwambembela)


    2 years, 1 month ago

    Hello, How can I print in table Meta Key and Meta Values that are found in WordPress Table called WP_USERMETA. Please see the image in the link below

    https://prnt.sc/ZQj5wf_GUeEe

    I want those keys and values rounded with a red circle to be output in the table as a normal table. How can I complete this action?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    Hi @mwambembela,

    You can do this using custom queries in Data Publisher, however, this feature requires a premium license.

    For example:

    SELECT 'wp_usermeta'.'meta_key' as 'Meta_key'
, 'wp_usermeta'.'meta_value' as 'Meta_value'
FROM 'wp_usermeta'
WHERE ('wp_usermeta'.'meta_key' = 'nickname')
OR ('wp_usermeta'.'meta_key' = 'first_name')
OR ('wp_usermeta'.'meta_key' = 'last_name')
OR ('wp_usermeta'.'meta_key' = 'description')
OR ('wp_usermeta'.'meta_key'= 'Gender')

    Add more rows as needed.

    Hope this helps! For more information about this feature, please see: https://wpdataaccess.com/docs/data-publisher/custom-queries/

    • This reply was modified 2 years, 1 month ago by Kim L. Reason: added info, formatting
    • This reply was modified 2 years, 1 month ago by Kim L. Reason: formatting
    Thread Starter mwambembela

    (@mwambembela)

    @kimmyx We are using Premium Licence and i tried to execute the above query it said “ERROR: Invalid Query”. Any suggestion????

    Plugin Contributor Kim L

    (@kimmyx)

    Hi @mwambembela,

    Thanks for the response!

    The query above is reformatted improperly due to forum limitations.

    Since you have a Premium License, please send us a support ticket by clicking the Premium Support icon in WP Data Access > Support.

    We’ll be able to assist you properly there.

    Cheers!

    Thread Starter mwambembela

    (@mwambembela)

    Resolved

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Retrieving Meta Key and Meta Value’ is closed to new replies.