Postmeta Table question

  • Hello Peter

    I came to try this plugin as I want to group similar data stored in posts on my site using a value which is only visible from the Postmeta table. So, with this in mind I search and upon finding your app was very impressed with everything from the support to the documentation and the user community who have given you many praises. Now onto my questions. Using the Post table as the parent I have been able to select the the posts in question and limit them with a where clause so that I only receive those unique posts in the results. For each post there are many entries which are related to the Post, which I want to display as my projects goal. This should be accomplished using the one2many relationship and a parent/child connection. When I view the results it is working and I get the relevant entries which are related to the Post. But it isn’t what I want to see. It seems to be due to how the postmeta table stores its data. In fragments, and unrelated, using only 4 fields to store various types of meta data. In my case, for PostID 1234 I want to see all related meta data of a certain type, however the postmeta table isn’t structure in a way that I can see the data like this. In order for me to see all entries of people who have rsvp to a PostID 1234, I must identify the postmeta records which matches the postID 1234, then within this subset of records I will have a list of people who have made an RSVP, but I only have a UserID of the person to use to identify them, where I need to use some looping logic along with a [SQL:SELECT in (SQL:SELECT) search[, followed by a for each type statement. So my question which now seems very confusing is asking if it is possible to use WP Data Access to make sense of the Postmeta table? Just as an aside, even though this hasn’t been working, I have found other uses for the plugin which I will be able to make use of. Thank you

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi,

    Welcome! That’s complex issue… ??

    Let me see if I understand your question correctly first:
    You already found a way to create a parent-child page with the post table as its parent and the postmeta table as its child table. Now you want to make the postmeta data “readable”, say display the data in table and its columns form. Do I understand your question correctly?

    The plugin works with database tables and columns. WordPress postmeta data contain their own json, objects, arrays and fields (and more…?). You cannot display this postmeta data as a “normal” table with its columns. But you could try to add “dummy columns” to your (postmeta) base table and then fill those dummy columns while you’re building the table.

    I think is will be hard if not even impossible to build a generic solution, but you should be able to build a specific solution. I you have a test set which I could use I can give it a try. If you prefer to send it in private you can send me a message from the plugin website. Please let me know…

    Best regards,
    Peter

    Thread Starter charlsouma

    (@charlsouma)

    Hello Peter

    Thank you. Yes you understand my question 100%. And I now understand why what I am trying to do is so difficult. I will send you my data test set.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Postmeta Table question’ is closed to new replies.