Help Needed: Custom Entities Filtering Issue with Pagination in Forge

[Olga]

Hello Atlassian Community,

We are reaching out to seek your valuable assistance and insights regarding an issue we've encountered with our app developed on Forge.

We hope that by sharing our problem here, we might find others who have faced similar challenges and discovered effective solutions.

We also wish to draw the attention of Atlassian team members who might help expedite a resolution.

Issue Summary

We have identified a significant limitation with the Custom Entities API when it comes to filtering data. Specifically, the issue manifests as follows:

• Title: Custom entities filtering returns empty cursors.
• Description: When filtering data using the Custom Entities API, the system returns all cursors as if it is retrieving all data. However, each cursor only contains data that matches the filter condition; otherwise, they are empty. This behavior disrupts our pagination logic, making it impossible to determine the number of actual pages and navigate effectively.

This limitation is severely impacting our app's performance, especially given that we manage over 3,000 records. The in-memory handling of filters (using and & or operations) exacerbates the problem, leading to performance bottlenecks and inefficient data retrieval.

Steps Taken So Far

Our CEO, Alberto Expósito, has been in contact with Atlassian support. The team acknowledged the limitation and suggested using indexes to optimize query performance. However, this has not fully resolved our pagination issues.

We kindly request the Atlassian Community's assistance with the following:

1. Shared Experiences: Have you faced similar issues with the Custom Entities API and pagination? If so, what solutions or workarounds have you implemented?
2. Technical Advice: Any suggestions on alternative approaches or best practices for handling large datasets and efficient pagination in Forge?
3. Atlassian Team Support: We would greatly appreciate direct support from Atlassian team members to address this issue. A timely solution is critical for us, as our app's performance and user experience are being compromised.

Your insights and assistance would be invaluable to us as we navigate this challenge. We are committed to enhancing our app's functionality and providing a seamless experience for our users. Any help or guidance from this esteemed community will be highly appreciated.

Thank you for your time and support.

Best regards,

Sevidev Team.

[Dave Rosenlund _Trundl_]

Hi, @Olga 👋

I'm sorry to hear about this limitation's impact on your application 😕

However, the Atlassian Community is a peer network comprised (mostly) of Atlassian customers. While some Atlassian Solution and Marketplace partners, and even some Atlassians, are here, it's mostly customers.

In other words, it's not the best place to ask for peer developer support.

For that, Atlassian has a dedicated developer community.  If I were you, and if you haven't already done so, you should cross-post this to the Atlassian Developer Community.

By the way...

• It's also not the best place to ask for "Atlassian Team Support." As you say, your CEO has already contacted Atlassian support—presumably the marketplace partner developer support team.
  
  The other option you have as an Atlassian Marketplace Partner is to see if your Atlassian partner manager (every marketplace partner has one) can help you escalate things within Atlassian.
  
  
• Also, please do not post duplicate posts across the community topic areas and groups. The community SPAM bot detected and put your duplicate posts in SPAM quarantine.
  
  
• Finally, as a representative of an Atlassian Marketplace Partner, you should change your display name to reflect this. E.g., Olga _Sevidev_
  
  You should also request a "Marketplace Partner" badge (see the article below).

You can read the full guidelines for Atlassian partners in:

Atlassian Community online guidelines | Marketplace + Solution Partners | App Central

Best of luck to you and the Sevidev team!

-dave