search

ivylabs / suitecrm-analytics

4 stars 4 forks source link

Data Exporter Tool - If the Bottom-most Parameter contains many options, the Dropdown will expand off of the page. #270

Open johnM2401 opened 3 years ago

johnM2401 commented 3 years ago

Describe the bug When viewing the Data Exporter Tool, if the Bottom-most Parameter contains many options, the Dropdown will expand off of the page. This makes some of the options unselectable, as it expands below the page, with no way to scroll down to view these.


Component What component does this bug relate to?

  1. Other - Data Exporter Tool


Solution File ExportSuiteCRMAnalyticsData.wcdf


To Reproduce Steps to reproduce the behavior:

  1. Add data to the CRM that would constitute there being a large amount of data in the bottom-most parameter on an Export
  2. As an example, Add ~8 users to the CRM, all with assigned Leads
  3. Push this to the DWH via ./run
  4. Clear caches in the Analytics-side
  5. View the Lead Data Export Parameters, and expand the bottom-most parameter.

Expected behavior User should be able to view and select all options in each of the parameters.


Screenshots

The Dropdown expands beyond the bottom of the page: image

Some options can only be found by zooming far out: image

So may not be as noticeable on Larger resolutions.


Desktop (please complete the following information):

harrisward commented 3 years ago

Oddly enough I can't reproduce this. on Xubuntu 18.04 and FF 88.01.

By default dropdown that would display below the bottom of the screen open upwards and even then the dropdown will contain a scrollbar for long lists. The only way I can force a dropdown to display off the screen is to set reduce the size of the browser to ridiculous size. Are you testing in at least 1024 / 768?

image

@johnM2401

johnM2401 commented 3 years ago

Hey @harrisward

Yep, the VM i'm using should be above 1024x768. However, even if I upscale it to 1920x1080, I am seeing this issue.

I've ran through this again at various resolutions and Browsers, and have some more info:


It appears as though this issue does not appear when using the Demo Data, The final parameter opens upwards as expected on all 5 Data Exports.

image (Leads Export w/ Demo Data)


However, the issue does appear for me when I'm using Live CRM Data: image (Leads Export w/ Live Data)


Interestingly, when using the Live CRM Data, only the "Opportunity Data Export" is fine: image

Whereas the other four Data Exports *do" have this issue on the bottom-most parameter: image


When trying to replicate, were you perhaps using Demo Data or Live Data? How do the other Exports look w/ Live Data? (eg, Leads/Cases?)

Let me know if there's anything you need that might help replicate! (ie: Screenshots/CRM DB dump)

harrisward commented 3 years ago

Hi @johnM2401, can you reproduce this issue on a dataset of your and then attach the SQL etc to this ticket?

johnM2401 commented 3 years ago

Hey @harrisward

Have attached the CRM Data & Structure as .txt files here.

Interestingly, I can only replicate this on the "Case Data Export" and "Sale Data Export" now: image

I have created a good few new users in the CRM since the last time we spoke about this. (24 May)

As the bottom-most Paramater on the "Activity Data" and "Lead Data" exports, (which now work as expected), are "Select Assigned Agent", it seems like the issue could have some correlation to the number of options in the dropdown.

analyticCRMStructure.txt analyticCRMData.txt