I'm trying to run a query against portal to return all the registered users, but can't figure out how to get a wildcard variable to work. This works: let queryParameters = { query : "username:" + portal . user . username } ; portal . queryUsers ( queryParameters ) . then ( function ( result ) { console . log ( result ) ; } ) But I need to do something like this, which doesn't work: let queryParameters = { query : "username:*" } ; portal . queryUsers ( queryParameters ) . then ( function ( result ) { console . log ( result ) ; } ) Any ideas are much appreciated.

Andrew, Do a query for your orgid like this: orgid : HdNMW2j6UI55aLXm and do not have username in the query

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query Portal for All Users

AndrewLindley

I'm trying to run a query against portal to return all the registered users, but can't figure out how to get a wildcard variable to work.

This works:

<SPAN class="keyword token">let</SPAN> queryParameters <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp; query<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"username:"</SPAN> <SPAN class="operator token">+</SPAN> portal<SPAN class="punctuation token">.</SPAN>user<SPAN class="punctuation token">.</SPAN>username
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>
portal<SPAN class="punctuation token">.</SPAN><SPAN class="token function">queryUsers</SPAN><SPAN class="punctuation token">(</SPAN>queryParameters<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="token function">then</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">function</SPAN><SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
&nbsp; console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

But I need to do something like this, which doesn't work:

<SPAN class="keyword token">let</SPAN> queryParameters <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN>
&nbsp; query<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"username:*"</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>
portal<SPAN class="punctuation token">.</SPAN><SPAN class="token function">queryUsers</SPAN><SPAN class="punctuation token">(</SPAN>queryParameters<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="token function">then</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">function</SPAN><SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">{</SPAN>
&nbsp; console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">log</SPAN><SPAN class="punctuation token">(</SPAN>result<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Any ideas are much appreciated.

Vind meer berichten getagd met

Accepted answers

rscheitlin

Andrew,

Do a query for your orgid like this:

orgid<SPAN class="punctuation token">:</SPAN>HdNMW2j6UI55aLXm<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

and do not have username in the query

All comments

AndresCastillo

Hi Andrew,

Can you share more of your JS script, like what you had to require for this to work?

AndrewLindley

This did the trick, thanks!

rscheitlin

Andrew,

Do a query for your orgid like this:

orgid<SPAN class="punctuation token">:</SPAN>HdNMW2j6UI55aLXm<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

and do not have username in the query

AndrewLindley

Update:

Ok, some cooky stuff going on here.

For the sake of meeting deadlines I tried implementing this workaround:

let queryParameters = {
&nbsp; query: "username:a* OR username:b* OR username:c* OR username:d* OR username:e* OR username:f* OR username:g* OR username:h* OR username:i* OR username:j* OR username:k* OR username:l* OR username:m* OR username:n* OR username:o* OR username:p* OR username:q* OR username:r* OR username:s* OR username:t* OR username:u* OR username:v* OR username:w* OR username:x* OR username:y* OR username:z* OR NOT username:esri*",
&nbsp; num: 1000
};<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

.. querying for every letter followed by the wildcard variable '*' returns all of the users who's username starts with a lowercase letter. Pretty tedious, but progress.

The problem is it doesn't return usernames that begin with an uppercase letter. OK, I thought, I'll just brute force it and add all uppercase letters followed by the wildcard variable to the query too.. but that doesn't work!

Changing all of the letters to uppercase in the above snippet still only returns lowercase usernames. The only way to return a username that begins with an uppercase letter is to query for the exact username, which obviously doesn't work for loading all users dynamically.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.