GrapeCity Forums

i'm really struggling with filtering...any examples available?

i've looked at filtering example in the installed samples but can not emulate that process in my own work.

thanks

Hello,

What is that you are not able to achieve using filtering? In case the supplied sample project was not helpful, you may search the forums for numerous previous posts related to filtering. Here is one of them.

thanks, thats great!

having looked at the sample, is that page using ajax to load the data?

im using a slightly modified version, replacing the java call with just a onclick button event which displays the filtered rows.  on the sample it appear to be instant display wihtout pageload (although i know it is hitting pageload) maybe its just because im filtering on a large number of rows?

could i use ajax to just display the filtered rows?

Zell, 

Referring to the spWebProductTour sample, the DropDownList1 executes a client side script called filterAuthors. In this event there is a call to the CallBack method of the Spread which initiates a partial post back of the page. 

Apart from this, the spread has EnableAjaxCall and EnableClientScript set to true. 

I hope it helps.

Regards, 

i have this working now...my error because my dropdown was called from a content page/master page..so my dropdown name changed when published.

1 last thing regarding this topic...
if i use basic filtering i.e just set hideRowFilter.ShowFilterIndicator = true;
if i'm using multiple filters..farpoint updates those other filters with a new set of results automatically. (i.e i have 3 filters...i select an item in filter 1, filter 2 & 3 are updated with results from filter 1)

however, following the example provided which populates a dropdown using fpSpread.ActiveSheetView.GetDropDownFilterItems..
if i did this process for 3 filters...they dont automatically update after a filter selection is made.  Is it possible to repopulate these dropdown filters with the results of filter 1?

i can do this using ajax / update panel..but i wonder if there was a easier approach using farpoint?

i.e:
automatic display filters:
- select item from filter 1
  - farpoint spread updates results based on filter
  - filter 2 & 3 also only show filtered results

// Filter 1
ArrayList unitFilterItemList = matrixFpSpread.ActiveSheetView.GetDropDownFilterItems(4);
if (unitFilterItemList != null)
for (int i = 0; i < unitFilterItemList.Count; i++)
DropDownList3.Items.Add(unitFilterItemList.ToString());

//Filter 2
ArrayList managingConsultantFilterItemList = matrixFpSpread.ActiveSheetView.GetDropDownFilterItems(6);
if (unitFilterItemList != null)
for (int i = 0; i < managingConsultantFilterItemList.Count; i++)
ManagingConsultantDropDownList.Items.Add(managingConsultantFilterItemList.ToString());

// Filter 3
ArrayList teamContactFilterItemList = matrixFpSpread.ActiveSheetView.GetDropDownFilterItems(8);
if (unitFilterItemList != null)
for (int i = 0; i < teamContactFilterItemList.Count; i++)
TeamContactDropDownList.Items.Add(teamContactFilterItemList.ToString());

Hello,

There is not a simple way to determine the items for the dropdown list. You would need to use code to determine the items that are not filtered out.