Filters and Relationship on Front End

  • Resolved adriang2099

    (@adriang2099)


    3 years, 5 months ago

    Hi guys.

    I’ve been using the free version of the plug-in for a few weeks now but I’m having trouble understanding the whole structure and can’t tell if I’m able to achieve what I want to or not:

    What I have:
    – I have the WP Database and another database.
    – In the other DB I have these tables among others: Ticker, Ticker_inv and Source.
    – Table Ticker_inv has Source_id and Ticker_name among other columns. In this table there’s a record for every Ticker per each Source_id, so you can find the same Ticker_id with different data depending on the Source.

    In the Front-End side I want to:
    – See the Ticker_inv table showing the Source name instead of ID.
    – Have the rest of Ticker_inv columns as search filters to filter through the data.

    Is it possible?
    Can you please direct me to each subject I need to properly know about to achieve it?

    Thank you very much,
    Adrián.

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

    (@peterschulznl)

    Hi Adrian,

    Do you want your table data to be editable on your web page? Or is it a read-only table?

    Thanks,
    Peter

    Thread Starter adriang2099

    (@adriang2099)

    Hi Peter, it would be read-only.
    Thanks,
    Cheers!

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Adrian,

    Presuming I understand your requirements correctly, you could create a view to join your tables. From there you can easily show the source name instead of the id (or show both).

    You can use the search builder to search within your dataset, but this depends on the size of your dataset. The search builder does not work for large tables as it does not support server side processing. How large is your dataset? How many rows do you expect?

    Here is a demo of the search builder:
    https://wpdataaccess.com/search-builder-demo/

    Just click ADD CONDITION and try…

    Does this help?
    Peter

    Thread Starter adriang2099

    (@adriang2099)

    Hi Peter.

    I expect the table to have over 30k rows at least and it would increase with time as well.

    Thread Starter adriang2099

    (@adriang2099)

    The search builder does look like a good solution, yes.

    I would also like to see a longer list, of about 100 rows as well. Is that customization available?

    • This reply was modified 3 years, 5 months ago by adriang2099.
    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Adrian,

    The list is customizable. I added an example to the documentation on this page:
    https://wpdataaccess.com/docs/documentation/data-publisher/advanced-settings/

    Please look for “Change the list of shown entries” below section “Some examples”.

    Let me know if you have any further questions,
    Peter

    Thread Starter adriang2099

    (@adriang2099)

    Hi Peter.

    Cool on the shown entries part, that solves that particular aspect.

    Do you reckon having over 30k-50k rows of data might be too much?

    Cheers.

    Plugin Author Passionate Programmer Peter

    (@peterschulznl)

    Hi Adrian,

    WP Data Access can handle 30k-50k rows, presuming your server has the necessary resources. Some plugin users use the Data Publisher to publish tables with a couple of million rows. To improve performance the Data Publisher supports some options to optimize performance for such large tables. I don’t think you’ll need to optimize for a 30k-50k table.

    I just cannot guarantee it works with the search builder. The plugin uses server side processing by default. With server side processing the plugin only loads the rows shown on your page. Unfortunately the search builder does not yet support server side processing. This means you have to load your whole dataset into the browser on page load.

    In some cases I was able to load 40k rows on page load. In other cases 15k ran into an overflow. It all depends on the structure of your table. How big is a row? Just give it a try… ??

    Let me know if you need help,
    Peter

    Thread Starter adriang2099

    (@adriang2099)

    Alright Peter, thank you for your time.

    If I need anything else I’ll let you know.

    Cheers!
    Adrián.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Filters and Relationship on Front End’ is closed to new replies.