topic Re: Attribute Table Query in Web AppBuilder Custom Widgets Questions

Attribute Table Query

LefterisKoumis — Fri, 15 May 2020 19:11:03 GMT

Looking for ways to pass on a filter expression from a widget to the Attribute Table to update the AT display based on the query, rather than opening another tab.

The table displayed in the AT is not the attribute table from the layer, but they share a unique id.

Perhaps perform the query at the widget, then close the AT and open it with the results you pass on from the widget query?

Thank you.

Re: Attribute Table Query

RobertScheitlin__GISP — Fri, 15 May 2020 21:31:28 GMT

Lefteris,

Have you seen this sample:

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

Or this thread:

https://community.esri.com/thread/178720

Re: Attribute Table Query

LefterisKoumis — Sun, 12 Dec 2021 09:19:11 GMT

Thank you Robert.

I tried applying this

            var partsObj = {
              "expr": the_expression,
              "parts": []
            };

            this.wManager = WidgetManager.getInstance();
            if (this.wManager) {
              var widgetCfg = this._getWidgetConfig('AttributeTable');
              if (widgetCfg) {
                var attWidget = this.wManager.getWidgetByLabel(widgetCfg.label);
                var activeTable = attWidget._tableFunctionController.getActiveTable();
                activeTable.setFilterObj(partsObj);
                activeTable.refresh();
              }
            }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

But I get this error.

The attWidget is not null.

UPDATE:

I turned on the visibility for a feature layer on the AT and it works.

The other table that I was trying to apply the filter on is actually a non-spatial table from web service.

I guess the filter is not working for tables in AT?

Re: Attribute Table Query

RobertScheitlin__GISP — Sat, 16 May 2020 22:09:55 GMT

I am pretty sure no spatial tables do not work in AT Widget.

Re: Attribute Table Query

LefterisKoumis — Sun, 17 May 2020 23:45:09 GMT

If I apply the filter on the non-spatial table, it displays the results. Could we call the filter programmatically on this table.

Re: Attribute Table Query

RobertScheitlin__GISP — Mon, 18 May 2020 12:18:57 GMT

Don't know.

Re: Attribute Table Query

LefterisKoumis — Sun, 12 Dec 2021 09:19:14 GMT

It seems it can be done. I am posting in case someone else, want to query a non-spatial table in the AT:

for example:

        the_expession = "UPPER(<field>) LIKE '%<something>%'"

      
      var partsObj = {
        "expr": the_expession,
        "parts": []
      };
      this.setFilterObj(partsObj);
      this.clearSelection(false);
      this.startQuery();
      
      this.emit('apply-filter', {
        layerInfoId: layerInfo.id,
        expr: partsObj.expr
      });‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍