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; } } }

Failed Query from Joined View with Query Widget

MarieCline_Delgado

I have a view joined with a feature class (one-to-one). I have set up a query/filter in the Web App builder from the feature class to search the joined view data but the query fails.

What reasons could cause this query to fail? Can I query joined data?

Thank you!

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

MarieCline_Delgado

RobertScheitlin__GISP

Marie,

Can you attach a screen shot of your browsers web console (not just the maps image). You can access your browsers web console by pressing F12 key while your browser has focus.

MarieCline_Delgado

Thanks for the help, Jake.

I wanted to show you how I have the query set up. If you see anything I could do different to make this work, I would appreciate any feedback. I have contacted Tech Support and asked to be added to the bug. Thanks for all your help!

MarieCline_Delgado

Robert,

Here are a couple screenshots.

I have tried searching with multiple values that are known to exist and regardless of what I search I get the message that "The value entered is not valid." Also, I have this query set up for unique values. I would expect the drop-down arrow to produce multiple values to choose from, but that function will not work either.

Thank you for your help!

JakeSkinner

I just ran a quick test with a view joined to a feature class, and it appears to be the same bug. When querying with the following:

VECTOR.VECTOR.%MODIV_VCS.BlockLotQ = '83-14-'

I receive an error. However, the below worked w/o error:

"VECTOR.VECTOR.%MODIV_VCS.BlockLotQ" = '83-14-'

I would recommend contacting Tech Support to have them add your customer information to this bug and let them know this is an issue for database views as well.

JakeSkinner

Hi Marie,

I ran into a similar issue working with a customer. They were trying to query a feature class joined to a CSV file. A bug was logged for this issue: BUG-000089185.

The issue is the query required quotes around the field name to execute successfully.

Example: "<FileName.csv.<FieldName>" > 500000

This caused the Query widget in Web AppBuilder to fail since the request is sent w/o the quotes around the field name.

I would try querying the service in the REST directory to see if it too requires quotes.

RobertScheitlin__GISP

Marie,

Can you share a screenshot of what your browsers web console says the error is?

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Iniciar Sesión
Registrarse

Enlaces Rápidos

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