Support » Plugin: EZ SQL Reports Shortcode Widget and DB Backup » [Plugin: ELI's Custom SQL Report Admin with shortcode] Couple of questions

Viewing 1 replies (of 1 total)
  • Plugin Author Eli

    (@scheeeli)

    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

Viewing 1 replies (of 1 total)
  • The topic ‘[Plugin: ELI's Custom SQL Report Admin with shortcode] Couple of questions’ is closed to new replies.