3 Replies Latest reply on May 19, 2017 5:21 PM by Zachariah Falgout

Apex 5 Interactive Report Not Filtering on Certain Columns

Zachariah Falgout May 15, 2017 6:56 PM

Apex: 5.0.3

Universal Theme

Standard report filtering, column headers and actions menu

So I have a schedule of class for the university that will be replacing an old tool, and I have come across an issue that I can't really find info on.

On certain columns, when I try to apply a filter, either through the actions menu or the column header link, if I select a value that is comprised of

a listagg where the separator is either chr(13), chr(10), or chr(13)||chr(10), I don't know for certain which one it is because I didn't set up the database

and currently that code was lost and is being redone, apex will try to apply the filter but will return no results, even though I can find that data in the report.

For example say a class is on Monday, Wednesday, Friday and Tuesday, Thursday, that value will appear as

MWF

in the report, and the column header shows that value as MWF TR for a possible filter. However, no classes are returned even if that class exists in the non

filtered report.

Does anyone know if this is a bug in Apex, or should filters not have non special character separation?

1. Re: Apex 5 Interactive Report Not Filtering on Certain Columns

Zachariah Falgout May 18, 2017 10:04 PM (in response to Zachariah Falgout)

So it is separate by chr(13). This seems like a bug in Apex to me.
Like Show 0 Likes(0)

Actions
2. Re: Apex 5 Interactive Report Not Filtering on Certain Columns

TexasApexDeveloper May 18, 2017 10:57 PM (in response to Zachariah Falgout)

HTML does NOT use the same carriage return + line feed as database. You have the CR+LF characters in the field, and the search can't deal with them properly. To html a <br> is a line break. To be honest your database design leaves something to be desired..

I would save this as MTWTHF and get rid of the break between..

Thank you,

Tony Miller
Los Alamos, NM
Like Show 0 Likes(0)

Actions
3. Re: Apex 5 Interactive Report Not Filtering on Certain Columns

Zachariah Falgout May 19, 2017 5:21 PM (in response to TexasApexDeveloper)

It is broken up to be on separate lines so the different schedules for a class line up the same.
So MWF 9-950 Building A
TR 11-150 Building B
where days, times, and buildings are in their own column. Makes it easy for students to read.
Lol, probably but I am stuck with how the university stored the data, so I only have control over the table that combines the data from various per-existing tables.
So it is a bit difficult getting things to work and look nice in the app when the data that was originally stored isn't very neat.
But your answer makes sense, and honestly wouldn't have thought it as a html not being able to handle those characters. Still new to apex.

Thanks for your help.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.