topic Re: How can I customize the query widget? in Web AppBuilder Custom Widgets Questions

How can I customize the query widget?

VatsalDave2 — Sat, 18 Nov 2017 06:12:54 GMT

I need the solution for clearing the input parameters on selecting "clear this result" in the Query widget. Will appreciate a quick response from Esri Tech Support.

Re: How can I customize the query widget?

RobertScheitlin__GISP — Sun, 12 Dec 2021 09:40:27 GMT

Vatsal,

Here is a code solution to your request (Widget.js lines 27, 33 and 49 -54):

define([
    'dojo/on',
    'dojo/query',
    'dojo/Deferred',
    'dojo/_base/lang',
    'dojo/_base/html',
    'dojo/_base/array',
    'dojo/promise/all',
    'dojo/_base/declare',
    'dijit/_WidgetsInTemplateMixin',
    'jimu/utils',
    'jimu/BaseWidget',
    'jimu/MapManager',
    'jimu/filterUtils',
    'jimu/dijit/Message',
    'esri/lang',
    'esri/request',
    'esri/symbols/jsonUtils',
    'esri/layers/FeatureLayer',
    'esri/dijit/PopupTemplate',
    'esri/renderers/SimpleRenderer',
    './TaskSetting',
    './SingleQueryLoader',
    './SingleQueryResult',
    './utils',
    'jimu/LayerInfos/LayerInfos',
    'dijit/registry',
    'jimu/dijit/LoadingShelter',
    'dijit/form/Select'
  ],
  function(on, query, Deferred, lang, html, array, all, declare, _WidgetsInTemplateMixin, jimuUtils, BaseWidget,
    MapManager, FilterUtils, Message, esriLang, esriRequest, symbolJsonUtils, FeatureLayer, PopupTemplate,
    SimpleRenderer, TaskSetting, SingleQueryLoader, SingleQueryResult, queryUtils, LayerInfos, registry) {

.....

      removeSingleQueryResult: function(singleQueryResult){
        var value = null;
        array.some(this._resultLayerInfos, lang.hitch(this, function(resultLayerInfo){
          if(resultLayerInfo.singleQueryResult === singleQueryResult){
            value = resultLayerInfo.value;
            return true;
          }else{
            return false;
          }
        }));
        if(value !== null){
          this._removeResultLayerInfoByValues([value]);
          //todo clear inputs
          var spDoms = query('.jimu-filter-value-provider', this.tbody);
          array.forEach(spDoms, lang.hitch(this, function(spDom){
            var sp = registry.byNode(spDom.children[0]);
            sp.set("value", null);
          }));
        }
      },‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: How can I customize the query widget?

VatsalDave2 — Sat, 18 Nov 2017 15:09:51 GMT

You are truly awesome, Robert. I just can’t thank you enough for the great service.

You are an inspiration.

Please do not mind me picking your brains for trivialest of issues.

I have been using your widgets profusely and your help like this helps solve so many of my problems!!

Thanks once again.

Vatsal

Re: How can I customize the query widget?

RobertScheitlin__GISP — Sat, 18 Nov 2017 15:18:16 GMT

Glad to hear it. Don’t forget to mark this question as answered by clicking on the “Correct Answer” link for the reply that answered your question.

Re: How can I customize the query widget?

VatsalDave2 — Fri, 15 Dec 2017 13:54:41 GMT

Hi Robert,

I applied your code solution to the query widget and it ran perfectly for 12 of my 16 applications.

In 4 applications, however, I am facing a strange outcome.

For example, one of these applications four query parameters: Zone, Ward, Type of Facility, and Facility. The 2^nd, 3^rd and 4^th filtered by previous expression.

The user selects a zone, ward, and Type of Facility from the drop down and runs “Execute” without any selection of the Facility. The tool runs and shows all the facility of the type (say “Hospitals”) in the selected Ward of the selected Zone.

Now when I clear results and go back to tasks, I find the “Facility” populated automatically by one facility and I cannot remove that. If I try to backspace and erase, I get the Facility drop down forcing me to select one. Only after I select a new Zone/Ward/Facility Type and remove the populated value, I can remove it.

Whichever Zone, Ward or Facility Type I select, I get the same value in the automatically populated “Facility” field.

The same thing happens in three other applications.

Please help.

With regards,

Vatsal

p.s. This happens when the query is run for the first time and after each application refresh

Re: How can I customize the query widget?

RobertScheitlin__GISP — Fri, 15 Dec 2017 14:34:47 GMT

I have tried to reproduce your issue and I am not able to... It is hard for me to debug this if I can not reproduce it.

Re: How can I customize the query widget?

VatsalDave2 — Fri, 15 Dec 2017 14:40:46 GMT

Thanks for your very quick response.

I am attaching screenshots hoping it explains.

The application is on a client site and I access through AnyDesk.

Re: How can I customize the query widget?

RobertScheitlin__GISP — Fri, 15 Dec 2017 15:43:50 GMT

Vastal,

I have setup the widget using unique values for four field just like that, where values are filtered by previous expressions and I don't get this issue. Maybe you could provide you widgets config file for comparison.

Re: How can I customize the query widget?

VatsalDave2 — Fri, 15 Dec 2017 16:55:10 GMT

Hi Robert,

Is there an e-mail id where I can share things?

I do not think the culprit is four fields. This happens only the first time a query is run in a new session and only when no value is selected for the fourth field.

Which is the widget config file I need to send? Is it WAB/server/apps/#/widgets/Query/config.json?

Regards,

Vatsal

Re: How can I customize the query widget?

RobertScheitlin__GISP — Fri, 15 Dec 2017 17:58:13 GMT

Vatsal,

The config is [install dir]\server\[app#]\configs\Query\config_Query.json. You can just paste the section for one of your layers that is failing in the reply.

Re: How can I customize the query widget?

VatsalDave2 — Fri, 15 Dec 2017 18:57:34 GMT

Hi Robert,

PFA the config file. All the data for the query is coming from the same layer.

Regards,

Vatsal

Re: How can I customize the query widget?

RobertScheitlin__GISP — Fri, 15 Dec 2017 20:50:40 GMT

Vastal,

What version of WAB?

Re: How can I customize the query widget?

VatsalDave2 — Sat, 16 Dec 2017 02:12:00 GMT

I am using version 2.3.

Sorry, should have mentioned that. My mistake.

Sent from my iPhone

Re: How can I customize the query widget?

RobertScheitlin__GISP — Sat, 16 Dec 2017 02:56:58 GMT

That might be it then. I was testing using 2.6 and could never duplicate that issue.

Re: How can I customize the query widget?

VatsalDave2 — Sat, 16 Dec 2017 03:30:36 GMT

I should have mentioned that. But I need to use 2.3 for some reasons.

Sent from my iPhone

Re: How can I customize the query widget?

RobertScheitlin__GISP — Tue, 19 Dec 2017 16:29:26 GMT

Maybe time to upgrade then

Re: How can I customize the query widget?

VatsalDave2 — Tue, 19 Dec 2017 16:49:33 GMT

I am unable to do that. Can there be a solution for WAB 2.3?

Sent from my iPhone

Re: How can I customize the query widget?

RobertScheitlin__GISP — Tue, 19 Dec 2017 17:01:29 GMT

Not that I know of.

Re: How can I customize the query widget?

VatsalDave2 — Tue, 19 Dec 2017 17:17:45 GMT

Thank you very much, Robert for so much of your time and for all the help.

Regards,

Vatsal

Sent from my iPhone

Re: How can I customize the query widget?

AdamPodlewski — Mon, 09 Aug 2021 15:11:31 GMT

Hi, Robert

Can you suggest where to force outStatistics option to be used in query widget?

Regards.