Question Re: SearchField limits? in Technology Q&A

SearchField limits?

bjorn-henrik_zink — Wed, 27 Apr 2016 10:23:58 GMT

Hi,

I am using the SearchField to swiftly filter values in a large list. The list initially had 1023 entries and it worked fine. Now, the list has grown to 9963 entries and it has stopped working. Are there any SearchField limits? If yes, what are they?

Thanks!

Re: SearchField limits?

bjorn-henrik_zink — Sat, 30 Apr 2016 05:27:36 GMT

The error message I get is: Only "String" values are supported for the FilterOperator: "Contains". It leads me to think that it might be related to the data and not the volume.

How can I force the binding to be of type string of my model data for a specific column?

Here is my present code:


// filter list binding
var list = this.getView().byId("myList");
var binding = list.getBinding("items");
binding.filter(myFilters, "Application");

Thanks!

Re: SearchField limits?

saivellanki — Sat, 30 Apr 2016 05:52:42 GMT

Hi Bjorn,

Use a formatter, consider you have text as template (Just for an example, even though text is of string type):


new sap.m.Text({text:"{
                                   path:'Weight',
                                   formatter: function(v){
                                   return String(v);
                                   }
                              }"
                         });

Regards,

Sai Vellanki.

Re: SearchField limits?

bjorn-henrik_zink — Sat, 30 Apr 2016 07:09:19 GMT

Hi Sai,

thanks, we both had the same thought and I have now tested using a formatter. In fact, I replaced all the strings with "Test" and it results in the same error, i.e. it has nothing to do with the actual values and must be something with the size of the list. I will dig a bit further and keep the thread posted.

Re: SearchField limits?

SergioG_TX — Sat, 30 Apr 2016 12:18:31 GMT

Bjorn,

can you post your code on how you created the filters as well? I am suspecting the issue being with the filter itself and maybe not necessarily with the binding

Re: SearchField limits?

bjorn-henrik_zink — Sun, 01 May 2016 05:43:48 GMT

Hi Sergio,

thanks for your reply, here is the filter code, hope you find something fishy or can help me force the column to be of type string:


var aFilters = [];
var sQuery = oEvt.getSource().getValue();


if (sQuery && sQuery.length > 0) {
       var filter = new Filter("someColumnName", sap.ui.model.FilterOperator.Contains, sQuery);
       aFilters.push(filter);
}

// Update list binding with filter
var list = this.getView().byId("searchList");
var binding = list.getBinding("items");
binding.filter(aFilters, "Application");

Re: SearchField limits?

SergioG_TX — Mon, 02 May 2016 15:19:29 GMT

line 10...

binding.filter(aFilters); // try using this line instead of what you have

Re: SearchField limits?

bjorn-henrik_zink — Mon, 02 May 2016 16:19:34 GMT

I tried the code change, but no difference, the error persists 😞

Re: SearchField limits?

SergioG_TX — Mon, 02 May 2016 18:39:01 GMT

in the chrome dev tools.. what is the value of sQuery ?

if not a string.. do.. sQuery.toString()... try this and see what happens next?

Re: SearchField limits?

bjorn-henrik_zink — Tue, 03 May 2016 05:18:19 GMT

Hi Sergio,

I've got liveChange on the search field and the entry is a string. Here's an example:

Re: SearchField limits?

bjorn-henrik_zink — Tue, 03 May 2016 05:41:08 GMT

Update - I have now found the problem. It has nothing to do with the number of entries. The problem occurs when the column data from the model contains numbers only, for example 3026.

Question, how can I force the binding to be of type String for my column?

Re: SearchField limits?

fredericorocha — Tue, 03 May 2016 07:02:28 GMT

You can achieve that by using a formatter where you convert int to string.

Regards,

Frederico

Re: SearchField limits?

bjorn-henrik_zink — Tue, 03 May 2016 07:19:06 GMT

Hi Frederico,

thanks for your reply. As you can read above I have used a Formatter in the view (when setting the value of the control). It did not work, but I will try again. Perhaps, I should do it ealier in the code, e.g. in the controller. Where in the code would you add the Formatter call?

Re: SearchField limits?

fredericorocha — Tue, 03 May 2016 07:28:29 GMT

Hi Bjorn,

It should be in the view. Sorry first time I didn't see you were already using. However I think you should do it like this:

new sap.m.Text({text:"{
path:'Weight',
formatter: function(v){
return v.toString();
}
}"
});

Regards,

Frederico

Re: SearchField limits?

bjorn-henrik_zink — Tue, 03 May 2016 09:15:17 GMT

Hi Frederico,

as I mentioned above, it does not seem to work for me. I use XML:


<StandardListItem
  title="{path: 'someTitle', type : 'sap.ui.model.odata.type.String'}"
  description="{path: 'someDesc'}"
  type="Navigation"
  press="onSearchListItemPressed"
  iconDensityAware="false"
  iconInset="false"/>

Other option I have tried is using a custom formatter:


<StandardListItem
  title="{path: 'someTitle', type : 'formatter: 'zink.utils.StringFormatter.stringFormat''}"
  description="{path: 'someDesc'}"
  type="Navigation"
  press="onSearchListItemPressed"
  iconDensityAware="false"
  iconInset="false"/>

The code of my custom formatter, StringFormatter.js looks like this:


sap.ui.define([
        'sap/ui/model/type/String'
], function (String) {
  "use strict";

  var StringFormatter = {
  stringFormat : function (v) {
  return v.toString();
  }
  };

  return StringFormatter;
}, /* bExport= */ true);

Anyway, it seems that the type change is done too late and therefore it has not impact on the filter. I would like to force the data type when binding the model, but I am not sure how to do that ...

Re: SearchField limits?

SergioG_TX — Tue, 03 May 2016 11:17:58 GMT

Bjorn,

is the column data type varchar ?

did you try changing the sQuery to sQuery.toString() ? even on your liveChange event, what if you type a number.. does it stay as a string?

Re: SearchField limits?

bjorn-henrik_zink — Tue, 03 May 2016 11:50:27 GMT

Hi Sergio,

yes, the column data type is varchar.

sQuery is also a string when entering numbers in the search field, i.e. the problem resides in the list data.

Re: SearchField limits?

fredericorocha — Tue, 03 May 2016 12:25:42 GMT

Is it getting inside of your custom formatter? Please make a breakpoint and make sure that is getting inside of the stringFormat function.

Regards,

Frederico

Re: SearchField limits?

bjorn-henrik_zink — Tue, 03 May 2016 18:12:30 GMT

Yes, the function is reached. As mentioned earlier in this thread, I have even changed all the vakues to "test", but that did not change the issue from occuring, which is why I want to change the data before binding of the values and then adding to the filter.

A far thought, could two-way binding perhaps help ...?

Re: SearchField limits?

bjorn-henrik_zink — Wed, 04 May 2016 07:29:02 GMT

Two-way binding seems to be the default so that can not be the solution either.