nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

definition and sql queries within Insights

WinstonMcKenna

Is there any possible way to create a sql query or a def query within Insights? As far as I can tell sql queries are not possible within a joined table in Insights. It seems to be a very noticeable limitation on this platform. One way I have experimented with to work around this is to create a joined query later in ArcMap and then publish that service to Portal. Needless to say it's not the easiest or most fun way to create an Insights workbook. If anyone has some ideas, I would love to hear them.

-Thanks

Find more posts tagged with

Accepted answers

NathanSmith8

Hi Winston McKenna‌,

Great question! Currently, there is no way to perform SQL queries in Insights.

However:

1. The filtering capability provides basic functionality for the time being.

2. We will be evolving our current filtering capabilities at both the dataset and card level as part of our 2018 road map. This will include increased flexibility in defining a custom where clause.

What specific type of queries are you looking to perform? This will help us as we evolve the filtering experience in Insights.

Thanks,

Nathan

All comments

NathanSmith8

Hi Winston McKenna‌,

Great question! Currently, there is no way to perform SQL queries in Insights.

However:

1. The filtering capability provides basic functionality for the time being.

2. We will be evolving our current filtering capabilities at both the dataset and card level as part of our 2018 road map. This will include increased flexibility in defining a custom where clause.

What specific type of queries are you looking to perform? This will help us as we evolve the filtering experience in Insights.

Thanks,

Nathan

Adam_Commeford

Hi Nathan,

Will services published with definition queries work in insights? I seem to be running into some issues.

Thank you

-AC

djamelboudjerda

des requêtes select et select distincte avec un count

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.