C-TB1200-90 Latest Exam Braindumps
Question 3: You create a query for an approval process to check for service purchase orders over 3000 invalue. When you test the approval process you get an error from the query. What is wrong with this
query?
SELECT distinct 'true' FROM OPOR T0 WHERE $[3.0.0] = 'S' AND $[29.0.number] > 3000
A. You need to add the table name OPOR to the condition to reference the fields.
B. To refer to a field in the active window, an additional ' $' character is required before the index
values.
C. The service type 'S' is not part of the purchase order table therefore you need to refer to it using
the table and field name.
D. You should not use the 'distinct true' clause in this type of query since only a single value is
returned.
Correct Answer: B
