Okay
  Public Ticket #1958060
Functionality with filtered data
Closed

Comments

  • Peter Wallace started the conversation

    Hi

    I stumbled across you're plugin and think it might be perfect for something I want to do. If I can explain what I want can you tell me if your product can help?

    I want to create a dashboard with a tackle of user information pulled from multiple tables. This data will need to be filtered to only show data for the group that user is a member of.

     Ideally this dashboard would have some functionality to input or edit data in the tables. I can do this with forms but if it can be done in the table it would be even better.

    I assume a query in my sql and php will be required to do some of the filtering? Does the plugin gone a ui to do this or would this have to be done so your table is only referencing queried data?

    Hope that makes sense?

    Kind regards

    Peter Wallace 

  •  471
    Isidora replied

    Hi Peter,
    Thank you for your interest in wpdatatables.

    Our plugin have option Editor roles on Editing tab in table settings – This allows you to select which WordPress user roles will be allowed to edit this table. More about this here.

    Also, wpdatatables have features Creating Editable Tables in WordPress where users can see and edit only their own data with which you can show only users data that are logged in and if they have data in table.

    In wpdataatbles you can make tables from lot data sources but if you need option Users can see and edit own data then you need to made editable tables. More on this link.

    If you plan to use wpdatatables in backend with some template then you will need to use this below so tables and modals will work normally 

    You can use function wdtOutputTable which is Helper func that prints out the table in backend. Also you have to include all modals(delete, close and edit modal template)

    <!-- /Modals -->
    <?php wdtOutputTable('1'); ?>
    <!-- Close modal -->
    <?php include WDT_TEMPLATE_PATH . 'admin/common/close_modal.inc.php'; ?>
    <!-- Close modal -->
    <!-- Delete modal -->
    <?php include WDT_TEMPLATE_PATH . 'common/delete_modal.inc.php'; ?>
    <!-- /Delete modal -->
    <!-- Edit modal -->
    <?php include WDT_TEMPLATE_PATH . 'frontend/modal.inc.php'; ?>

    About the filtering you have a lot of options like you said with custom query (own custom queriesgenerate MySQL queries to WordPress database or  any MySQL database ),  Placehodlers, Advanced filtering..

    We have Lite version of wpdatatables which you can try for free.

    wpDataTables Lite is a basic version of a popular best-selling WordPress table plugin. While some premium features are reduced, wpDataTables Lite is still quite a handy tool that allows you to quickly create tables in WordPress from different sources. You can download it from this link.

    Also, you can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.

    All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

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

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables