Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I am trying to access a sorted list of data on the basis of 'Description' which is a long text field type and it is throwing an exception on the VF page:
Cannot be filtered in query call
But when I create a view and sort the description column it works fine.
Just wanted to understand the logic behind this.
You cannot filter / sort SOQL queries using the Description fields as they are not filterable, e.g., check out the properties of the description field here for the case object. But if you want to sort by Description the only way I think you can do that is by implementing custom sort using the comparable interface. There is a post about it here
Another way is doing the sorting from the client side using javascript / jquery. There are a few good libraries which can be of help. One them being DataTable
Apart from datatable if you are looking for other plugins to build using Visualforce,you should check Jqgrid plugin .
Jqgrid has lot more functionality than datatable and provides ability to filter ,sort and paginate
http://www.trirand.com/blog/jqgrid/jqgrid.html
The above gives different demo of this plugin and also the documentation around this good
http://www.trirand.com/jqgridwiki/doku.php?id=wiki:jqgriddocs#upgrading
The description fields are not sortable
