Problem with Columns wijmo.grid.DataMap

Problem with Columns wijmo.grid.DataMap

Posted by: m.omar on 18 June 2019, 7:53 pm EST

• 

  m.omar

  • Post Options:
  • Link
    Copy

  Posted 18 June 2019, 7:53 pm EST

  Hi Team ,

  Please check the following jsfiddle example:
  
  https://jsfiddle.net/Lsoeq5wm/10/

  Thanks.

• 

  m.omar

  • Post Options:
  • Link
    Copy

  Posted 19 June 2019, 8:34 pm EST

  Any Update … this is urgent case …
  
  Also, i have anther issue : with some clients data source of drop down list is about 42000 row , this take a big size in the page and gives bad performance while user interact with the page.
  
  So, is there is any way to load the data source of DataMap on demoed when new row added to the gird.
  
  Your fast response is appreciate.

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 19 June 2019, 9:07 pm EST

  Hello,

  For changing the data map of a column according to the row, you may handle the beginningEdit event of FlexGrid and filter out the values in data map that are not required. Also, to update the price according to the unit of measure, you may handle the cellEditEnded event and update price accordingly

  Please refer to the updated sample below:

  https://jsfiddle.net/wLo7598n/

• 

  m.omar

  • Post Options:
  • Link
    Copy

  Posted 19 June 2019, 11:03 pm EST

  Your fast response is appreciate.

• 

  m.omar

  • Post Options:
  • Link
    Copy

  Posted 19 June 2019, 11:05 pm EST

  You answers seems to be OK. it fix the problem of changing the data map of a column according to the stockitemid and also fix the problem of update the price according to the unit of measure.
  
  But by follow this answer i still have a performance issue with big data source (such as 42000 objects), because the solution basically depends on gives the Column datamap a fully data source in the begging then later can filter out the not required values in beginningEdit event ?
  
  Is there is any way to load the data source of DataMap on demoed in beginningEdit event without set Column datamap before?

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 20 June 2019, 3:00 pm EST

  Hello,

  You may load the data map on demand by checking whether the column has a data map in the beginningEdit event of FlexGrid. If the data map is not present, load the data map from the server. Please refer to the sample below:

  https://jsfiddle.net/u4avf0qc/