topic Re: Qlik sense api search in a field's values with wildcards like '*' or '?' ? in Integration, Extension & APIs

Qlik sense api search in a field's values with wildcards like '*' or '?' ?

pablinho — Mon, 04 Sep 2017 15:31:08 GMT

Hi,

is there a way with the api to do a search with wildcards like '*' or '?' in a field's values with Qlik Sense version June 2017?

Because i'm using searchResults method and it works but only for specific values. for example for a field city that has values :

- London

- Bruxelles

- Berlin

if i search the string 'b' the result give me ["Bruxelles","Berlin"] but if i want to search *erlin it doesn't return [Berlin], the same for the character '?'. What am i missing? is there another method that i have to use in the API's?

Thanks

Re: Qlik sense api search in a field's values with wildcards like '*' or '?' ?

ErikWetterberg — Tue, 05 Sep 2017 12:06:59 GMT

Have you tried selectMatch method ‒ Qlik Sense ??

Hope this helps

Erik Wetterberg

Re: Qlik sense api search in a field's values with wildcards like '*' or '?' ?

pablinho — Tue, 05 Sep 2017 14:06:23 GMT

thanks but i want only to retrieve the values and not to select them. My goal is to create a listbox with search for my mashup that show only the values that respects the string written in the search but with the wildcards '*' and '?'

Re: Qlik sense api search in a field's values with wildcards like '*' or '?' ?

ErikWetterberg — Wed, 06 Sep 2017 12:11:14 GMT

Hi,

You could use this call SearchListObjectFor method ‒ Qlik Sense

Another option would be to use the visualization API and dynamically create a listbox Visualization API ‒ Qlik Sense

Erik Wetterberg

Re: Qlik sense api search in a field's values with wildcards like '*' or '?' ?

pablinho — Wed, 06 Sep 2017 12:21:34 GMT

thank you very much!!