About NoSQL query

Question

 

Hi,

About NoSQL, I have some question.

There is a field "Owner" in NoSQL,

if I login with userName, the content of this field is userName, 

if I login with emailId,  the content of this field is emailId,

if I open the function emailId login, and I login with userName, the content of this field is emailId.

 

1. Could field "Owner" to unify userName ?

※ All of Owner are the same => userName

Don't some are userName and some are emailId

 

Could NoSQL do this ?

 

2. Could we find custom field data with query in NoSQL ?

like MySQL query below :

 

SELECT Owner

FROM TableName

WHERE condition

 

3. If there are two table in NoSQL, could we query like MySQL below

 

SELECT ProductName

FROM TableA, TableB

WHERE TableA.Price > 50 AND TableB.Price <100

 

※ TableA and TableB are different table

 

Thank you !

Answer 1

1. Could field "Owner" to unify userName ?

If you are not using ACL app, you have to just set App42API.setLoggedINUser(<USERNAME>) after login to have USERNAME as owner in all docs where USERNAME is username of your app user. If you want to have emailId as ownername, you have to do App42API.setLoggedINUser(<EMAIL>) where EMAIL is emailId of your app user.

 

2. Could we find custom field data with query in NoSQL ?

Yes you can very well do this, See tutorial here.

 

3. If there are two table in NoSQL, could we query like MySQL below

Query on two collections in single query is not supported yet. You have to first fetch target records from collection 1 and find those records in collection 2 using reference keys.

 

 

Comments

Hi,
Thanks for your help !

For question 1.
Could give me Android code, iOS code and PHP code ?

Thank you !

---

Could give me some help !

---

For iOS

[App42API setLoggedInUser:@"User Name"];

For Android

App42API.setLoggedInUser("USER_NAME");   

For PHP
App42API::setLoggedInUser($userName);

---

Thank you very much !