Find Resources for Label Text in All Applications

Work Process - Purpose
- For controls which the text has been stored in the database, to be able to modify this text without releasing the applications.
Work Process - Summary
- Find the key on the application side which serves to populate the control at run time and update the text directly in the database.
Contribution Of The Client Group To The Work Process
- The Client Group will indicate the text that needs to be updated and provide such text.
Steps Of The Work Process
- Let's say we want to change the value displayed in p4501.aspx for a label control having the ID "lblValidFromDate". We can run a query on WM002_INTERFACE_ITEMS which is the table that contains all resource values for controls.
  SELECT *
  FROM WM002_INTERFACE_ITEMS
  WHERE INTERFACE_ITEM_CD = 'LBLVALIDFROMDATE';
- For other controls which are populated at runtime and change values depending on business logic such as error messages, identifiers in the dB are named in the form of an number proceeded by the letter "M" for message. For example, a message which indicates an invalid date format is identified as "M10050". We can find and modify such text using the following queries:
  SELECT *
  FROM WM002_INTERFACE_ITEMS
  WHERE INTERFACE_ITEM_CD = 'M10050';
  
  UPDATE WM002_INTERFACE_ITEMS
  SET INTERFACE_ETXT = 'INVALID DATE FORMAT', INTERFACE_FTXT = 'FORMAT DE DATE INVALIDE'
  WHERE INTERFACE_ITEM_CD = 'M10050';