search

ivylabs / suitecrm-analytics

4 stars 4 forks source link

Data Exporter Tool, Lead Export - The "Lead Created Period" Parameter appears to return 0 results if a Period is specified. #261

Closed johnM2401 closed 3 years ago

johnM2401 commented 3 years ago

Describe the bug

When using the Data Exporter Tool to export Lead Data, you are able to define parameters.

However, it appears the "Lead Created Period" parameter will always return 0 results, regardless of the period chosen. (However, it works as expected when "All Periods" is chosen)


Component What component does this bug relate to?

  1. Other - Export Tool


Solution File ExportSuiteCRMAnalyticsData.wcdf - Lead Data Export


To Reproduce

This appears to be an issue with both Live and Demo Data, however, to replicate:

  1. Install Demo Data
  2. Refresh the Caches on the Analytics end
  3. Navigate to the Data Export Tool, and select "Lead Data Export"
  4. Select the Parameter "September - 2020"
  5. Export Data, and you will get 0 records returned image

Despite there being plenty of leads created in September image (From the F_LEAD_MANAGEMENT table)


Expected behavior Exported data should return the correct result set, when a Period is chosen.


Desktop (please complete the following information):

harrisward commented 3 years ago

This is because the SQL on the Table input for the transformation is using FLM.LEAD_CREATED_TK to filter the date parameter when it should be DD.YYYY-MM

This is because we pass the date format like YYYY-MM (2020-01) and NOT YYYYMM (202001) from the UI to the transformation

This bug is confirmed

fraserward commented 3 years ago

Transformation SQL updated.

Pull Request: https://github.com/ivylabs/suitecrm-analytics/pull/265