How to search in master and detail grids

Hi Mikhail,
thanks for your response, but i already saw that reference. In the example, we are just highlighting the same text but in my case, all the rows of same text either from the master or detail grid should be filtered in a grid. Means we should have all the similar text lines in a the filtered grid, Also, if the master grid does not have the same text and its detail grid have the same text, then in this case, master grid should also be displayed. Please help me in this regard.

thank you

If you have a data-aware Grid, you can try the following way:

1. Filter the detail View's DataSet by your condition;
2. Use the master View's DataController.OnFilterRecord event to filter master View records according to your conditions. For example, take a look at the T545680: Best practive for removing/hiding rows from grid (not deleting records) thread. There you will find a small test project with the OnFilterRecord event.

Hi Mikhail,

thanks for your response, but my problem is still not solved. Let me explain you again:
I have a cxgrid with a master view and detail view. Not all the master grid lines have a detail grid.
I can filter the grid if the text is matching in a master grid but if the text is not matching in a master grid but match in the detail grid of same master grid, then I am having the problem. I am unable to filter neither the detail grid nor the master grid.

For filtering only the master grid, i am using :
cxGrid1TableView1.DataController.Filter.Root.AddItemList(fboOr) .AddItem(cxGrid1TableView1ColumnDesc, foLike, '%'+ss+'%', '%'+ss+'%')

Please help me, if i have to filter the detail grid.

if the text is in detail grid not in the master grid, i want the master grid line to be added in the filter grid.

thanks.

Hello,

I understand your task. This functionality is not supported by default. I recommend you consider using the approach I described in the previous post. I.e. filter the detail View's DataSet and then use the OnFilterRecord to filter only required master View records. Did you try this?
I've attached a small test project that demonstrates the approach in action.

Hi Mikhail,
sorry, the sample example you gave me, that is for bound mode(data-aware grid), I am working on non-data-aware grid i.e. Provider mode.
I cannot use client dataset in provider mode. Please help me in this regard.

thanks

If you are using unbound Views, you can try to iterate through all Views (master View and detail View Clones) as it is described in the A1885: How to iterate through Grid Views Knowledge Base article and filter each Clone. Then use the OnFilterRecord to filter only required master View records. For example:

Delphi
procedure TForm2.ProcessView(AView: TcxCustomGridView);  
begin  
  AView.DataController.OnFilterRecord := OnMyFilterRecord;  
end;  

procedure TForm2.cxButton1Click(Sender: TObject);  
var  
  I, J: Integer;  
  View: TcxCustomGridView;  
begin  
  for I := 0 to cxGrid1.ViewCount - 1 do  
  begin  
    View := cxGrid1.Views[I];  
    if not View.IsPattern then  
    begin  
//      ProcessView(View)  
    end  
    else  
      for J := 0 to View.CloneCount - 1 do  
        ProcessView(View.Clones[J]);  
 end;  
end;  

procedure TForm2.OnMyFilterRecord(ADataController: TcxCustomDataController;  
  ARecordIndex: Integer; var Accept: Boolean);  
var  
  AVal: Variant;  
begin  
  AVal := ADataController.Values[ARecordIndex, cxGrid1TableView2Column1.Index];  
  Accept := Pos(<your text>, VarToStr(AVal)) > 0;  
end;  

Hi Mikhail, i tried your logic, but i am able to search only the first letter, ex: if i have to search Flame in master detail grid, then only 'F' is used as a filter. Below is my code, please have a look:

Delphi
procedure TSNPostEditDockingForm.DoListFilter;  
var  
  I, J, b: Integer;  
  View: TcxCustomGridView;  
  Filter: string;  
  ARecordIndex: Integer;  
begin  
  Filter := trim(EditFind.text);  
  if Filter <> '' then begin  
    while Length(Filter) > 0 do begin  
      b := pos(' ',Filter);  
      if b = 0 then  
      b := length(Filter);  
      sfilter := trim(copy(Filter,1,b));  
       if sfilter <> '' then begin  
       for I := 0 to cxGrid1.ViewCount - 1 do  
        begin  
          View := cxGrid1.Views[I];  
          cxGrid1TableView1.ViewData.Expand(True);  


          if not View.IsPattern then  
             begin  
              View.DataController.OnFilterRecord := OnMyFilterRecord1;  
             end  
          else  
          for J := 0 to View.CloneCount - 1 do  
          begin  
           View.Clones[J].DataController.OnFilterRecord := OnMyFilterRecord;  
          end;  


        end;  
        cxGrid1TableView1.ViewData.Collapse(True);  
        cxGrid1.Refresh;  
      end;  
      delete(Filter,1,b);  
    end;  
  end;  
end;  

procedure TSNPostEditDockingForm.OnMyFilterRecord(ADataController: TcxCustomDataController;  
  ARecordIndex: Integer; var Accept: Boolean);  
  var  
  AVal: Variant;  
  Filter : string;  
  begin  
    AVal := ADataController.Values[ARecordIndex, cxGrid1TableView2ColumnDesc.Index];  
    Accept := Pos(sfilter, VarToStr(AVal)) > 0;  
  end;  

procedure TSNPostEditDockingForm.OnMyFilterRecord1(ADataController: TcxCustomDataController;  
  ARecordIndex: Integer; var Accept: Boolean);  
  var  
  AVal: Variant;  
  Filter : string;  
  ARecordIndex1 : integer;  
  begin  
    ARecordIndex1 := 0;  
     if not cxGrid1TableView1.ViewData.Records[ARecordIndex].Expandable then  
    begin  
      AVal := ADataController.Values[ARecordIndex, cxGrid1TableView1ColumnDesc.Index];  
      Accept := Pos(sfilter, VarToStr(AVal)) > 0;  
    end;  
  end;  

by using this code , i am having two issues:

1. i am able to search on the basis of first letter as i mentioned .
2. In my final filtered grid, i am having all the masters lines which have the letter that i am searching for, also i am having all the master lines whose detail grid have the letter but i am having those master lines as well which are expandable but the letter is not present in its master nor in its detail.
   please guide me.

thanks