topic Re: eSearch widget, sum multiple fields or create reports from results in Web AppBuilder Custom Widgets Questions

eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Wed, 18 May 2016 17:37:01 GMT

Robert,

An awesome awesome widget!!!

I am looking for some guidance as to how or where I modify code to be able to display multiple field sum's in the results tab.

I would like to know where/what function to look at to make these changes. I have about 15 fields to sum and display in results.

Thanks!

Rupali

Re: eSearch widget, sum multiple fields or create reports from results

RobertScheitlin__GISP — Sun, 12 Dec 2021 09:23:34 GMT

Rupali,

Well I am not sure how you are going to format the text to display the results for 15 field sums.

If you look in the Widget.js at line 2275 (in 2.0.1.3 version) you will find this block of code:

        if(sumfield){
          sumTotal = 0;
          for ( i = 0, slen = this.currentFeatures.length; i < slen; i++) {
            var feature = this.currentFeatures;
            sumTotal += Number(feature.attributes[sumfield]);
          }

          numFormat = this._getNumberFormat(sumfield, layerIndex);
          if (numFormat) {
            args = numFormat.split("|");
            /*value,percision,symbol,thousands,decimal*/
            sValue = this._formatNumber(sumTotal, args[0] || null, args[1] || null, args[2] || null);
          }
          currFormat = this._getCurrencyFormat(sumfield, layerIndex);
          if (currFormat) {
            args2 = currFormat.split("|");
            /*value,percision,symbol,thousands,decimal*/
            sValue = this._formatCurrency(sumTotal, args2[1] || null, args2[0] || null, args2[2] || null, args2[3] || null);
          }
          console.info(layerConfig.sumlabel + ': ' + sValue || sumTotal);
          this.divSum.innerHTML = layerConfig.sumlabel + ' ' + sValue;
        }

This the block you would have to modify to add more sum fields

You will probably have to make some css adjustment to fit 15 fields as well to the Widget.html label element that the string is added to:

style.css

.widget-esearch .esearch-sum {
  position: absolute;
  width: 100%;
  height: auto;
  left: 0;
  right: 0;
  bottom: 0;
  overflow-x: hidden;
  overflow-y: hidden;
}

Re: eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Wed, 18 May 2016 17:52:31 GMT

Thank you very much!!

This info is very helpful! I will try and make those edits and let you know how it goes…

-Rupali

Re: eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Thu, 19 May 2016 14:23:45 GMT

Robert,

Sorry, I will need help with this. Its a complex script and I am not able to figure out where exactly I change the code to allow for multiple sum fields. Currently only one field can be summed.

I would appreciate some extra help from you, have a time sensitive project.

Thanks,

Rupali

Re: eSearch widget, sum multiple fields or create reports from results

RobertScheitlin__GISP — Thu, 19 May 2016 21:14:41 GMT

Rupali,

Exactly how would you expect this to look like for 15 fields?

Re: eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Thu, 19 May 2016 21:52:35 GMT

Robert,

I agree 15 fields total would ‘not’ look good in that results panel. But, Is it possible to sum the fields and display them in a new panel, for e.g. add a new tab to the widget showing just the totals of the fields selected to sum.

Please suggest any ideas you might have…

Is that doable?

Thanks,

Rupali

Re: eSearch widget, sum multiple fields or create reports from results

RobertScheitlin__GISP — Thu, 19 May 2016 23:54:31 GMT

Rupali,

Yes that is doable but this is not going to happen probably before your deadline. This will take time for me to workout the UI changes and code to it will be added to a possible enhancement list for future releases. I don't have the time to spend on this right now.

Re: eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Fri, 20 May 2016 13:43:37 GMT

Robert,

Sure no problem. I will look forward to future release of the widget. Meanwhile, I will try use your previous instructions.

Thank you very much for your time and help!

-Rupali

Re: eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Fri, 20 May 2016 17:51:20 GMT

Hi Robert,

sorry for bugging you again. Could you point me to right direction as to how do I allow for multiple sum fields?

I am thinking of storing all sum field values into an array and then looping through each value using the function below to output totals in the div...

Is that a right approach?

if(sumfield){

sumTotal = 0;

for ( i = 0, slen = this.currentFeatures.length; i < slen; i++) {

var feature = this.currentFeatures;

sumTotal += Number(feature.attributes[sumfield]);

//alert(feature.attributes[sumfield]);

}

numFormat = this._getNumberFormat(sumfield, layerIndex);

if (numFormat) {

args = numFormat.split("|");

/*value,percision,symbol,thousands,decimal*/

sValue = this._formatNumber(sumTotal, args[0] || null, args[1] || null, args[2] || null);

}

currFormat = this._getCurrencyFormat(sumfield, layerIndex);

if (currFormat) {

args2 = currFormat.split("|");

/*value,percision,symbol,thousands,decimal*/

sValue = this._formatCurrency(sumTotal, args2[1] || null, args2[0] || null, args2[2] || null, args2[3] || null);

}

console.info(layerConfig.sumlabel + ': ' + sValue || sumTotal);

this.divSum.innerHTML = layerConfig.sumlabel + ' ' + sValue;

}

Re: eSearch widget, sum multiple fields or create reports from results

RobertScheitlin__GISP — Fri, 20 May 2016 17:58:00 GMT

Rupali,

That sounds like a good plan you would just have to remove the

this.divSum.innerHTML = layerConfig.sumlabel + ' ' + sValue; and store the sum for that particular field in a var and then update the divSum.innerHTML once you have finished looping through all the sum fields.

Re: eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Mon, 23 May 2016 17:57:43 GMT

Hi Robert,

How do I get "layerConfig.sumfield " to return multiple sum field's? I tired a few ways, but not successfull.

-Rupali

Re: eSearch widget, sum multiple fields or create reports from results

RobertScheitlin__GISP — Mon, 23 May 2016 18:17:51 GMT

Rupali,

Go get the 2.0.1.4 version of eSearch. It now has multiple summary field capability.

Re: eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Mon, 23 May 2016 18:25:15 GMT

Oh wow!! I cannot be thankful enough to you!! Spent the whole Friday and Saturday figuring out how I could do that and I am sure it would take me another few days!

THANK YOU VERY MUCH for including the functionality!!

-Rupali

Re: eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Wed, 25 May 2016 16:28:43 GMT

Hello Robert,

I am having some problems seeing the widget when I go to add it to the app. I re-installed WAB 2.0 multiple times and copied the latest widget to both stemapp and my apps widget folder. I could see the older version of the widget.

-Rupali

Re: eSearch widget, sum multiple fields or create reports from results

RobertScheitlin__GISP — Wed, 25 May 2016 16:45:51 GMT

Rupali,

Well I am not sure what to tell you. Based on what you are saying the eSearch widget should be there. Are you sure you are extracting the whole eSearch folder from the zip?

Re: eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Wed, 25 May 2016 16:52:43 GMT

Sorry my bad..got it sorted. The way it was getting extracted was eSearch/eSearch/…

I see all the new capabilities! Thank you so much!

-Rupali

Re: eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Wed, 25 May 2016 17:34:07 GMT

Something minor I noticed…the results list appears overlapped.

Re: eSearch widget, sum multiple fields or create reports from results

RobertScheitlin__GISP — Wed, 25 May 2016 17:57:33 GMT

Rupali,

Can you share a screenshot of what you are talking about?

Re: eSearch widget, sum multiple fields or create reports from results

RupaliKiran — Wed, 25 May 2016 18:01:43 GMT

I am attaching a screenshot..let me know if don’t get it.

-Rupali

Re: eSearch widget, sum multiple fields or create reports from results

RobertScheitlin__GISP — Wed, 25 May 2016 18:16:48 GMT

Rupali,

This will always happen when you have not specified and fields for the title field and no fields for the results.