Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 59 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
There is a command similar to like SQL?
Dguglielmi
Rank 3 - Community Apprentice
Summary
There is a command similar to like SQL?
Content
Hi everyone,
I in a report RTF I need to filter the data in a table, based on the content of the string.
For example, when the field "Competence" begins with "H." insert the data in column.
Now i use this command:
<?choose:?><?when:contains(competence,'H.')?>
but, in this mode, not filter properly, because i view also when "Competence" contains "S.ACH."
There is a command similar to like SQL? or other solutions?
Thanks
0
Answers
-
You need to use "starts-with" XSL function. Take a look here
0