Find Which Tests An Image Is Used In

Work Process - Purpose
- To find which exams are using a certain image.
Work Process - Summary
- Image are defined in TM017_IMAGE table which has an IMAGE_ID column and an IMAGE_FILE_NAME_TXT column. The name of the image is defined at run time when added to a question having the QUESTION_ID (from TM103_QUESTION) as the name of the image, followed by the extension i.e. ".jpg". Finding the image name, as displayed in the PDF application will give you the question number which in turn you may use the previous procedure to find exams containing the image.
Contribution Of The Client Group To The Work Process
- The Client Group may locate the image name as displayed in the PDF Application as follows by selecting "Test Questions" in the left menu and finding a question containing an image:
Steps Of The Work Process
- In the procedure described in the previous section, use IMAGE_FILE_NAME_TXT, without the extension as the search parameter as follows:
  SELECT DISTINCT EXAM_GROUP_ID
  FROM TM107_XREF_EXAM_GRP_QUESTION
  WHERE QUESTION_ID = '555' /*without the .jpg extension*/
  ORDER BY EXAM_GROUP_ID;