Extract Items from a list
Answers
-
Hi @banderson
Are the items you're checking against this list the same values all the time or would they vary depending on another dataset?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
The values should follow the same structure as this:
{
"enterpriseId" : ObjectId("5cfdaf8f591f243a00c5d6f3"),
"permissions" : [
"admin"
]
},
{
"enterpriseId" : ObjectId("5cfdaf8f591f243a00c5d6f3"),
"permissions" : [
"admin"
]
}
Where there can be any number of them, but each item should contain a enterprise id and permissions.
0 -
Is there a way to do mongo queries within domo?
0 -
The version of MySQL that Domo uses (5.6) doesn't support quite a few nice features like regular expressions so you'd need to resort to something like the LIKE command as the simplest option to see if a substring exists in your field.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I blogged about it in YouTube / on my blog.
Side note, you can do the same thing in Magic 2.0
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks jaeW_at_Onyx,
Do you know if something similar can be done when it is a list of json elements like that? My problem is all I see is that it is a List, where all elements are labeled that way. When I try to extract a specific piece, it still just shows a list. For example, the last column shows the extraction from the enterprises column that is also a list.
0 -
it looks like the data wasn't imported properly. if the actual data contains "List" then you need to revisit your connector. Had the dataset imported properly, i would expect to see a lonnnnnnnnng string.
P.S. may need to confirm with domo that you can store wide text string datasets.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
FYI There's a limit of 1024 characters for columns in your datasets.
The text in one of my data columns is getting truncated
Domo has a 1024-character limit. Any additional characters after this will be truncated. You can get around this by splitting the text between two columns to make sure it stays within the limit. You must do this in your own data before bringing it into Domo.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Ok, sounds good. Thank you both.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 298 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 33 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive