topic eSearch widget and relates in ArcGIS Viewer for Flex Questions

eSearch widget and relates

EricGardecki — Thu, 14 May 2015 15:54:46 GMT

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!

Re: eSearch widget and relates

RobertScheitlin__GISP — Thu, 14 May 2015 16:03:35 GMT

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.

Re: eSearch widget and relates

EricGardecki — Thu, 14 May 2015 16:21:02 GMT

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

Re: eSearch widget and relates

EricGardecki — Sat, 11 Dec 2021 09:38:32 GMT

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!

Re: eSearch widget and relates

RobertScheitlin__GISP — Thu, 14 May 2015 21:01:13 GMT

Eric,

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

Re: eSearch widget and relates

EricGardecki — Thu, 14 May 2015 22:19:30 GMT

SQL Server

Re: eSearch widget and relates

RobertScheitlin__GISP — Sat, 11 Dec 2021 09:38:35 GMT

Eric,

Try this:

<values>
  <value prompt="From Date (MM/DD/YYYY)">BETWEEN created_date '[value] 00:00:00'</value>
  <value prompt="To Date (MM/DD/YYYY)" operator="AND">'[value] 23:59:59'</value>
</values>

If that does not work use this one:

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

Re: eSearch widget and relates

EricGardecki — Fri, 15 May 2015 13:17:28 GMT

Using between worked! But it should be "created_date BETWEEN" not the other way around apparently.

I still have to set up relates yet but I'm a step closer.

Thanks.

Re: eSearch widget and relates

EricGardecki — Fri, 15 May 2015 13:40:08 GMT

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

Re: eSearch widget and relates

RobertScheitlin__GISP — Fri, 15 May 2015 13:42:55 GMT

Eric,

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

Re: eSearch widget and relates

EricGardecki — Fri, 15 May 2015 13:56:16 GMT

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?

Re: eSearch widget and relates

TasadduqHussain — Thu, 09 Sep 2021 11:03:28 GMT

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