Update config workbook to use new projects_contents mapping table

[mcoles]

Update config workbook to use new projects_contents mapping table

[AirCooledNut]

Perfect, just as I thought. Thanks!

Yeah, I couldn't get the code formatting to work either, thus the messy looking message o' mine.

[mcoles]

This should be a fix for it, but need to test on a 2023.1 Tableau Server instance to be sure.

VizAlertsConfig_2020.4_with_fix.twb.txt

[mcoles]

This does not work, as the _workbooks view does not appear to have been updated with the new project mapping logic. (sigh).

The SQL joins necessary will look like this:

INNER JOIN workbooks w ON v.workbook_id = w.id INNER JOIN sites st ON v.site_id = st.id INNER JOIN projects_contents pc ON w.id = pc.content_id AND pc.content_type = 'workbook' INNER JOIN projects p ON pc.project_id = p.id

[AirCooledNut]

Is the above INNER JOIN statement in addition to the list of ones near the bottom of the SQL or does it replace the existing ones near the bottom at

` INNER JOIN workbooks w

       ON v.workbook_id = w.id

    INNER JOIN sites st

       ON v.site_id = st.id

    INNER JOIN projects p

       ON w.project_id = p.id`

[mcoles]

It replaces it. Using the workbooks.project_id field is no longer valid, as of 2023.1, so you have to join to projects_contents. Not sure why the code formatter won't let me add line breaks properly...but basically you're

Replacing this:

INNER JOIN workbooks w
ON v.workbook_id = w.id
INNER JOIN sites st
ON v.site_id = st.id
INNER JOIN projects p
ON w.project_id = p.id

...with this:

INNER JOIN workbooks w
ON v.workbook_id = w.id
INNER JOIN sites st
ON v.site_id = st.id
INNER JOIN projects_contents pc
ON w.id = pc.content_id
AND pc.content_type = 'workbook'
INNER JOIN projects p
ON pc.project_id = p.id

Those changes could be written more concisely, I know, but I wanted to show how workbooks related to projects in its entirety.

[wyllwo01]

Thank you so much for contributing to this. Looks like Tableau no longer populates the project_id column in the workbook table in version 2023.1? Due to this, VizAlert specification workbooks published after upgrading to Tableau version 2023.1 do not send VizAlerts (since the inner join to the project table on workbook_id filters out workbooks and therefore the VizAlert specifications do not show in the VizAlertsConfig workbook).

Summary: VizAlerts is not compatible with Tableau 2023.1 at least due to this issue.

Do you have an estimate on when this fix will be merged to main?

Thanks!

[mcoles]

This is fixed in the v2.2.1 release