Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #2641382
Can Table row be display to specific user
Closed

Comments

  • Dipananda started the conversation
    December 25, 2020 at 3:32am

    Can Table row be display to specific user

    Example: My current employee name :

     1.Dipa  

     2. John

      3. Rose

    I like to show their date of birth, current salary

    but this data will be enter by the manager from one table. but i want to show specific row related to the employee name when emplyee login.

    Like when 1. Dipa  login i want to show only Dipa rows to Dipaa same for when John login I want to show rows related to John only.

    And This row can be only view not editable by that user but by only manager.


    If there is any tutorial regarding this then povide the link and i will look and purchase

    Thank you

     waiting for your good reply 

  •  2,572
    Aleksandar replied
    December 25, 2020 at 12:51pm

    Hello Dipananda

    Thank you for your interest in our plugin.

    You can use this feature only when users are logged into your WordPress site, and using their User ID. Please take a look at our documentation about Users see and edit only own data feature.

    If you need them just to see their details, without being able to edit them, you can create a manual table as an admin; go to the Editing tab, and enable editing temporarily; copy "MySQL table name for editing" and create a new table linked to an existing data source. There, choose MySQL, and use the query:

    SELECT * FROM wp_wpdatatable_1
    WHERE userid = %CURRENT_USER_ID%

    Assuming the MySQL table name for editing is wp_wpdatatable_1. This filters the table, so it always shows the values of a currently logged in user, using placeholder %CURRENT_USER_ID%.

    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