Search through `users` and `usermeta` tables in the database

  • Resolved Elzette Roelofse

    (@semblance_er)


    6 years, 6 months ago

    Hello

    I am using your Search In Place Advanced plugin on this site: https://oaspa.org/
    You know it is a great plugin ?? and all working great.

    However, on this site there are pages being created dynamically from WordPress user information (eg. the list https://oaspa.org/membership/members/ where each clicks through to its own content). Im using this plugin https://www.usabilitydynamics.com/product/wp-crm which is basically using the native WordPress Users and all the data is being stored in the Users and Usermeta tables in the database. The content from the individual Members pages come from these tables in the database.

    How can I set your plugin to search through these tables too, so that it can pick up and show the content in the search result from the pages linking from https://oaspa.org/membership/members/ too?

    I realise you do have the option to add in a Post Type and Taxonomy, but Users is not any of these? Is it something I can add in here as a setting. Or is it something you can add / develop into the plugin. If so how much will it be?

    Thank you in advance. Looking forward to hear from you.

    Elzette

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @semblance_er,

    There is a confusion in your analysis, one thing is the table of users and users metadata and another thing are the content generated by the users, this information won’t be stored into these tables.

    Actually the content created by the users should be stored in the same wp_posts table but it is probable that this information be stored as a custom post type.

    If it is the case, and you want search by the custom post types too, you should install the professional version of the plugin and enter through its settings the custom post types to be considered in the search process.

    Please, visit our online demo for checking the attributes available in the settings of the professional version of the plugin:

    https://demos.net-factor.com/search-in-place/wp-login.php

    Best regards.

    Thread Starter Elzette Roelofse

    (@semblance_er)

    Hello @codepeople

    Thank you for the quick response.

    Sorry for the confusion in my message.
    The sub pages when you click on any of these members URLs from https://oaspa.org/membership/members/ have content generated by info stored under Users in the Users and Usermeta tables in the database. The CRM allow users to have additional info to the native WordPress profile info.

    Eg. a page like this – https://oaspa.org/member/african-minds/ has all of those content stored in the usermeta table. Would it be possible to be also be searched and found by your plugin? So that if a word exist on a page like this it can come up in the search result?

    Thread Starter Elzette Roelofse

    (@semblance_er)

    Sorry @codepeople – forgot to mention… I currently am using Search In Place Advanced on this site. It has the same settings as per you demo.

    Thanks again!

    Plugin Author codepeople

    (@codepeople)

    Hello @semblance_er,

    I’m sorry, but for searching in different tables than:

    wp_posts
    wp_postmeta
    wp_terms

    Would be required customize your copy of the plugin.

    If the feature is really important to your project, I can offer you a custom coding service from my private website:

    https://wordpress.dwbooster.com/request-quote-for-custom-formulas

    Best regards.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Search through `users` and `usermeta` tables in the database’ is closed to new replies.

Tags