Grid filters List

[UniterYazilim]

Hello there,

I want to do line-based filtering in UniDBGrid. The following image shows an example made with Ext.Grid.

How can I do this in UniGui?

Thanks.

Best regards.

 

Ext.Grid Example: https://docs.sencha.com/extjs/6.0.0/classic/Ext.grid.filters.filter.List.html

[Hayri ASLAN]

Hello

Please check attached sample application.

Available values for Filter = "boolean,date,list,number,string"

CustomDBGrid.rar

[UniterYazilim]

thank you so much @Hayri ASLAN

you are very good inheritance!

I want this feature to come by default in the future UniGui @Farshad Mohajeri.

 

 

[multimesut]

Merhaba @Hayri ASLAN bu Filter değişkenini columns properties kısmında göstermenin bir yolu var mı?

[Gauravg]

On 1/18/2019 at 6:31 PM, Hayri ASLAN said:

Hello

Please check attached sample application.

Available values for Filter = "boolean,date,list,number,string"

CustomDBGrid.rar

Hi,

Can you please share the sample application?

[Sherzod]

28 minutes ago, Gauravg said:

Can you please share the sample application?

Hello,

Sorry, are you still using the trial version?

[x11]

when i open the project: TuniFilerDBGrid not found

[x11]

if blank

[x11]

On 1/19/2019 at 1:28 PM, UniterYazilim said:

I want this feature to come by default in the future UniGui

+1

[rgreat]

Yes, but it needs to be upgraded with text search box for values and limitation of menu subitems.

Also 'mark all' and 'unmark all' menu items.

In current state it is not really user friendly.

 

But still. Good job. And thanks for sharing.

[Gauravg]

On 8/12/2020 at 1:50 PM, Sherzod said:

Hello,

Sorry, are you still using the trial version?

No. i am using licensed version of Delphi. 

[Sherzod]

7 minutes ago, Gauravg said:

No. i am using licensed version of Delphi. 

Hello,

I meant the UniGUI version...

[x11]

On 8/12/2020 at 4:11 PM, x11 said:

when i open the project: TuniFilerDBGrid not found

up

Delphi 10.3, uniGUI 1.90.0.1534

[Gauravg]

44 minutes ago, Sherzod said:

Hello,

I meant the UniGUI version...

Hello,

I am using Delphi 10.2 and UniGui version 1.90.0 build 153.

[x11]

Please tell me. Why are there no filters in the grid?

thank you

procedure TfmMainForm.UniFormCreate(Sender: TObject);
begin
  CreateFilterDBGToday;
end;

procedure TfmMainForm.CreateFilterDBGToday;
var
  i:integer;
  FieldType: TFieldType;
  Column: TUniDBGridColumn;
begin
// dbgToday is a TUniDBGrid
  dbgToday.JSInterface.JSConfigPlugin('Ext.grid.filters.Filters', ['id', 'gridFilters']);

  for i := 0 to Pred(dbgToday.Columns.Count) do
  begin
    Column := dbgToday.Columns[i];
    Column.Filtering.Enabled := True;
    Column.Sortable := True;

    FieldType := dbgToday.DataSource.DataSet.FindField(Column.FieldName).DataType;

    case FieldType of
      ftString          : dbgToday.JSInterface.JSConfig('filter', ['string'], Column.JSColumn);
      ftDate, ftDateTime: dbgToday.JSInterface.JSConfig('filter', ['date'], Column.JSColumn);
      ftInteger, ftFloat: dbgToday.JSInterface.JSConfig('filter', ['number'], Column.JSColumn);
      ftBoolean         : dbgToday.JSInterface.JSConfig('filter', ['boolean'], Column.JSColumn);
      else
        dbgToday.JSInterface.JSConfig('filter', ['list'], Column.JSColumn);
    end;// case
  end;// for


//  Available values for Filter = "boolean,date,list,number,string"
// http://forums.unigui.com/index.php?/topic/11857-grid-filters-list/&do=findComment&comment=63164
end;

 

[x11]

Уважаемые разработчики, почему вы не хотите сделать, чтобы компонента uniDBGrid поддерживала эти фильтры?

[x11]

On 1/17/2019 at 10:01 AM, UniterYazilim said:

I want to do line-based filtering in UniDBGrid. 

 

but how to do this in the mobile grid - unimDBGrid?

[x11]

On 1/18/2019 at 7:31 PM, Hayri ASLAN said:

Please check attached sample application.

summary not working

[unicasoft]

On 1/18/2019 at 8:31 PM, Hayri ASLAN said:

Hello

Please check attached sample application.

Available values for Filter = "boolean,date,list,number,string"

CustomDBGrid.rarUnavailable

Files not found.

[MSMK]

On 10/1/2020 at 4:54 PM, x11 said:

Please tell me. Why are there no filters in the grid?

thank you

procedure TfmMainForm.UniFormCreate(Sender: TObject);
begin
  CreateFilterDBGToday;
end;

procedure TfmMainForm.CreateFilterDBGToday;
var
  i:integer;
  FieldType: TFieldType;
  Column: TUniDBGridColumn;
begin
// dbgToday is a TUniDBGrid
  dbgToday.JSInterface.JSConfigPlugin('Ext.grid.filters.Filters', ['id', 'gridFilters']);

  for i := 0 to Pred(dbgToday.Columns.Count) do
  begin
    Column := dbgToday.Columns[i];
    Column.Filtering.Enabled := True;
    Column.Sortable := True;

    FieldType := dbgToday.DataSource.DataSet.FindField(Column.FieldName).DataType;

    case FieldType of
      ftString          : dbgToday.JSInterface.JSConfig('filter', ['string'], Column.JSColumn);
      ftDate, ftDateTime: dbgToday.JSInterface.JSConfig('filter', ['date'], Column.JSColumn);
      ftInteger, ftFloat: dbgToday.JSInterface.JSConfig('filter', ['number'], Column.JSColumn);
      ftBoolean         : dbgToday.JSInterface.JSConfig('filter', ['boolean'], Column.JSColumn);
      else
        dbgToday.JSInterface.JSConfig('filter', ['list'], Column.JSColumn);
    end;// case
  end;// for


//  Available values for Filter = "boolean,date,list,number,string"
// http://forums.unigui.com/index.php?/topic/11857-grid-filters-list/&do=findComment&comment=63164
end;

 

Доброе время суток! Разобрались с этим вопросом? Меня в частности волнует локализация фраз Filters и прочие фразы?

[Sherzod]

6 minutes ago, =GGG= said:

Меня в частности волнует локализация фраз Filters

 

[x11]

Не помню уже. Насколько я понял, локализация зашита в extJS.

 

[x11]

А "Столбцы", "Сортировать.... ?

[MSMK]

14 hours ago, Sherzod said:

 

спасибо!

[MSMK]

14 hours ago, x11 said:

А "Столбцы", "Сортировать.... ?

Спасибо!