WordPress.org

Ready to get started?Download WordPress

Forums

ELI's SQL Admin Reports Shortcode and DB Backup
[resolved] [Plugin: ELI's Custom SQL Report Admin with shortcode] Couple of questions (2 posts)

  1. arny543
    Member
    Posted 1 year ago #

    A GREAT plugin!

    Just have a couple of questions

    1. How do we remove custom reports that are old?
    2. Is there a way to hide the report name on the page?
    3. Is there a way to give fields "nice names"?

    Tx again for a great plugin.

    Sean

    http://wordpress.org/extend/plugins/elisqlreports/

  2. Eli
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks!

    Here's some answers:

    1. To remove an old report just select it from the menu, then click the "Edit Report" button, then click again on what is now the "DELETE REPORT" button, then click "OK" on the warning.

    2. Every report is wrapped in DIVs with IDs which you can use for styling. If you have a report called "My Report" then it will be wrapped in a div with the id="my-report" so you could add the following line to your CSS and the title would not show up:
    #my-report h2 {display: none;}

    3. If you have a field in the table called "user_email" but you want it to show up as "E-Mail Address" on the report then just alias it in your SQL query like this (you must use ` (backticks) around aliases that have spaces in them):
    "SELECT user_email AS `E-Mail Address' FROM wp_users"
    (The ' should also be a `)
    I cannot put two ` (backticks) on the same line in a comment here
    or it would just make alias look like alias.

    I hope that covers what you want to do. Please let me know if I missed anything.

    Aloha, Eli

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic