Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Apex 5 Interactive Report Not Filtering on Certain Columns

Zachariah FalgoutMay 15 2017 — edited May 19 2017

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

TR

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?

This post has been answered by TexasApexDeveloper on May 18 2017
Jump to Answer

Comments

Zachariah Falgout

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

TexasApexDeveloper
Answer

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

Marked as Answer by Zachariah Falgout · Sep 27 2020
Zachariah Falgout

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.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 16 2017
Added on May 15 2017
3 comments
443 views