Re-issuing credentials for re-printing ID cards

1. Get List of RID’s printed on the particular execution from Print Listener folder. (Refer File : RIDPrintStatus.csv)
   
   

   Open

   

    

2. Verify the RID with Archive Folder whether PDF File Present or not.

   1. If PDF present and not printed then User can manually print the PDF

   2. If PDF not present in achieve folder then note down the RID in separate text file.
      
      

3. Once Verification Completed, Please execute the below queries to find out list of credential transaction id’s

   1. DB Name : mosip_print

   2. Schema : print

   3. Table : print_transaction

   4. Query
      SELECT credential_transaction_id FROM print.print_transaction where reg_id in (<comma-separated list of RIDs enclosed in single quotes>);

4. Use above query result into following query to re-trigger print.

1. DB Name mosip_credentials

2. Schema : credential

3. Table : credential_transaction

4. Query
   update credential.credential_transaction set status_code = 'NEW' where id in (<comma separated list of credential_transaction_ids enclosed in single quotes>);

This will trigger credential issuance of the selected RIDs which would be sent to the print listener for printing.