C_BOWI_40 · Question #99
Which two search criteria are valid when using Delegated List of Values?
The correct answer is A. a* B. *a. Delegated List of Values search in Web Intelligence uses the asterisk (*) as its wildcard character; the SQL percent (%) wildcard is not valid in this context.
Question
Which two search criteria are valid when using Delegated List of Values?
Options
- Aa*
- B*a
- Ca%
- D%a
How the community answered
(44 responses)- A89% (39)
- C2% (1)
- D9% (4)
Why each option
Delegated List of Values search in Web Intelligence uses the asterisk (*) as its wildcard character; the SQL percent (%) wildcard is not valid in this context.
The pattern 'a*' is valid in Delegated List of Values search because the asterisk acts as a wildcard matching any trailing characters, returning all values that begin with the letter 'a'.
The pattern '*a' is valid in Delegated List of Values search because the leading asterisk matches any preceding characters, returning all values that end with the letter 'a'.
The pattern 'a%' is invalid for Delegated List of Values search because the percent sign is a SQL wildcard and is not recognized as a wildcard operator within the Web Intelligence LOV search interface.
The pattern '%a' is invalid for Delegated List of Values search because Web Intelligence LOV search only recognizes the asterisk (*) as a wildcard, not the SQL percent (%) character.
Concept tested: Delegated List of Values wildcard search syntax
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/0b7c5e4c96084f4f880d48e28c5efc9e
Topics
Community Discussion
No community discussion yet for this question.