UiPath Insights - Table Data Text Filtering (Object Data)

Help Insights
,
1

Hi all,

Hope you are all keeping well - I have a query regarding filtering Object Data in UiPath Insights.
I have a widget that is pulling Data from Queue Items in Our Orchestrator. Each Queue Item contains an Object “SpecificData” that contains the Information I wish to display in specific Columns on the Insights Table.

However, I only seem to be able to filter to the “SpecificData” level and am returned the full object. There is an “Advanced” option in the filtering Tab but I have no idea how to filter a “Substring”.

image
image814×402 21.7 KB

For example, In “SpecificData”, the output looks like the below:
{
“DynamicProperties”: {
“ID”: “123456”,
“Subject”: “TestTestTest”,
“Status”: “new”,
“Account_ID”: “654321”,
}
}

I would like to filter this Data in Insights to gather the “ID” and “Account_ID” fields specifically.
Is there a way to do this? Apologies if I am missing anything obvious. I’ve looked for similar topics or resources on a similar problem online but can’t seem to find any.

Thank you for your time and let me know if you have any ideas surrounding this.

Thanks in advance,
Billy.

2

Hello @Billy_Cussen!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly
Forum_Staff

3

is the data stored in queue in json format ? if yes then you will not able to achieve what you are looking for. You need keep the data as key value pair in queue . Insights reads the field name under specific data and creates custom table.