Example for Context Message Query Parameter

The example retrieves formula data based on an object reference associated with a project.

SELECT FSFORMULA.FORMULA_CODE,  
 FSFORMULA.VERSION,  
 FSFORMULA.DESCRIPTION,  
 FSFORMULA.CLASS,  
 FSFORMULA.YIELD,  
 FSFORMULA.MODIFY_DATE,  
 FORMULA_CODE + '\' + VERSION  
 AS DR_FORMULA_FORMULA_CODE  
FROM FSOBJECTREFERENCE OBJREF  
JOIN FSFORMULA  
 ON OBJREF.OBJECT_KEY = [%1]  
WHERE OBJREF.OBJECT_TYPE = 'PROJECT'  
 AND CAST(OBJREF.R_OBJECT_KEY AS INT) =  
 FSFORMULA.FORMULA_ID

The [%1] placeholder is replaced at runtime with the value provided through the query parameter.