3082984 - No data generated in Item Status Report - LMS

When generating the Item Status Report for a certain Item, the report returns blank data. The report is blank even if there is a user who have completed that specific item.

1. Learning Administration
2. Reports
3. Item Status (CSV)
4. Specify the User and Item on the report filter
5. Run the report
6. Report is blank
7. Confirm that there is a user that have completed that item

The item ID provided has a hidden character likely the zero width space (ZWSP) appended in the item ID is causing the issue liklely from copy/paste of source when making the item ID or connector file using UTF-8-BOM or other encoding instead of UTF-8.

To identify:

1. Run item Search with operator EXACT and should not appear, run again with operator CONTAINS.
2. Download search results CSV and open in notepad or similar program.
3. Save or Change encoding to ANSII to see hidden character in itemID.

Workarounds:

1.  Execute report with the user instead of itemID and filter after in CSV.
2.  Engage Professional Services to assist fixing data.
3.  Customize report filter to use contains in item criteria (see Custom Report resources KBA 2379690)
4.  Customize report to replace the ZWDP (e.g. where this ZWSP character is seen after hyphens):
   
   • Export the report
   • in the filters section of the report query, if it there is a cpnt_id then we need to replace it with REPLACE(cpnt_id, '-​', '-')
   • Re import the report as a custom report.
     
     Example of the filter:
     Actual -
     /** and sc.stud_id       in [UserSearch]
     and (sc.cpnt_typ_id, sc.cpnt_id, sc.rev_dte) in [ItemSearch]
     */
     
     Fix -
     /** and sc.stud_id       in [UserSearch]
     and (sc.cpnt_typ_id, REPLACE(sc.cpnt_id, '-​', '-'), sc.rev_dte) in [ItemSearch]
     */

NOTE: We are currently working with Product Management for a better solution.

Item Status (CSV) blank, Item Status Report blank , KBA , LOD-SF-LMS-REP , Reporting Data , Problem