What is the significance of 'Clothes' in the following filter expression of a report query? [Product Group] = # sq( prompt( 'productgroups', 'token', 'Clothes' ) )#

Question

Options

• A'Clothes' is the default text to include in the generated query at runtime.
• BThe string 'Clothes' will precede the text of the prompt value selected at runtime.
• CThe string 'Clothes' will be appended to the end of the text of the prompt value selected at
• D'Clothes' is a required value to include in the generated query at runtime.

• A
  11% (3)
• B
  4% (1)
• C
  82% (23)
• D
  4% (1)

Explanation

In this prompt macro syntax, the third parameter passed to prompt() acts as trailing text - it is concatenated to the end of whatever value the user selects at runtime. For example, if a user selects "Winter" from the prompt, the filter resolves to [Product Group] = 'WinterClothes', with 'Clothes' tacked on after.

Why the distractors are wrong:

• A is wrong because a default value would substitute when nothing is selected - 'Clothes' does not stand in for an absent selection; it modifies an existing one.
• B is wrong because 'Clothes' appears after the selected value, not before it - the position (prefix vs. suffix) is reversed.
• D is wrong because 'Clothes' is not a hardcoded required value that always appears alone in the query; the user's runtime selection is still required and comes first.

Memory tip: Think of the three arguments as Name → Type → Tail. The third parameter is the "tail" that trails behind whatever the user picks. If it were a prefix, it would logically come first - but it's last in the argument list because it goes last in the output.

No community discussion yet for this question.