How to use a Query that References Two Tables of a Map Service

WilliamMiller4 — Sun, 12 Dec 2021 04:07:27 GMT

Hi,

I need to query two tables from a map service. Below is how the SQL statement I would like to use might look.

var queryString = "";
//from URL_For/MapServer/2
queryString += "Neighborhood_ID = '" + this.m_Neighborhood + "'";
queryString += " AND Use_Code_Dsc = '" + this.m_UseCodeOne + "'";
//from URL_For/MapServer/1
queryString += " AND convey_date = " + this._formatSqlDate(this.m_SaleDateSingle);
queryString += " AND consideration " + this.m_SalePriceOperatorDisplay + " " + this.m_SalePriceSingle;
query.where = queryString‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

How would I use QueryTask? I have two URLs. Is there a way to join the tables and then perform the QueryTask?

Thank you for your time.

William

Re: How to use a Query that References Two Tables of a Map Service

RobertScheitlin__GISP — Wed, 08 Feb 2017 14:37:40 GMT

William,

You will want to join the data in ArcMap and then publish a new map service that you can then query.

topic How to use a Query that References Two Tables of a Map Service in ArcGIS Web AppBuilder Questions

How to use a Query that References Two Tables of a Map Service

Re: How to use a Query that References Two Tables of a Map Service