Need a special offer?Find out if your project fits.
+

Date type is not working in ng flexmonster

Answered
Satyanarayana asked on May 28, 2020

Hi,
We have created a wrapper for flexmonster table to reuse in multiple places. Feeding data and column definitions to the wrapper component. While passing a column type as "date string" it is not reading as a date column though set the datePattern in the options object. Below are the details of my options, datasource and column definitions, please advise asap.
 

  1. dataSource:
    1. data() []
    2. dataSourceType"json"
    3. __proto__Object
  2. formatsArray(1)
    1. 0:
      1. textAlign"left"
      2. thousandsSeparator""
      3. __proto__Object
    2. length1
    3. __proto__Array(0)
  3. options:
    1. configuratorActivefalse
    2. configuratorButtontrue
    3. datePattern"MMM ddd, yyyy"
    4. grid:
      1. blankMember""
      2. showFiltertrue
      3. showGrandTotalsfalse
      4. showHeadersfalse
      5. type"flat"
      6. __proto__Object
    5. showEmptyDatafalse
    6. __proto__Object
  4. slice:
    1. columns(2) [empty{…}]
    2. measures(59) [caption"Date", field"Date, headerTooltip"Date",type"date string", uniqueName"Date"]
    3. rows(59) [{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}{…}]
    4. __proto__Object

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 28, 2020

Hello,
 
Thank you for reaching out to us.
 
Our team would like to kindly explain that the data type of the hierarchy should be specified within the mapping object instead of the member of the measures array.
Please see an example we have prepared for you.
Detailed information about the mapping object can be found in our documentation.
 
Please let us know if this works.
In case questions arise or additional assistance is needed, please feel free to reach out.
 
Kind regards,
Illia

Public
Satyanarayana May 28, 2020

Thanks Illia for quick response, now the date type is reading by the flexmonster component. But we see sorting is not giving the expected results. Please advise asap.

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 28, 2020

Hello,
 
Thank you for writing to us.
 
In case the "Date" hierarchy is placed to rows or columns, sorting can be applied using the sort property of an appropriate element.
 
If the "Date" hierarchy is placed to measures, its sorting can be defined using the sorting property of the slice object.
 
We have modified the earlier provided example so that it demonstrates both scenarios.
 
Detailed information about the slice object and its properties, including the ones dedicated to sorting, can be found in our documentation.
 
Finally, our team would like to note that the desired configuration can be modified through UI and received using the "Save" button.
 
We hope it works.
 
Kind regards,
Illia

Please login or Register to Submit Answer