Load singular values from multiple tables.

  • Resolved GrundeLL

    (@grundell)


    9 years, 1 month ago

    Hello,

    So what I’m creating right now is a comparison site for financial services.

    How this will work is that I have a table of rates, costs, payment time etc etc for each company included in the site. Each table will have about 100-200 entries.

    My idea was to use TablePress to import all these values and hold them structured that way, also very easy to import / update these really large tables.

    In order to make it possible to compare these tables in a lists against each other id thought i make a global query on the tables i had included in each search (will be different companies on different lists depending on services etc). How i thought id make that possible is to use AFC-TablePress (https://www.ads-software.com/plugins/acf-tablepress/ ) to choose what tables make it on to each list.

    Now comes what i need help with:
    In order for me to do this i want to be able to create a ajax-load query that starts with some values to look for in each list in order to find the matching pair.

    I.e: search: a=”3000″ b=”12″ c=”true”

    From there i need to be able to fetch the specific values of: A, B, C, D, etc etc. and display them according to my template.

    Is this possible?
    How would I go about it?

    Hope you have time to answer my “rather long” question.

    Best Regards,
    Max

    https://www.ads-software.com/plugins/tablepress/

Viewing 1 replies (of 1 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi Max,

    thanks for your post, and sorry for the trouble.

    Unfortunately, I can’t present an existing solution to this, and from what I understand, this will require a lot of custom work. TablePress simply does not have that good search/query capabilities, as it’s not meant to be a database replacement.

    You could maybe take a look at the TablePress Row Filter Extension from https://tablepress.org/extensions/row-filter/ for some inspiration, but must likely, you’ll have to look into a full custom solution, e.g. built on a mySQL table that you can really query, and PHP code with which you can then create the desired output. (TablePress is limited to tables there, after all.)

    Regards,
    Tobias

Viewing 1 replies (of 1 total)
  • The topic ‘Load singular values from multiple tables.’ is closed to new replies.