Many-to-Many latest live record missing when saving as draft.
Many-to-Many relationship table does not show live content when there is a draft content
the join table is as below:
the query used for the live content is as below:
From the query above, it seems that it is ignoring the draft content but the draft content contains some of the non draft content which is previously selected as shown in the version table below:
The query used for draft content is as below:
the draft content shows fine.
the issue is the live many-to -many relationship is marked as draft even if its existing record, thus making the live record not able to show when a draft is saved.
the record was called using event.getPageProperty('banner') from the view
Affected preside version: 10.12.16, have checked previous draft issue fixes and this was not resolved and raised as a new bug.