Domo Detailed Dataview Duplicates (DDDD)

Hi Domo Community,
We are running DOMO on top of Snowflake DB.
My problem relates to a detailed view of a card, something like this:
To get this results displayed, DOMO runs a DB query which looks something like this:
SELECT <columns>
FROM <the table>
LIMIT 50 OFFSET 50
If the dataset is bigger than 50 rows, you need to scroll down using the slide bar to get another 50 rows loaded into the DOMO view:
Now, when you do that, the DOMO engine runs exactly the same query as above to retrieve the rows.
SELECT <columns>
FROM <the table>
LIMIT 50 OFFSET 50
I think you already see my problem, anytime i use the sidebar, it loads 50 random rows from the WHOLE dataset, so eventually, the DOMO view ends up with duplicates or missing rows entirely.
I also know that the SHARE/EXCEL EXPORT button works well, as the LIMIT in that query is rather huge, but I'd like to fix the results in the DOMO data view.
Is there any way or a trick how to remedy this issue?
If there is a thread about it, please direct me.
Thanks,
George
Answers
-
Hi @George_LL
This sounds like a bug. I would reach out to Domo support and raise this issue with them.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 655 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive