Reports marked as public not available to Everyone

[ikorzha]

If you navigate to console-->reports->Click edit report and mark it as public hit save:

Then from report filter same report shows as NOT public:. This issue result in situation that only owner can see a report that was marked as Public

[netniV]

This sounds like the save is actually failing, anything in the logs?

[netniV]

I think you'll find that in plugin_reporit_reports the report doesn't have a value in the public column.

[ikorzha]

There is nothing in the logs. I have looked at table: plugin_reporit_reports and it does have value of 1 for publish and value of 1 for scheduled. However both of these fields on reporting page show as "no"

See screenshot attached: I am also attaching an sql export of that table, feel free to import it into your db for testing: plugin_reportit_reports.txt

[netniV]

1? That sounds wrong because it should be '' (off/false) or 'on' (on/true)

[netniV]

@ikorzha Can you download the latest dev version and try again? I'm sure this is corrected now.

[ikorzha]

Unfortunately I have to state that it is not corrected. My steps: Console ->Reports->"Click on the actual report"-> See screenshot below: As you can see public check-mark is present and saved.

However on reports screen on console no checkmark is present, there is a disconnect between these 2 fields:

---

Additionally I want to mention that report saving doesn't honor any setting "saves" to scheduling portion of report:

[netniV]

Any errors in the logs?

[netniV]

So, your import says that the report is public:

All I did was keep just the INSERT INTO line, remove everything on that line upto and include the first bracket, then put a new line after the closing bracket and remove that, plus the "VALUS" text and opening bracket. Then removed the closing bracket and semi colon and then replace all the backticks(`) that were left with single quotes.

This leaves you with a CSV importable file, which I loaded into Numbers on my Mac to get the above screenshot. So, now the question is, why does your import think it's public but not public.

[netniV]

So more changes have been pushed. Saving should now work for reports.

[ikorzha]

You are making process here: Report when now marked as public retain their properties: This issue resolved.

Changes to scheduled items still do not get saved:

[ikorzha]

netniV, here is animated gif to demonstrate the issue with saving of "scheduling reporting"

[netniV]

I have an update shortly, that should hopefully resolve half of this.

[netniV]

It's part of a larger issue #53

[netniV]

Scheduling is also under #24 so I'm going to close this for now.