Fetch Data Faster for Dashboard
Comments
-
[color=#141414]Hi,[/color]
[color=#141414]
[/color]
[color=#141414]I have a dashboard that shows number of requests per state (i.e: submission, reviewed, approved, rejected). [/color]Currently, I use a Fetch All step to fetch all data of the Flow Data Extensions then I use Rule Collection Filter Step to filter ProcessState. It works fine but performance is not good since loading time is quite long even there are few records. I think Fetch All step will get all record then it caused slow performance. I tried to use Fetch Entities but there is no option to set criteria for Process State.Is there any faster solution for my case?
-
A sample project is attached.
Using a Fetch Entities step, along with a Collection Filter step will help with a faster fetch. A rule is used inside the Filter Flow to either include or exclude data from the filtered list. You can pass in only the process state rather the entire extension data into the Collection Filter Step. This should help speed up the process when displaying those tiles. When setting up the Fetch Entities step ensure that the faster step is checked like in the screenshot below:
[img]att2[/img]
[i]edited by cameron@decisions.com on 10/11/2019[/i]
Howdy, Stranger!
Categories
- 4.1K All Categories
- 57 General
- 11 Training
- 200 Installation / Setup
- 1.1K Flows
- 106 Rules
- 259 Administration
- 212 Portal
- 487 General Q & A
- 690 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 51 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 177 Pages
- 5 Process Mining
- New Features
- 177 Datastructures
- 68 Repository
- 217 Integrations
- 28 Multi-Tenant
- 27 SDK
- 76 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 66 Lunch And Learn Questions