Searching across multiple tables

  • Resolved extraordinarythemes

    (@extraordinarythemes)


    7 years, 11 months ago

    Hi. How are you? I hope good.

    I have a stock parts table with more than 10k rows. It’s very slow to manage in the admin area, almost impossible, but it is necessary to change quantity and prices in this table. So I splitted this table in other small tables by groups, but now I need a search box to search the data across all those tables, is it possible? What do you recommend?

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    No, sorry, such a search across multiple tables is not directly possible. You’d have to use custom JavaScript code that uses the API functions of the DataTables JS library to implement that.

    Another approach might therefore be to stick to a large table. Then, instead of editing it on the TablePress “Edit” screen (which indeed can be very slow with large tables ?? ), you would maintain/edit that table e.g. in Excel and then re-import it into TablePress (e.g. as CSV file) after making changes, and choosing to replace the existing version.

    Regards,
    Tobias

    Thread Starter extraordinarythemes

    (@extraordinarythemes)

    Thanks for the answer. I think I’m gonna have to use the excel re-import workaround for now.

    Best regards,
    Adam

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    yes, that will be the best. I’m already working on completely rebuilding the “Edit” screen, so that it will be usable again with large tables. That’s still going to take some time though.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Searching across multiple tables’ is closed to new replies.