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 #3829629
Bad table display
Closed

Comments

  •  1
    Alfred started the conversation

    CRITICAL PROBLEM Attached is a PDF with 3 screen shots: 1 from the computer on which I am logged in as Administrator, 2nd on which I am not logged in, and 3 from the wdDataTables edit table screen. As you can see, the amount of data displayed is considerably different. If you visit the link, you will also see two buttons "Classics Only" and "RoQ Results".  These two tables are built the same way using SQL Query and are accessing the same mySQL database.  When I first set this up, there was no problem. I'm not sure what could be causing this display issue. I thought it might be a cached filter, but I have deleted my browser data and received the same problem.

    Attached files:  Index of rounds screen shot.pdf

  •  1,896
    Miloš replied

    Hi Alfred,
    -Please check if you perhaps enabled these options in the Editing settings :

    1. Users see and edit only their own data
      2.  Show all rows in back-end
      4426109589.png

    If you have these two, that would explain the part of the issue where a specific row is only loaded when you log as Admin ( If you added that row with this Admin account logged in);

    Compared to how it loads no rows for non-logged users.

    - Let me know if that helps to isolate the issue?

    If that's the case, please check more details how that feature should be used here.


    If you wish to limit the number of loaded rows for Table B, while having all the data to show and be editable for an Admin, there is a workaround by making a Main Manual table for Admins, and an additional SQL table for front end users, but we can go into more details on that, if needed.


    2. In regards to how the "Details" column renders that button on the back end, compared to how it renders on front end, that is most probably a CSS conflict with your current WP Theme. In other words, probably the Theme has some CSS which overrides our default style of the table for that button.

    5791986170.png

    6420265418.png

    Can you try changing to any other WP Theme, and see if the table looks the same as from the back end?

    If so, that would isolate this part of the issue.

    Thank you.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

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

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  •  1
    Alfred replied

    Thank you. My intent was to only allow users to edit their own entries. I did not register the 'See' element of this restriction. Related question: when you restrict view to their own entries, and the link is by User ID, can I somehow link that to the user's "Last Name" which is included in the 'Choreographer' field of this table? It is a lot of work to add individual User IDs to this table of 32,000 records. If I could add all the UserIDs to the table, can the 'Add Record' function automatically pickup the current 'UserID'?