unable to get the assignment details for pending worker from checklist real time subject area

Hello Team,

while running the report from checklist real time subject area the orgainzation hierarchy levels are showing null and also all the attributes for assignment shows null

this is happening because for the join from the checklist table to assignment table.base on person id while joining it is adding the filter on primary flag = y to go to the assignment table which is not ture in case of pending worker they may have primary flag as null any suggestin how we can acheive the same below is logical query

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',ENABLE_DIMENSIONALITY=1;SELECT