SalesforceLabs / EnhancedLightningGrid

Component that allows you to sort and filter data within the Lightning Experience. Use as a replacement for a Related List, or create a new grid that shows results from a custom query.
BSD 3-Clause "New" or "Revised" License
136 stars 97 forks source link

Pagination numbers invisible, Update Managed package #7

Closed ghost closed 2 years ago

ghost commented 6 years ago

First, when i use this, the page numbers when using the pagination are not there. It seems to have the correct number of blank spots in the list but no numbers appear. Also, after this fix can the managed package on the app exchange be updated with the fixes?

2018-07-02_13-26-21

ghost commented 6 years ago

UPDATE. It seems the page number issue is only present in Firefox and looks fine in Chrome or Edge.

I do have another issue as i am trying to use this via the Custom Data Provider. I am unable to get salesforce integer fields to display. I have tried setting the type as STRING, INTEGER and INTEGER with formatting (5,0) with no luck.

Also, to correct the code a little bit in the Custom Data Provider Example that was given here you have to get the query count without using the datalimit otherwise the query total will always be the query limit and there will be no paging.

So as an example this code

string query = 'select name from contact ' + filterstring + ' ' + sSortClause + ' limit :datalimit offset :dataoffset';
result.data = database.query(query);
result.query=query; //Only used for the debug log
result.FullQueryCount = 0;
if (result.data!=null)
{
  result.FullQueryCount = result.data.size();
}
result.pagecount = 1;

Should be something like this

string query = 'select name from contact ' + filterstring + ' ' + sSortClause + ' limit :datalimit offset :dataoffset';
result.data = database.query(query);
result.query=query; //Only used for the debug log
result.FullQueryCount = 0;
result.pagecount = 1;
if (result.data!=null)
{
   result.FullQueryCount = database.countQuery('Select COUNT() from contact ' + filterstring + ' ' + sSortClause');
   result.pagecount = result.FullQueryCount / request.pagesize;
}               

Any assistance would be much appreciated.