Table relationship

  • Resolved epi82

    (@epi82)


    4 years, 7 months ago

    Hello,
    I’d like to migrate my product into TablePress. You can see it here: https://funghi.funghiitaliani.it/

    This plugin works with a single table? Is it possible to import more than one and then define a relationship?
    For example for combos or other info displayed in main grid.

    Thank you very much.

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    It is possible to have more than one table in TablePress, also from imports, yes.

    However, it is not possible to define automatic relationship (or JOINs in SQL) or something like that, as TablePress is not a database system but can only show static tabular data.

    Regards,
    Tobias

    Thread Starter epi82

    (@epi82)

    Thank you very much for your reply.

    Other two answers:
    1- in frontend table view is it possible to hide columns? In demo examples I saw only filter and order options.

    2- in backend if I have to replace a value for a column is there any functionality to replace it for all rows or I have to do it one by one for each row?

    Thank you in advance.

    Elia

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    1) Yes, you can hide columns, via the “colvis” feature of the TablePress DataTables Buttons Extension from https://tablepress.org/extensions/datatables-buttons/

    2) No, sorry, there’s no such feature at this time. You’d have to do it one by one, or export the table to a CSV file, open that in e.g. Excel or a text editor and to the replacement there, and then re-import the CSV file, choosing to replace the existing table.

    Regards,
    Tobias

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