search

tomansley / SimpliListViews

Salesforce List Views App Package
GNU General Public License v3.0
0 stars 0 forks source link

Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit #147

Closed Keith-Colman closed 1 year ago

Keith-Colman commented 1 year ago

Describe the bug Just installed in partial sandbox. Opened up the Everything Example. I can see account and contact list views but when selecting "Case" in the drop down list at cases I get the error in the subject and in the attached image

Simpli List View Version What version of SLV is currently being used? 2.150

To Reproduce Steps to reproduce the behavior:

  1. New Install in partial sandbox
  2. Goto Everything Example
  3. Select "Case" as the object

Expected behavior I expect to see case list views, not an error

Screenshots Attached

Desktop (please complete the following information): Windows 11, Chrome.

Additional context Add any other context about the problem here. 2023-05-20 (b)

tomansley commented 1 year ago

Hi Keith,

Interesting issue. The error is saying that the amount of data being provided to the web browser is too much. How many rows are you trying to display at one time?

Can you please send me the SOQL statement for the list view in question. You can find this by going to the SLV Admin app, then selecting the List View tab and finding the list view. Once the list view is displayed, at the bottom of the page is the field "ListView Query". That is what I am looking for.

[image: image.png]

On Sat, May 20, 2023 at 12:31 PM Keith-Colman @.***> wrote:

Describe the bug Just installed in partial sandbox. Opened up the Everything Example. I can see account and contact list views but when selecting "Case" in the drop down list at cases I get the error in the subject and in the attached image

Simpli List View Version What version of SLV is currently being used? 2.150

To Reproduce Steps to reproduce the behavior:

  1. New Install in partial sandbox
  2. Goto Everything Example
  3. Select "Case" as the object

Expected behavior I expect to see case list views, not an error

Screenshots Attached

Desktop (please complete the following information): Windows 11, Chrome.

Additional context Add any other context about the problem here. [image: 2023-05-20 (b)] https://user-images.githubusercontent.com/134161301/239701341-6ed018f0-b8c9-464b-a4ad-083f08309d43.png

— Reply to this email directly, view it on GitHub https://github.com/tomansley/SimpliListViews/issues/147, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAC3UGLS5TRXEG4DHDZBIUTXHD5X5ANCNFSM6AAAAAAYI3LNTA . You are receiving this because you are subscribed to this thread.Message ID: @.***>

Keith-Colman commented 1 year ago

Hi,

Thanks for getting back to me. At the point I get the error I haven’t selected a list view. I have only selected “Case” as the object and I immediately get the error before I can select the list view drop down. If I then go to the list view dropdown it is empty.

My current list view and the pinned list view is called “Created Today2” and this has just one record when I display it in salesforce.

The SOQL query you asked for is

SELECT CaseNumber, Contact.Namehttps://contact.name/, Subject, CreatedDate, Owner.NameOrAlias, Owner.Namehttps://owner.name/, RecordType.Namehttps://recordtype.name/, toLabel(Web_Department__c), toLabel(Support_Team__c), toLabel(Status), toLabel(Priority), toLabel(Origin), Id, RecordTypeId, CurrencyIsoCode, LastModifiedDate, SystemModstamp, Contact.Idhttps://contact.id/, ContactId, Contact.RecordTypeId, Owner.Idhttps://owner.id/, OwnerId FROM Case WHERE CreatedDate = TODAY ORDER BY CaseNumber DESC NULLS LAST, Id DESC NULLS LAST

The system is in Australia where it is 1:57 am, which explains why there is just one new case “TODAY”.

I have 345 Case List views, which is probably too many. The system is quite old and supports 650 users in multiple departments, which explains this a little.

Regards,

Keith Colman

From: tomansley @.> Sent: Tuesday, May 23, 2023 4:33 PM To: tomansley/SimpliListViews @.> Cc: Keith Colman @.>; Author @.> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation – be cautious, particularly with links and attachments.

Hi Keith,

Interesting issue. The error is saying that the amount of data being provided to the web browser is too much. How many rows are you trying to display at one time?

Can you please send me the SOQL statement for the list view in question. You can find this by going to the SLV Admin app, then selecting the List View tab and finding the list view. Once the list view is displayed, at the bottom of the page is the field "ListView Query". That is what I am looking for.

[image: image.png]

On Sat, May 20, 2023 at 12:31 PM Keith-Colman @.<mailto:@.>> wrote:

Describe the bug Just installed in partial sandbox. Opened up the Everything Example. I can see account and contact list views but when selecting "Case" in the drop down list at cases I get the error in the subject and in the attached image

Simpli List View Version What version of SLV is currently being used? 2.150

To Reproduce Steps to reproduce the behavior:

  1. New Install in partial sandbox
  2. Goto Everything Example
  3. Select "Case" as the object

Expected behavior I expect to see case list views, not an error

Screenshots Attached

Desktop (please complete the following information): Windows 11, Chrome.

Additional context Add any other context about the problem here. [image: 2023-05-20 (b)] https://user-images.githubusercontent.com/134161301/239701341-6ed018f0-b8c9-464b-a4ad-083f08309d43.png

— Reply to this email directly, view it on GitHub https://github.com/tomansley/SimpliListViews/issues/147, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAC3UGLS5TRXEG4DHDZBIUTXHD5X5ANCNFSM6AAAAAAYI3LNTA . You are receiving this because you are subscribed to this thread.Message ID: @.<mailto:@.>>

— Reply to this email directly, view it on GitHubhttps://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559676679, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A77SHFIOCMFTH5XXO2PPOE3XHTKEFANCNFSM6AAAAAAYI3LNTA. You are receiving this because you authored the thread.Message ID: @.**@.>>

tomansley commented 1 year ago

Ok, I think you might have nailed it. There are 345 case list views. But, I don't feel SLV should have too much of a problem handling that number.

Let me take a look at the code and see why its falling over. As a workaround for the moment if you were able to reduce that number (I am not completely sure by how much) it should start working again.

I'll get back to you.

On Tue, May 23, 2023 at 10:58 AM Keith-Colman @.***> wrote:

Hi,

Thanks for getting back to me. At the point I get the error I haven’t selected a list view. I have only selected “Case” as the object and I immediately get the error before I can select the list view drop down. If I then go to the list view dropdown it is empty.

My current list view and the pinned list view is called “Created Today2” and this has just one record when I display it in salesforce.

The SOQL query you asked for is

SELECT CaseNumber, Contact.Namehttps://contact.name/, Subject, CreatedDate, Owner.NameOrAlias, Owner.Namehttps://owner.name/, RecordType.Namehttps://recordtype.name/, toLabel(Web_Department__c), toLabel(Support_Team__c), toLabel(Status), toLabel(Priority), toLabel(Origin), Id, RecordTypeId, CurrencyIsoCode, LastModifiedDate, SystemModstamp, Contact.Idhttps://contact.id/, ContactId, Contact.RecordTypeId, Owner.Idhttps://owner.id/, OwnerId FROM Case WHERE CreatedDate = TODAY ORDER BY CaseNumber DESC NULLS LAST, Id DESC NULLS LAST

The system is in Australia where it is 1:57 am, which explains why there is just one new case “TODAY”.

I have 345 Case List views, which is probably too many. The system is quite old and supports 650 users in multiple departments, which explains this a little.

Regards,

Keith Colman

From: tomansley @.> Sent: Tuesday, May 23, 2023 4:33 PM To: tomansley/SimpliListViews @.> Cc: Keith Colman @.>; Author @.> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation – be cautious, particularly with links and attachments.

Hi Keith,

Interesting issue. The error is saying that the amount of data being provided to the web browser is too much. How many rows are you trying to display at one time?

Can you please send me the SOQL statement for the list view in question. You can find this by going to the SLV Admin app, then selecting the List View tab and finding the list view. Once the list view is displayed, at the bottom of the page is the field "ListView Query". That is what I am looking for.

[image: image.png]

On Sat, May 20, 2023 at 12:31 PM Keith-Colman @.<mailto:@.>>

wrote:

Describe the bug Just installed in partial sandbox. Opened up the Everything Example. I can see account and contact list views but when selecting "Case" in the drop down list at cases I get the error in the subject and in the attached image

Simpli List View Version What version of SLV is currently being used? 2.150

To Reproduce Steps to reproduce the behavior:

  1. New Install in partial sandbox
  2. Goto Everything Example
  3. Select "Case" as the object

Expected behavior I expect to see case list views, not an error

Screenshots Attached

Desktop (please complete the following information): Windows 11, Chrome.

Additional context Add any other context about the problem here. [image: 2023-05-20 (b)] < https://user-images.githubusercontent.com/134161301/239701341-6ed018f0-b8c9-464b-a4ad-083f08309d43.png>

— Reply to this email directly, view it on GitHub https://github.com/tomansley/SimpliListViews/issues/147, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AAC3UGLS5TRXEG4DHDZBIUTXHD5X5ANCNFSM6AAAAAAYI3LNTA>

. You are receiving this because you are subscribed to this thread.Message ID: @.<mailto:@.>>

— Reply to this email directly, view it on GitHub< https://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559676679>, or unsubscribe< https://github.com/notifications/unsubscribe-auth/A77SHFIOCMFTH5XXO2PPOE3XHTKEFANCNFSM6AAAAAAYI3LNTA>.

You are receiving this because you authored the thread.Message ID: @.**@.>>

— Reply to this email directly, view it on GitHub https://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559727322, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAC3UGLB5IVKSDZ6HZEWWO3XHTNCRANCNFSM6AAAAAAYI3LNTA . You are receiving this because you commented.Message ID: @.***>

Keith-Colman commented 1 year ago

Cheers,

We are currently migrating Six Zendesk systems into salesforce, so the number of list views is only going to go up unfortunately…. But I’ll have a look.

Regards,

Keith

From: tomansley @.> Sent: Tuesday, May 23, 2023 5:06 PM To: tomansley/SimpliListViews @.> Cc: Keith Colman @.>; Author @.> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation – be cautious, particularly with links and attachments.

Ok, I think you might have nailed it. There are 345 case list views. But, I don't feel SLV should have too much of a problem handling that number.

Let me take a look at the code and see why its falling over. As a workaround for the moment if you were able to reduce that number (I am not completely sure by how much) it should start working again.

I'll get back to you.

On Tue, May 23, 2023 at 10:58 AM Keith-Colman @.<mailto:@.>> wrote:

Hi,

Thanks for getting back to me. At the point I get the error I haven’t selected a list view. I have only selected “Case” as the object and I immediately get the error before I can select the list view drop down. If I then go to the list view dropdown it is empty.

My current list view and the pinned list view is called “Created Today2” and this has just one record when I display it in salesforce.

The SOQL query you asked for is

SELECT CaseNumber, Contact.Namehttps://contact.name/, Subject, CreatedDate, Owner.NameOrAlias, Owner.Namehttps://owner.name/, RecordType.Namehttps://recordtype.name/, toLabel(Web_Department__c), toLabel(Support_Team__c), toLabel(Status), toLabel(Priority), toLabel(Origin), Id, RecordTypeId, CurrencyIsoCode, LastModifiedDate, SystemModstamp, Contact.Idhttps://contact.id/, ContactId, Contact.RecordTypeId, Owner.Idhttps://owner.id/, OwnerId FROM Case WHERE CreatedDate = TODAY ORDER BY CaseNumber DESC NULLS LAST, Id DESC NULLS LAST

The system is in Australia where it is 1:57 am, which explains why there is just one new case “TODAY”.

I have 345 Case List views, which is probably too many. The system is quite old and supports 650 users in multiple departments, which explains this a little.

Regards,

Keith Colman

From: tomansley @.<mailto:@.>> Sent: Tuesday, May 23, 2023 4:33 PM To: tomansley/SimpliListViews @.<mailto:@.>> Cc: Keith Colman @.<mailto:@.>>; Author @.<mailto:@.>> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation – be cautious, particularly with links and attachments.

Hi Keith,

Interesting issue. The error is saying that the amount of data being provided to the web browser is too much. How many rows are you trying to display at one time?

Can you please send me the SOQL statement for the list view in question. You can find this by going to the SLV Admin app, then selecting the List View tab and finding the list view. Once the list view is displayed, at the bottom of the page is the field "ListView Query". That is what I am looking for.

[image: image.png]

On Sat, May 20, 2023 at 12:31 PM Keith-Colman @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>>

wrote:

Describe the bug Just installed in partial sandbox. Opened up the Everything Example. I can see account and contact list views but when selecting "Case" in the drop down list at cases I get the error in the subject and in the attached image

Simpli List View Version What version of SLV is currently being used? 2.150

To Reproduce Steps to reproduce the behavior:

  1. New Install in partial sandbox
  2. Goto Everything Example
  3. Select "Case" as the object

Expected behavior I expect to see case list views, not an error

Screenshots Attached

Desktop (please complete the following information): Windows 11, Chrome.

Additional context Add any other context about the problem here. [image: 2023-05-20 (b)] < https://user-images.githubusercontent.com/134161301/239701341-6ed018f0-b8c9-464b-a4ad-083f08309d43.png>

— Reply to this email directly, view it on GitHub https://github.com/tomansley/SimpliListViews/issues/147, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AAC3UGLS5TRXEG4DHDZBIUTXHD5X5ANCNFSM6AAAAAAYI3LNTA>

. You are receiving this because you are subscribed to this thread.Message ID: @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>>

— Reply to this email directly, view it on GitHub< https://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559676679>, or unsubscribe< https://github.com/notifications/unsubscribe-auth/A77SHFIOCMFTH5XXO2PPOE3XHTKEFANCNFSM6AAAAAAYI3LNTA>.

You are receiving this because you authored the thread.Message ID: @.**@.mailto:***@***.******@***.***>>

— Reply to this email directly, view it on GitHub https://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559727322, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAC3UGLB5IVKSDZ6HZEWWO3XHTNCRANCNFSM6AAAAAAYI3LNTA . You are receiving this because you commented.Message ID: @.<mailto:@.>>

— Reply to this email directly, view it on GitHubhttps://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559741731, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A77SHFKUETPMMIK42LIDIMLXHTN47ANCNFSM6AAAAAAYI3LNTA. You are receiving this because you authored the thread.Message ID: @.**@.>>

tomansley commented 1 year ago

If your org uses Groups then more than likely it is automatically creating list views for those groups......which are never used.

You might want to start there.

On Tue, May 23, 2023 at 11:09 AM Keith-Colman @.***> wrote:

Cheers,

We are currently migrating Six Zendesk systems into salesforce, so the number of list views is only going to go up unfortunately…. But I’ll have a look.

Regards,

Keith

From: tomansley @.> Sent: Tuesday, May 23, 2023 5:06 PM To: tomansley/SimpliListViews @.> Cc: Keith Colman @.>; Author @.> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation – be cautious, particularly with links and attachments.

Ok, I think you might have nailed it. There are 345 case list views. But, I don't feel SLV should have too much of a problem handling that number.

Let me take a look at the code and see why its falling over. As a workaround for the moment if you were able to reduce that number (I am not completely sure by how much) it should start working again.

I'll get back to you.

On Tue, May 23, 2023 at 10:58 AM Keith-Colman @.<mailto:@.>>

wrote:

Hi,

Thanks for getting back to me. At the point I get the error I haven’t selected a list view. I have only selected “Case” as the object and I immediately get the error before I can select the list view drop down. If I then go to the list view dropdown it is empty.

My current list view and the pinned list view is called “Created Today2” and this has just one record when I display it in salesforce.

The SOQL query you asked for is

SELECT CaseNumber, Contact.Namehttps://contact.name/, Subject, CreatedDate, Owner.NameOrAlias, Owner.Namehttps://owner.name/, RecordType.Namehttps://recordtype.name/, toLabel(Web_Department__c), toLabel(Support_Team__c), toLabel(Status), toLabel(Priority), toLabel(Origin), Id, RecordTypeId, CurrencyIsoCode, LastModifiedDate, SystemModstamp, Contact.Idhttps://contact.id/, ContactId, Contact.RecordTypeId, Owner.Idhttps://owner.id/, OwnerId FROM Case WHERE CreatedDate = TODAY ORDER BY CaseNumber DESC NULLS LAST, Id DESC NULLS LAST

The system is in Australia where it is 1:57 am, which explains why there is just one new case “TODAY”.

I have 345 Case List views, which is probably too many. The system is quite old and supports 650 users in multiple departments, which explains this a little.

Regards,

Keith Colman

From: tomansley @.<mailto:@.>> Sent: Tuesday, May 23, 2023 4:33 PM To: tomansley/SimpliListViews @.<mailto:@.>> Cc: Keith Colman @.<mailto:@.>>; Author @.<mailto:@.>> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation – be cautious, particularly with links and attachments.

Hi Keith,

Interesting issue. The error is saying that the amount of data being provided to the web browser is too much. How many rows are you trying to display at one time?

Can you please send me the SOQL statement for the list view in question. You can find this by going to the SLV Admin app, then selecting the List View tab and finding the list view. Once the list view is displayed, at the bottom of the page is the field "ListView Query". That is what I am looking for.

[image: image.png]

On Sat, May 20, 2023 at 12:31 PM Keith-Colman @.<mailto: @.mailto:***@***.***%3cmailto:***@***.***>>

wrote:

Describe the bug Just installed in partial sandbox. Opened up the Everything Example. I can see account and contact list views but when selecting "Case" in the drop down list at cases I get the error in the subject and in the attached image

Simpli List View Version What version of SLV is currently being used? 2.150

To Reproduce Steps to reproduce the behavior:

  1. New Install in partial sandbox
  2. Goto Everything Example
  3. Select "Case" as the object

Expected behavior I expect to see case list views, not an error

Screenshots Attached

Desktop (please complete the following information): Windows 11, Chrome.

Additional context Add any other context about the problem here. [image: 2023-05-20 (b)] <

https://user-images.githubusercontent.com/134161301/239701341-6ed018f0-b8c9-464b-a4ad-083f08309d43.png>

— Reply to this email directly, view it on GitHub https://github.com/tomansley/SimpliListViews/issues/147, or unsubscribe <

https://github.com/notifications/unsubscribe-auth/AAC3UGLS5TRXEG4DHDZBIUTXHD5X5ANCNFSM6AAAAAAYI3LNTA>

. You are receiving this because you are subscribed to this thread.Message ID: @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>>

— Reply to this email directly, view it on GitHub<

https://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559676679>,

or unsubscribe<

https://github.com/notifications/unsubscribe-auth/A77SHFIOCMFTH5XXO2PPOE3XHTKEFANCNFSM6AAAAAAYI3LNTA>.

You are receiving this because you authored the thread.Message ID: @.**@.mailto:***@***.******@***.***>>

— Reply to this email directly, view it on GitHub < https://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559727322>,

or unsubscribe < https://github.com/notifications/unsubscribe-auth/AAC3UGLB5IVKSDZ6HZEWWO3XHTNCRANCNFSM6AAAAAAYI3LNTA>

. You are receiving this because you commented.Message ID: @.<mailto:@.>>

— Reply to this email directly, view it on GitHub< https://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559741731>, or unsubscribe< https://github.com/notifications/unsubscribe-auth/A77SHFKUETPMMIK42LIDIMLXHTN47ANCNFSM6AAAAAAYI3LNTA>.

You are receiving this because you authored the thread.Message ID: @.**@.>>

— Reply to this email directly, view it on GitHub https://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559747914, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAC3UGLB5OPCEBLKMGVPGFLXHTOLFANCNFSM6AAAAAAYI3LNTA . You are receiving this because you commented.Message ID: @.***>

Keith-Colman commented 1 year ago

Hi,

Did you get a chance to look at the code yet?

Keith Colman

From: tomansley @.> Sent: Tuesday, May 23, 2023 5:06 PM To: tomansley/SimpliListViews @.> Cc: Keith Colman @.>; Author @.> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation – be cautious, particularly with links and attachments.

Ok, I think you might have nailed it. There are 345 case list views. But, I don't feel SLV should have too much of a problem handling that number.

Let me take a look at the code and see why its falling over. As a workaround for the moment if you were able to reduce that number (I am not completely sure by how much) it should start working again.

I'll get back to you.

On Tue, May 23, 2023 at 10:58 AM Keith-Colman @.<mailto:@.>> wrote:

Hi,

Thanks for getting back to me. At the point I get the error I haven’t selected a list view. I have only selected “Case” as the object and I immediately get the error before I can select the list view drop down. If I then go to the list view dropdown it is empty.

My current list view and the pinned list view is called “Created Today2” and this has just one record when I display it in salesforce.

The SOQL query you asked for is

SELECT CaseNumber, Contact.Namehttps://contact.name/, Subject, CreatedDate, Owner.NameOrAlias, Owner.Namehttps://owner.name/, RecordType.Namehttps://recordtype.name/, toLabel(Web_Department__c), toLabel(Support_Team__c), toLabel(Status), toLabel(Priority), toLabel(Origin), Id, RecordTypeId, CurrencyIsoCode, LastModifiedDate, SystemModstamp, Contact.Idhttps://contact.id/, ContactId, Contact.RecordTypeId, Owner.Idhttps://owner.id/, OwnerId FROM Case WHERE CreatedDate = TODAY ORDER BY CaseNumber DESC NULLS LAST, Id DESC NULLS LAST

The system is in Australia where it is 1:57 am, which explains why there is just one new case “TODAY”.

I have 345 Case List views, which is probably too many. The system is quite old and supports 650 users in multiple departments, which explains this a little.

Regards,

Keith Colman

From: tomansley @.<mailto:@.>> Sent: Tuesday, May 23, 2023 4:33 PM To: tomansley/SimpliListViews @.<mailto:@.>> Cc: Keith Colman @.<mailto:@.>>; Author @.<mailto:@.>> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation – be cautious, particularly with links and attachments.

Hi Keith,

Interesting issue. The error is saying that the amount of data being provided to the web browser is too much. How many rows are you trying to display at one time?

Can you please send me the SOQL statement for the list view in question. You can find this by going to the SLV Admin app, then selecting the List View tab and finding the list view. Once the list view is displayed, at the bottom of the page is the field "ListView Query". That is what I am looking for.

[image: image.png]

On Sat, May 20, 2023 at 12:31 PM Keith-Colman @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>>

wrote:

Describe the bug Just installed in partial sandbox. Opened up the Everything Example. I can see account and contact list views but when selecting "Case" in the drop down list at cases I get the error in the subject and in the attached image

Simpli List View Version What version of SLV is currently being used? 2.150

To Reproduce Steps to reproduce the behavior:

  1. New Install in partial sandbox
  2. Goto Everything Example
  3. Select "Case" as the object

Expected behavior I expect to see case list views, not an error

Screenshots Attached

Desktop (please complete the following information): Windows 11, Chrome.

Additional context Add any other context about the problem here. [image: 2023-05-20 (b)] < https://user-images.githubusercontent.com/134161301/239701341-6ed018f0-b8c9-464b-a4ad-083f08309d43.png>

— Reply to this email directly, view it on GitHub https://github.com/tomansley/SimpliListViews/issues/147, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AAC3UGLS5TRXEG4DHDZBIUTXHD5X5ANCNFSM6AAAAAAYI3LNTA>

. You are receiving this because you are subscribed to this thread.Message ID: @.<mailto:@.mailto:***@***.***%3cmailto:***@***.***>>

— Reply to this email directly, view it on GitHub< https://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559676679>, or unsubscribe< https://github.com/notifications/unsubscribe-auth/A77SHFIOCMFTH5XXO2PPOE3XHTKEFANCNFSM6AAAAAAYI3LNTA>.

You are receiving this because you authored the thread.Message ID: @.**@.mailto:***@***.******@***.***>>

— Reply to this email directly, view it on GitHub https://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559727322, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAC3UGLB5IVKSDZ6HZEWWO3XHTNCRANCNFSM6AAAAAAYI3LNTA . You are receiving this because you commented.Message ID: @.<mailto:@.>>

— Reply to this email directly, view it on GitHubhttps://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1559741731, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A77SHFKUETPMMIK42LIDIMLXHTN47ANCNFSM6AAAAAAYI3LNTA. You are receiving this because you authored the thread.Message ID: @.**@.>>

tomansley commented 1 year ago

Keith,

See the latest here - https://drive.google.com/file/d/1Jz5ZJj4yM-OexrfPgd_I9KEkRAnpLHsS/view?usp=sharing

I am working on the problem but not able to reproduce right now.

Cheers Tom

Keith-Colman commented 1 year ago

Hi Tom,

Thanks for the update. Appreciate the time you have spent on this. I'll look to see if the problem exists in one of our developer sandboxes and see if I can give you access to it to debug. We have over 650 users and are consolidating hundreds more Zendesk users into salesforce (which is where my effort if focused currently) so the number of list views is only going to increase. Maybe its not so much the number of list views but their complexity that is causing the problem.

Regards,

Keith Colman

From: tomansley @.> Sent: Tuesday, June 27, 2023 10:25 PM To: tomansley/SimpliListViews @.> Cc: Keith Colman @.>; Author @.> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation - be cautious, particularly with links and attachments.

Keith,

See the latest here - https://drive.google.com/file/d/1Jz5ZJj4yM-OexrfPgd_I9KEkRAnpLHsS/view?usp=sharing

I am working on the problem but not able to reproduce right now.

Cheers Tom

- Reply to this email directly, view it on GitHubhttps://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1610240775, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A77SHFICELJDWMJNQ435HSTXNNFTBANCNFSM6AAAAAAYI3LNTA. You are receiving this because you authored the thread.Message ID: @.**@.>>

tomansley commented 1 year ago

Keith,

Thanks for the patience.

I am interested in understanding this as I know there are orgs with many more users using SLV without issue.

Perhaps the list views are more complex but I don't think that's the issue as I only bring in the list view data and metadata when a user selects one.

Either way, I would really like to get you squared away and using the app so I'll keep working this on my end.

Will keep you posted.

Cheers Tom

From: Keith-Colman @.> Sent: Wednesday, June 28, 2023 5:42:11 AM To: tomansley/SimpliListViews @.> Cc: tomansley @.>; Comment @.> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

Hi Tom,

Thanks for the update. Appreciate the time you have spent on this. I'll look to see if the problem exists in one of our developer sandboxes and see if I can give you access to it to debug. We have over 650 users and are consolidating hundreds more Zendesk users into salesforce (which is where my effort if focused currently) so the number of list views is only going to increase. Maybe its not so much the number of list views but their complexity that is causing the problem.

Regards,

Keith Colman

From: tomansley @.> Sent: Tuesday, June 27, 2023 10:25 PM To: tomansley/SimpliListViews @.> Cc: Keith Colman @.>; Author @.> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation - be cautious, particularly with links and attachments.

Keith,

See the latest here - https://drive.google.com/file/d/1Jz5ZJj4yM-OexrfPgd_I9KEkRAnpLHsS/view?usp=sharing

I am working on the problem but not able to reproduce right now.

Cheers Tom

- Reply to this email directly, view it on GitHubhttps://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1610240775, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A77SHFICELJDWMJNQ435HSTXNNFTBANCNFSM6AAAAAAYI3LNTA. You are receiving this because you authored the thread.Message ID: @.**@.>>

— Reply to this email directly, view it on GitHubhttps://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1611174319, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AAC3UGLKE6G77UHNVSGDR5DXNQDAHANCNFSM6AAAAAAYI3LNTA. You are receiving this because you commented.Message ID: @.***>

tomansley commented 1 year ago

Keith,

If you can, install the following into a sandbox and see if it solves anything -

[https:///packaging/installPackage.apexp?p0=04t3h000004VaXe](javascript:srcUp('https%3A%2F%2F%2Fpackaging%2FinstallPackage.apexp%3Fp0%3D04t3h000004VaXe%26isdtp%3Dp1');)

I have forced the number of list views displayed to be a max of 300. It cuts off the remainder. It's not optimal for business but it would at least allow us to see if this is the problem or whether its something else.

If this works then I might need to alter how list views are selected by the user by adding in the ability to type the list view name instead of putting them all into a list.

Let me know how it goes.

Cheers Tom

tomansley commented 1 year ago

URL got screwed up. Try this -

https://YOUR_INSTANCE/packaging/installPackage.apexp?p0=04t3h000004VaXe

tomansley commented 1 year ago

Keith,

Watch this - https://drive.google.com/file/d/1keZ0T4PV2a18FGksiG00iB3aqmgwuYMV/view?usp=sharing

And if you think the solution will work for you then install this into a sandbox -

https:///packaging/installPackage.apexp?p0=04t3h000004pOKX

Let me know your thoughts once you have had time to install.

Cheers Tom

Keith-Colman commented 1 year ago

Thanks for this Tom. I'll give it a try next week. Like you I'm a little bogged down presently with another Zendesk migrations.

Keith

From: tomansley @.> Sent: Wednesday, June 28, 2023 9:54 PM To: tomansley/SimpliListViews @.> Cc: Keith Colman @.>; Author @.> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation - be cautious, particularly with links and attachments.

Keith,

Watch this - https://drive.google.com/file/d/1keZ0T4PV2a18FGksiG00iB3aqmgwuYMV/view?usp=sharing

And if you think the solution will work for you then install this into a sandbox -

https:///packaging/installPackage.apexp?p0=04t3h000004pOKXhttps://%3cYOUR_INSTANCE%3e/packaging/installPackage.apexp?p0=04t3h000004pOKX

Let me know your thoughts once you have had time to install.

Cheers Tom

- Reply to this email directly, view it on GitHubhttps://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1612090983, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A77SHFOCE6AP4KZMWMAOIRTXNSKVHANCNFSM6AAAAAAYI3LNTA. You are receiving this because you authored the thread.Message ID: @.**@.>>

Keith-Colman commented 1 year ago

Hi Tom,

I installed this and the fix works. I left the feature turned off and the problem was still there, I then turned it on and all was well. Just testing it now in sandbox and getting to know the product before deploying it in production.

Thanks

Keith Colman

From: tomansley @.> Sent: Wednesday, June 28, 2023 9:54 PM To: tomansley/SimpliListViews @.> Cc: Keith Colman @.>; Author @.> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation - be cautious, particularly with links and attachments.

Keith,

Watch this - https://drive.google.com/file/d/1keZ0T4PV2a18FGksiG00iB3aqmgwuYMV/view?usp=sharing

And if you think the solution will work for you then install this into a sandbox -

https:///packaging/installPackage.apexp?p0=04t3h000004pOKXhttps://%3cYOUR_INSTANCE%3e/packaging/installPackage.apexp?p0=04t3h000004pOKX

Let me know your thoughts once you have had time to install.

Cheers Tom

- Reply to this email directly, view it on GitHubhttps://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1612090983, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A77SHFOCE6AP4KZMWMAOIRTXNSKVHANCNFSM6AAAAAAYI3LNTA. You are receiving this because you authored the thread.Message ID: @.**@.>>

tomansley commented 1 year ago

Excellent news.

I will look at getting an official release out in the next week or so and include this change.

On Mon, Jul 10, 2023 at 7:21 AM Keith-Colman @.***> wrote:

Hi Tom,

I installed this and the fix works. I left the feature turned off and the problem was still there, I then turned it on and all was well. Just testing it now in sandbox and getting to know the product before deploying it in production.

Thanks

Keith Colman

From: tomansley @.> Sent: Wednesday, June 28, 2023 9:54 PM To: tomansley/SimpliListViews @.> Cc: Keith Colman @.>; Author @.> Subject: Re: [tomansley/SimpliListViews] Error Retrieving Object List Views- Value exceed maximum size limit (100KB)l 105.6KB 105.6% of limit (Issue #147)

[External Email Alert] This email was sent from outside the organisation - be cautious, particularly with links and attachments.

Keith,

Watch this - https://drive.google.com/file/d/1keZ0T4PV2a18FGksiG00iB3aqmgwuYMV/view?usp=sharing

And if you think the solution will work for you then install this into a sandbox -

https://

/packaging/installPackage.apexp?p0=04t3h000004pOKX Let me know your thoughts once you have had time to install. Cheers Tom - Reply to this email directly, view it on GitHub< https://github.com/tomansley/SimpliListViews/issues/147#issuecomment-1612090983>, or unsubscribe< https://github.com/notifications/unsubscribe-auth/A77SHFOCE6AP4KZMWMAOIRTXNSKVHANCNFSM6AAAAAAYI3LNTA >. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>> — Reply to this email directly, view it on GitHub , or unsubscribe . You are receiving this because you commented.Message ID: ***@***.***>
tomansley commented 1 year ago

Fix released in v 2.155