Shortcode within table Cell Hide Reports under Plugin Settings

Those are both good suggestion. I have been meaning to add option to control what reports are listed in the admin menu but the shortcode idea is good too. So, to be clear on what you are asking for, you want the values returned by the recordset to be run through the do_shortcode function, right?

you want the values returned by the recordset to be run through the do_shortcode function, right?

I guess yes, ?? .
I have an image url stored in a [shortcode=”image-url-1″]. So i insert this shortcode [shortcode=”image-url-1″] as a value inside my database table.

Then i use the [sqlreport=”report-table-with-images”] inside my post with the expected results.

I guarantee a “small breakfast donation” for your effort when the shortcode thing is done ??

+Congrats for your net neutral support.

* [SQLREPORT name=”report-table-with-images”]

I just released an update that fixes these errors.

I also added the do_shortcode function to the report output so that any shortcodes in the report would be processed before the output is displayed.

Please upgrade to version 4.11.13 and let me know how that works for you.

Hey,
That’s really awesome work with the shortcodes. By far the only plug in that can do this, and works just perfect.

Now about the second request. I don’t see any changes other than the panel have moved from the right side of my admin panel to the left (and that feels awkward to be honest).

Im going to have up to 5.000 Reports. Every time i go to create a new report, my browser is loading all 5.000 (report names) . If there was a way to do it in a way to appear 10 reports / page for example would be great. And completely remove them from the default WordPress menu at the left side.

Thanks in advance, im going to donate right away.

Wow, 5000? No wonder you need those reports off of the menu. The next big change I have planned will do this but I won’t have time to finish it for a little while. It’s going to be a complete restructuring that will allow for many new features.

Until then, there is a simple alteration that you could make to my code that would effectively disable generating a menu item for each report. The function add_submenu_page is called three time in my code, the second call (on line 820) is where all those Reports are placed on the menu. If you rem that line out then the reports will not show on the menu but you will not be able to bring up the reports in the admin either. However, I found a way for you to conditionally remove all the reports form the menu except the one you are editing. Just modify these two lines on 819 and 820 from:

$Rfunc = str_replace(‘-‘, ‘_’, $Rslug);
add_submenu_page($base_page, $Rname, ‘<div class=”dashicons dashicons-admin-page”></div> ‘.$Rname, “activate_plugins”, $Rslug, $Rfunc);

to this:

elseif (isset($_GET[“page”]) && $_GET[“page”] == $Rslug) {$Rfunc = str_replace(‘-‘, ‘_’, $Rslug);
add_submenu_page($base_page, $Rname, ‘<div class=”dashicons dashicons-admin-page”></div> ‘.$Rname, “activate_plugins”, $Rslug, $Rfunc);}

Ohhh thats Great!