nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

filtering date in layout editor of bi publisher

875299

Summary

filtering date in layout editor of bi publisher

Content

Hi All,

I am trying to filter date in a table in layout editor of BI publisher and my filter format for date doesnot work.

please let me know if there is any other way to filter table on a date column.

below is the format i see,i am able to format the date column but not able to filter on date

Find more posts tagged with

Accepted answers

All comments

Thomas Dodds

One approach: Convert the column to text in your query first ...

875299

thanks for the reply.i am building publisher reports using rpd subject area.is there any other way to filter

875299

i did that but it is not working

Thomas Dodds

Try filtering after you apply a format ... seems like that isn't done given the picture:

with the column selected:

2017-08-16 15_51_18-Oracle BI Publisher.png

Thomas Dodds

Did you try using a parameter instead of the filter functionality in the table object?

875299

i have a table and a graph in the report.i just want to filter the table not the graph.

can i do that using a parameter.

Thomas Dodds

You have to filter on the full date + timestamp ... played with it a bit ...

2017-08-22 07_51_53-Oracle BI Publisher.png

2017-08-22 07_53_44-Oracle BI Publisher.png

875299

thank you ,it was helpful