[ 
https://issues.apache.org/jira/browse/USERGRID-1338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15891000#comment-15891000
 ] 

Abhinav Sinha commented on USERGRID-1338:
-----------------------------------------

if you URL encode the + char in the 'Query' field of the new Edge UI, it 
retrieves the correct entity.

{code}
where email='asinha%[email protected]'
{code}

with response

{code}
"params" : {
    "limit" : [ "25" ],
    "ql" : [ "where email='asinha%[email protected]' " ]
  },
{code}

> Email addresses or usernames with + character do not appear in search results 
> for users
> ---------------------------------------------------------------------------------------
>
>                 Key: USERGRID-1338
>                 URL: https://issues.apache.org/jira/browse/USERGRID-1338
>             Project: Usergrid
>          Issue Type: Bug
>          Components: Portal, Stack
>    Affects Versions: 2.2.0
>            Reporter: Brandon Shelley
>
> Both the new Edge UI, and API calls to email addresses or usernames with + in 
> the string return no results. It appears the character is being stripped out 
> and replaced with a space.
> Tests, where both username and email address are set to 
> '[email protected]':
> GET https://apibaas-trial.apigee.net/org/app/users/?ql=select * where 
> username='[email protected]'
> GET https://apibaas-trial.apigee.net/org/app/users/?ql=select * where 
> email='[email protected]'
> {code}
> {
>   "action": "get",
>   "params": {
>     "ql": [
>       "select * where email='brandon [email protected]'"
>     ]
>   },
>   "path": "/users",
>   "uri": "https://apibaas-trial.apigee.net/org/app/users";,
>   "entities": [],
>   "timestamp": 1488398745552,
>   "duration": 40,
>   "organization": "org",
>   "applicationName": "global",
>   "count": 0
> }
> {code}
> I tried working around this by url-encoding the + character to %2b, but while 
> the response shows the character correctly, there are still no results found:
> {code}
> "params": {
>     "ql": [
>       "select * where email = '[email protected]'"
>     ]
>   },
> {code}
> The only workaround so far is to use the / notation to access users:
> [baasurl]/users/[email protected]



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to