Okay
  Public Ticket #2968250
Filtering using user meta
Closed

Comments

  • adrian suhanea started the conversation

    Dear support team,

    First of all I want to congratulate you for such a great product you created.

    I was looking through the documentation and couldn't find a way to filter a table using user meta. For example to show the user just the data from his country that is already registered as a meta information in wordpress.

    I mention that the data from the table comes from a formidable form.

    Thank you so much for your guidance.

  •  1,846
    Miloš replied

    Hello, adrian suhanea

    - Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    Thank you very much for your kind words.

    - We will advise the best we can, in helping you achieve what you need here; if possible we could try to make some example as well.

    Generally speaking, the user metadata has to be pulled either using MySQL Query,

    or a WordPress DataBase Query Constructor, which can be used as a suggestion of a query, it is not an "ultimate query generator", due to the complexity of SQL itself.

    If you could give us a bit more detail about the data structure, how would the relevant resulting table and columns be looking?

    - Basically, since the data would be coming from a Formidable Form, our add-on which dynamically generates a query and pulls the data from the entries of the form, has certain limitations.

    - If you want the user to filter information that's been entered through the Form, it can be done through advanced filters.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables