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

eSearch widget and relates

EricGardecki

Sorry if this is a stupid question but I searched and read many things and simply can't find an answer on this.

I know that I can view related tables in eSearch widget, but can I search data within the related tables (relationship class in this case) and therefore select the related feature based on that search using this widget?

thanks!

Find more posts tagged with

Accepted answers

All comments

TasadduqHussain

Using Flex Viewer eSearch Widget 3.7

Want to add calendar on date filed instead of text value to be entered.

Please provide guidance.Screenshot is attached

Thanks

DateFiled.jpg

gptool_cursor_sql.pdf

EricGardecki

Do you know of any other way I can accomplish this through the flex viewer?

Search on data in related table and select all of the features that had hits in the search result?

Maybe relates isn't even the answer for my issue...

Example:

I have a catch basin point feature class. They will be inspected and I want to keep track of all of the inspections so I created a table for just the inspections and a one to many relationship class tying it to the feature class. I want to be able to go in and get a map of say all of the catch basins that were inspected in 2014 or answer the question, which catch basins weren't inspected yet. I thought this (relationship class to table) was the answer but if I can't pull out the info as described it won't work. I can make it work in ArcMap but I want others to be able to do this through our flex app.

Any advice on how to best accomplish this? I considered archiving (and no relates) but it's clunky to work with and still requires ArcMap. Can the Query Widget or Attributes Table Widget help with this?

RobertScheitlin__GISP

Eric,

No that is not an option that I am aware of.

EricGardecki

I believe I have everything set up. I have eSearch searching a table that is related to a feature class. It brings back a list and there is an icon for seeing the related record for each record that was found with the search. Clicking the icon shows the related record and is then zoomed to.

But I need to select ALL of the related features to everything in the search results so I can display them at once and have them in the datagrid. One at a time doesn't help. Is this possible?

Thanks

EricGardecki

SQL Server

RobertScheitlin__GISP

Eric,

What is the underlying DB for your Geodatabase (SQL Server, fgdb, Ocacle,etc)?

EricGardecki

Well I didn't want to have to ask but I've now spent all afternoon on this and can't even see what you suggested in action because I can't seem to get any results searching on dates. I apparently just don't have the format right but I don't know what else to try anymore. Can you tell me how to search on dates? I'm using SQL geodatabase and the field is the auto-created editor tracking field.

This is what I have currently but have tried tons of things. I get no errors, just no results. And I verified that there are some entries in the table to find. I tried YYYY/MM/DD and appending 00:00:00. Frustrated!

                    <values>
  <value prompt="From Date (MM/DD/YYYY)">created_date &gt;= '[value]'</value>
  <value prompt="To Date (MM/DD/YYYY)" operator="AND">created_date &lt;= '[value]'</value>
                    </values>

Suggestions? thanks!

EricGardecki

That does make sense. I'll test that out and see if it does what I'm trying to do. Thanks!

RobertScheitlin__GISP

Eric,

You can add the related data (likely a table) as a table in eSearch and then search the table layer and the related data (likely the feature layer) will be zoomed to and selected when using the relates in reverse. Hope that male sense.

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.