Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    ListGrid Filter Editor does not work when grid is grouped and data is a simple Array of Records

    Please try the following code in the latest Feature Explorer in the latest Chrome version:
    - Type "c" in the Country field and press Enter.
    - The filtering incorrectly returns no items.
    - Note that if you uncomment the following line in the code, the filtering works correctly (returns 4 items):
    $900: mLocalData,

    Code:
    var mLocalData = [
    {    countryCode: 'US',     countryName: 'United States',     capital: 'Washington, DC', government: 'federal republic',   continent: 'North America',      independence: '07/04/1776', area: '9631420', population: '298444215',      gdp: '12360000'  },
    {    countryCode: 'CH',     countryName: 'China', capital: 'Beijing',      government: 'Communist state',    continent: 'Asia',     independence: '',      area: '9596960', population: '1313973713',   gdp: '8859000'   },
    {    countryCode: 'JA',     countryName: 'Japan', capital: 'Tokyo',      government: 'constitutional monarchy with parliamentary government',      continent: 'Asia',     independence: '',      area: '377835',      population: '127463611',    gdp: '4018000'   },
    {    countryCode: 'IN',     countryName: 'India', capital: 'New Delhi',      government: 'federal republic',   continent: 'Asia',      independence: '17394',      area: '3287590', population: '1095351995',      gdp: '3611000'   },
    {    countryCode: 'GM',     countryName: 'Germany',     capital: 'Berlin',      government: 'federal republic',   continent: 'Europe',      independence: '01/18/1871', area: '357021', population: '82422299',      gdp: '2504000'   },
    {    countryCode: 'UK',     countryName: 'United Kingdom',    capital: 'London',      government: 'constitutional monarchy', continent: 'Europe',      independence: '01/01/1801', area: '244820', population: '60609153',      gdp: '1830000'   },
    {    countryCode: 'FR',     countryName: 'France',      capital: 'Paris',      government: 'republic',     continent: 'Europe',   independence: '',      area: '547030', population: '60876136',     gdp: '1816000'   },
    {    countryCode: 'IT',     countryName: 'Italy', capital: 'Rome',      government: 'republic',     continent: 'Europe',      independence: '03/17/1861', area: '301230', population: '58133509',      gdp: '1698000'   },
    {    countryCode: 'RS',     countryName: 'Russia',      capital: 'Moscow',      government: 'federation',   continent: 'Asia',     independence: '33474',      area: '17075200',      population: '142893540',    gdp: '1589000'   },
    {    countryCode: 'BR',     countryName: 'Brazil',      capital: 'Brasilia',      government: 'federative republic',     continent: 'South America',      independence: '09/07/1822', area: '8511965', population: '188078227',      gdp: '1556000'   },
    {    countryCode: 'CA',     countryName: 'Canada',      capital: 'Ottawa',      government: 'constitutional monarchy with parliamentary democracy and federation',    continent: 'North America', independence: '07/01/1867',      area: '9984670', population: '33098932',     gdp: '1114000'   },
    {    countryCode: 'MX',     countryName: 'Mexico',      capital: 'Mexico (Distrito Federal)',      government: 'federal republic',   continent: 'North America',      independence: '09/16/1810', area: '1972550', population: '107449525',      gdp: '1067000'   },
    {    countryCode: 'SP',     countryName: 'Spain', capital: 'Madrid',      government: 'parliamentary monarchy', continent: 'Europe',      independence: '01/01/1492', area: '504782', population: '40397842',      gdp: '1029000'   },
    {    countryCode: 'KS',     countryName: 'South Korea', capital: 'Seoul',      government: 'republic',     continent: 'Asia',     independence: '16664',      area: '98480',   population: '48846823',     gdp: '965300'    },
    {    countryCode: 'ID',     countryName: 'Indonesia',   capital: 'Jakarta',      government: 'republic',     continent: 'Asia',     independence: '16666',      area: '1919440', population: '245452739',    gdp: '865600'    }
    ];
    
    var mMyCountryDS = isc.DataSource.create({
        clientOnly: true,
        fields: [
            { name: "countryCode", type: "text", title: "Code" },
            { name: "countryName", type: "text", title: "Country" },
            { name: "capital", type: "text", title: "Capital" },
            { name: "continent", type: "text", title: "Continent" }
        ]
    });
    
    isc.ListGrid.create({
        ID: "countryList",
        width: 500, height: 425,
        alternateRecordStyles: true,
        dataSource: mMyCountryDS,
        fields: [
            { name: "countryName" },
            { name: "continent" },
            { name: "capital" },
            { name: "countryCode" }
        ],
        groupStartOpen: "all",
        groupByField: "continent",
    
        data: mLocalData,
        //$900: mLocalData,  // _originalData
        showFilterEditor: true,
        filterLocalData: true,
        filterOnKeypress: false
    });
    Browsers: Chrome 84 and IE 11
    SmartClient versions: 11.1 and 12.1
    (We use Chrome and SmartClient v11.1p_2020-05-30/PowerEdition in our production code.)

    #2
    This should be fixed in the latest nightly builds, dated 2020-08-08 and beyond.

    Comment

    Working...
    X