Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to filter by starts-with for 3 RTF columns?
Summary
How to filter by starts-with for 3 RTF columns?
Content
Hi All,
I have a list of results that I need to evenly show across 3 columns to look like this:
I'm not exactly sure how to do this. One idea I have is to just add a filter in each of the 3 columns for Starts-with 'A to E' for Column 1, ''G to P" for Column 2, "R" for Column 3.
I have the 3 columns built but I'm not sure how to filter the content in each of them.
The group row by code is:
<?for-each-group:row;./FIELDVALUE?><?sort:current-group()/FIELDVALUE;'ascending';data-type='text'?>
Any advice?
Thanks,
John
Answers
-
Ahhh, that makes a lot of sense, Venkat. Thank you!
0 -
Venkat, I'm having trouble with the for-each-group section.
This is what I currently have to get a list of all results.
<?for-each-group:row;./FIELDVALUE?><?sort:current-group()/FIELDVALUE;'ascending';data-type='text'?>
How do I add the filter to this? (BTW, my custom column name is ColumnVal and it is numerical.)
This doesn't work...
<?for-each-group:row;./FIELDVALUE[ColumnVal=1]?><?sort:current-group()/FIELDVALUE;'ascending';data-type='text'?>
I've attached the RTF template and the xml to this post above.
Thanks,
John
0 -
for filter use for-each-group:G_1[custom_column='value1']
0 -
My suggestion is apply all logic in data source and filter in RTF template example : create a custom column in sql query , logic for this column is if column value start with A, B,C,D,E,F then name it as value1 , for G TO P name it as value2 and for R name it as value 3 , once you are created column , the column will have only 3 values (value1,value2,value3) select case when substr(facility_name,1,1) in('A','B','C') THEN 'value1' when substr(facility_name,1,1) in('D','E','F') THEN 'value2' when substr(facility_name,1,1) in('R') THEN 'value3' end rtf_column tablename the above logic will create single custom column catgegorized by values , as you duplicated 3 tables one by one in rtf template , in the beginning of each group use filter condition like for table1
, table2
, Table3
let me know if you have any questions.
0 -
Woohoo!
This works nicely! Thank you Venkat! I was pulling out my hair!
<?for-each-group:row[COLUMNVAL=1];./FIELDVALUE?><?sort:current-group()/FIELDVALUE;'ascending';data-type='text'?>
John
0 -
sent , please check
0 -
modified Template working as expected , i have issue in uploading dcoument , please share your email , i will farward. Thanks
0 -
might be due to syntax errors please upload RTF template with sample xml data. will send you updated RTF . Thanks
0 -
It's attached above.
0 -
Venkat,
Thank you for your help. I'm still not getting a result though... This is what is in my 'group row by FIELDVALUE' field in the first column:
<?for-each-group:G_1[ColumnVal=1];./FIELDVALUE?><?sort:current-group()/FIELDVALUE;'ascending';data-type='text'?>
It just produces a blank column. I also removed the sorting just in case and it is still blank.
??
0