topic Re: How to show query results in Attribute Table? in Web AppBuilder Custom Widgets Questions

How to show query results in Attribute Table?

tarunvisvanadula — Mon, 07 Jan 2019 13:13:23 GMT

hi,how can we display the query results in attribute table widget,in web appbuilder

Re: How to show query results in Attribute Table?

RobertScheitlin__GISP — Mon, 07 Jan 2019 14:03:55 GMT

Tarun,

You can follow this guide to add a layer to the Attribute table widget:

Send a layer to the Attribute Table widget—Web AppBuilder for ArcGIS (Developer Edition) | ArcGIS for Developers

You will have to create a FeatureLayer from the query results using a Feature collection. See this sample:

Feature collection | ArcGIS API for JavaScript 3.27

Re: How to show query results in Attribute Table?

simoxu — Sun, 12 Dec 2021 09:49:49 GMT

in the Widget.js for Query Widget, I made some changes to the _showResultLayerInfo function, and it seems working:

      _showResultLayerInfo: function(resultLayerInfo){
        this._hideAllSingleQueryResultDijits();
        var singleQueryResult = resultLayerInfo.singleQueryResult;
        var resutlLayer = null;
        if (singleQueryResult) {
          html.setStyle(singleQueryResult.domNode, 'display', 'block');
          var currentAttrs = singleQueryResult.getCurrentAttrs();
          resutlLayer = lang.getObject("query.resultLayer", false, currentAttrs);
        }

        if (resutlLayer) {
          this._activeLayerId = resutlLayer.id;
          this._hideAllLayers(resutlLayer);
          resutlLayer.show();
          //now show in at widget
          var layerInfo = this.layerInfosObj.getLayerInfoById(resutlLayer.id);
          this.publishData({
            'target': 'AttributeTable',
            'layer': layerInfo
          });
        }else{
          this._activeLayerId = null;
          this._hideAllLayers();
        }
      },‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Hope it helps.