How to use "Pointer" column in database in server code?

[Dongzhi Yang7528784]

Hi Team,

Could you let me know how to make query, update or create with "Pointer" columns in the database?

e.g.

I have a collection called Invoice in which there is a column named 'customer', which is a pointer to the Users collection.

How should I write the 'criteria' for database activities:?

1. query all invoices that belong to a certain user?

2. create an invoice for a user

3. modify the user of an invoice

4. delete all invoice for a user

   I have checked the manual of MongDB, and i can't seem to find anything about 'Pointer', is it something Appery.io invented?

   In my case what would be the key benefit of using Pointer compared to just using a 'String' field that stores the userId?

   Thanks

   Dongzhi

[Serhii Kulibaba]

Hello Dongzhi,

Please look this documentation:
https://devcenter.appery.io/documenta...