I am using JDev 184.108.40.206.0
I have one read-only table.I have four fields.2 are string type and rest are integer and float.my problem is whenever i run the page i can search only string type fields.i am not able to search float and integer fields.how can i overcome this.Is table search having any limitations? can any one help me out please.
Thanks for the reply.table search is nothing but filter.when i want to filter the data on the table for integer values it is not working but its working for string values.i gave sortable and filterable is set to true.is there any limitations for search??please help me out.
Thanks for the reply.I am using ADFBC.In the database 2 fields are having varchar and 2 are number.
So, you have two DB fields of type NUMBER ?
In that case, your entity attribute should be a Number type, not Integer & Float (if I understand corectly)
And the Format type for those attrs needs to be Number also
This should work. Try this:
1) create a new fusion web application based on the HR schema
2) build a model with 'business components from table' and select department and employees as EO and VO
3) start a new page where you drop e.g. the employees onto as read only table
4) select sorting and filtering and singe selection
Run the app and check if you can search for salary >5000 or department id 100
Thanks for the reply.I want to search on top of the table.as if i have 100 records start with 1,10,100 etc.when i search by using 1 then it should display all the records but its showing only one record with starts 1.if i search with 10 then it should show 10,100 etc...but its showing the records start with 10.I am very much struggling with this problem.can you please suggest me the solution....
Well, you are looking for numbers (int float...) then you are looking for absolute values. If you are set 10 into the filter, you only find 10. If you like to find values greater then 10 you have to use '>10', then you find 10,11,....
You can't only find 10, 100,1000 using the filter. This only works for strings.
Workaround would be to add another column into your table (calculated) which is is the string representation of the number. This column allows you to search for 10,100,1000,... as it is a string.