Queries

The sender-receiver mode can be better understood through the following scenario, which demonstrates the interaction between different queries in a database context. This example involves three specific queries:

ACTIVEPROJECTS

The list of active projects currently available in the database are returned.

SELECT  
 PROJECT_CODE,  
 DESCRIPTION,  
 UNIT_PRICE_CURRENCY,  
 STATUS_IND,  
 CLASS,  
 PROJECT_CODE AS DR_PROJECT_PROJECT_CODE,  
 'ENUM_PROJECT_STATUS_IND' AS [F_BG_Project Status],  
 'ENUM_PROJECT_CLASS' AS [F_BG_Project Class]  
FROM  
 FSPROJECT  
WHERE  
 STATUS_IND IN (0, 100, 200, 600);  

FORMULARELATEDTOPROJECTS

The formulas associated with a particular project are returned.

SELECT  
 'FORMULA' AS SYMBOLNAME,  
 FSFORMULA.FORMULA_CODE,  
 FSFORMULA.VERSION,  
 FSFORMULA.DESCRIPTION,  
 FSFORMULA.CLASS,  
 FSFORMULA.STATUS_IND,  
 FSFORMULA.YIELD,  
 FORMULA_CODE + '\' + VERSION AS DR_FORMULA_FORMULA_CODE,  
 'ENUM_FORMULA_STATUS_IND' AS [F_BG_Formula Status],  
 'ENUM_FORMULA_CLASS' AS [F_BG_Formula Class]  
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;

ITEMRELATEDTOFORMULAS

Displays the ingredients or items that are linked to a specific formula.

SELECT  
 FI.ITEM_CODE,  
 ITEM.DESCRIPTION,  
 FI.UOM_CODE,  
 ITEM.CLASS,  
 ITEM.STATUS_IND,  
 FI.QUANTITY,  
 FI.ITEM_CODE AS DR_ITEM_ITEM_CODE,  
 'ENUM_ITEM_CLASS' AS [F_BG_Item Class],
 'ENUM_ITEM_STATUS_IND' AS [F_BG_Item Status]  
FROM FSFORMULA FR  
JOIN FSFORMULAINGRED FI ON FR.FORMULA_ID = FI.FORMULA_ID  
JOIN FSITEM ITEM ON FI.ITEM_CODE = ITEM.ITEM_CODE  
WHERE FR.FORMULA_CODE = [%1]  
AND FR.VERSION = [%2];

Labels for the above queries

Lookup Codes	Lookup Language Labels
ACTIVEPROJECTS	Project Code Description Unit Price Project Status Project Class DR_PROJECT_Project Code F_BG_Project Status F_BG_Project Class
FORMULARELATEDTOPROJECTS	Symbol Name Formula Code Formula Version Description Formula Class Formula Status Yield DR_FORMULA_Formula Code F_BG_Formula Status F_BG_Formula Class
ITEMRELATEDTOFORMULAS	Item Code Description UOM Item Class Item Status Quantity DR_ITEM_Item Code F_BG_Item Class F_BG_Item Status

Note: These queries illustrate how data flows between related entities, emphasizing the sender-receiver relationship in a structured data environment.