Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Filtering is not working in ADF Table column of type Date.

1000953Apr 10 2014

HI All,

i am using JDEV 11.1.2.1.0.

I have an attribut in my SQL query based view object of type below.
Type="java.sql.Timestamp"

ColumnType="DATE"

But when i drag into ADF Table as one of the columns with filtering and sorting option. But Sorting is working fine and filtering is not working when i try filtering it says no daya found.

The below is the code i used in ADF table.

<af:column sortProperty="#{bindings.ProductResults1.hints.InstallDate.name}" filterable="true"

                         sortable="true" headerText="#{bindings.ProductResults1.hints.InstallDate.label}"

                         id="c133">

                <f:facet name="filter">

                  <af:inputDate label=" " value="#{vs.filterCriteria.InstallDate}" id="id1">

                    <af:convertDateTime pattern="#{bindings.ProductResults1.hints.InstallDate.format}"/>

                  </af:inputDate>

                </f:facet>

                <af:outputText value="#{row.InstallDate}" id="ot131">

                  <af:convertDateTime pattern="#{bindings.ProductResults1.hints.InstallDate.format}"/>

                </af:outputText>

              </af:column>

Could anyone please help me here.

Thanks,

BM

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2014
Added on Apr 10 2014
0 comments
324 views