Loading...

RE: Sort Items by Current Year

RE: Sort Items by Current Year

#5193
Anonymous
Anonymous
Participant

Hi Vishnu,

  I'm a bit confused, you mention both "sort" and "display" in your question. I'm going to answer both situations.

For sorting in qListView there is an option in ezEdit tab Display called Sort Fields. Put your fields and orders there (ie Last Name DESC,  DateOfBirth ASC). This will sort the items on the initial load of the data.

For filtering the data use the CAML filter options.

In your case you need to create a calculated field in your list that would store the year portion of the Created field and use CAML filter to build a condition based on this field and hard code current year.

Also you can think of adding a list that would store some years (ie2012, 2013, ..) and use this in a qSelector and have set the initial value to 2012 and use this qSelector to pass a session to the qListView and build your CAML filter based on a session.

Please check the product documentation for more details.