Symptom
Is it possible to apply a filter in Ad Hoc / Report - Table and Online Report Designer/ Advanced Reporting/ Report - Canvas based on a wildcard?
Environment
SAP SuccessFactors Workforce Analytics
Resolution
For Ad Hoc reporting - this is possible by using the "Like" operator when defining the Filter condition. Try adding the percent "%" character before and/or after the word that should be matched if you need results that include a specific word.
E.g. the report should return results with the word "department"- set it as "Like %department%" so that the results will show all records containing the word department
For Online Report Designer Live Data and Advanced Reporting - Yes this is possible by using the Like operator when setting a Custom Value in the filter designer.
e.g. Location like "AU". This will return values like AU01, AU02 etc.
Keywords
ORD filters, static filter, runtime filter, wildcard filters, report filters, using like operator, % for wildcard searching, ad hoc wildcard filter, report-table wildcard filter, like condition filter , KBA , LOD-SF-ANA-RCT , Report Centre , How To