User Answers

I believe you may be missing a counter variable which you could test by simply putting a 1 in the property shown in your first screenshot i.e.


Also, for ease of reading I generally convert the field names to the corresponding location so if desired the above could be


I hope this helps.

Try using single quotes in your SQL query and also defining your column name:

 Query Q1(formal as %String) As %SQLQuery [ Final ]
    SELECT patientnumber, ID, 
    WHEN ID = 50 THEN 'The is 50'
    WHEN ID = 30 THEN 'This is 30'
    ELSE 'The quantity is under 30'
    As myValue 
    FROM Audit.Table WHERE ID = :formal AND EndDate is null

Hi Jim - The business process expects the XML representation of the record which is completed by the business service.

In the example below Field1 and Field2 correspond to the field names assigned within the record map class: