Combine two result sets with indicators into one view
Requirement : My client wanted to have a dashboard, where user can see all the published knowledge articles reviewed and yet to be reviewed by the user itself. CRM stores knowledge article views data into Knowledge Article View table. As per the requirement I have to show two different result sets into one view. One result set for Reviewed and another for Yet To Be Reviewed articles. At first, Created a Choice data type column with logical name as mad_knowledgearticleviewstatus in Knowledge Article table. To show article view status for the user. Here are the options for the same: Note, I have used icons in the label to show the view status. These icons act as an indicator. Blue icon(🔵) is used for Yet To Be Reviewed status and White icon(⚪) is used for Reviewed status. This field wasn't created to store any data, instead data for this field would be dynamically shown based on the logged in user. In the next step, Created a simple view in Knowledge Article table t