As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #2640854
Creating distinct views for a table
Closed

Comments

  •  1
    Norm Sash started the conversation
    December 24, 2020 at 4:18am

    Hi,

    Is it possible to create distinct (different) views for the same datatable?

    For example, I have a membership site with silver and gold levels.  I have a manually created datatable with 10 columns of data in it.

    The contacts at the 'silver' level can only see columns 1-5, while those at the 'gold' level can see all of the columns.

    What I want to do is have two different views of the datatable set up (maybe displayed with different shortcodes).  I can then have different WP pages set up for the membership levels and have the appropriate Datatables 'view' displayed on each page.

    Can you think of a way to accomplish this with Datatables?  Is there a way to set up different front end views to the same backend Datatable?

    Thanks,

    -Norm

  •  1
    Norm Sash replied
    December 24, 2020 at 4:34am

    One way I was thinking of doing this was to create a master Manual Table.  Then create additional tables "from existing data sources" and use the manual table I created as the data source..  But surprisingly I can select many other types of data sources, but there is no option to select a Datatables table as a source.

  •  2,576
    Aleksandar replied
    December 25, 2020 at 10:21am

    Hello Norm

    If you want to create a table from a manual table, you need to create it as a table linked to an existing SQL source.

    First, go to the Editing tab of the manual table, and enable editing - check "MySQL table name for editing" and copy it (it'll be something like wp_wpdatatable_15).

    Then create a table linked to an existing source/MySQL and type in this query:

    SELECT * FROM wp_wpdatatable_15

    That will pull all the data from that manual table. The only thing you need to do is hide the wdt_ID column (that's a mandatory column for editable tables, and it's used for assigning row numbers).

    Also, if you already have a table, you can add %VAR1% as a predefined filtering value to a column where "silver" vs "gold" is defined. Then, you can use the same table to be displayed differently on front-end.

    For example [wpdatatable id=15 var1='silver'] will show the table where only "silver" is present in that column; and then [wpdatatable id=15 var1='gold'] will display the table where only "gold" is present in that column.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables