How can i do the following:
I want to create a restaurant menu.
It contains 3 types of food(fish, meat, italian) and each type of food has several (15 to 20) dishes.
I want to use the database.
I think it has t do with “pointer type” but i dont understand the tutorials concerning the “pointer type”.
Can you give me an exapmle?
Hi Bert,
What tutorial you are referring to?
Example:
We have User with id === "51dba907e4b0cb6cf9c0ba24",
We have collection with column "owner" with type Pointer to Users (pointer)
So if we want retrieve all items with owner "51dba907e4b0cb6cf9c0ba24" we must use this query:
precode
{
"owner": {
"$inQuery" : {
"id": "51dba907e4b0cb6cf9c0ba24"
}
}
}
/code/pre
$inQuery is well described here.
Should also be useful following topics:
:: https://getsatisfaction.com/apperyio/...
:: https://getsatisfaction.com/apperyio/...
I am getting close.
How can i point to more than one id in another database collection?
Hello! In other words you want to have a field in one collection which refers to objects array in other collections? For this purpose it's better to create for each object separate field with pointer type.
This is the situation:
the menu contains 3 types of food(fish, meat, italian) and each type of food has several (15 to 20) dishes.
so i created a database collection for the 3 types of food and a collection with all the dishes for the 3 types of food.
In the database collection with the types of food i created a pointer to the dishes database collection.
I can connect 1 ID but of course i have to point to more than one dish.
What is the best approach?
What is the difference between type of food (fish, meat, italian)? If they have the same fields it's better to use for them the same collection where will be specified type of food, if the have different - then it's better to store type value in collection with pointer to food.
i created two database collections:
The first has a pointer field to the second with values 1 and 2 which correspond to the id field (made it an index column) in the second.
First i list the "section" column on my first page: (through list service)
How can i do the following tasks:
when i click on "kazen" it has to go to a detail page and list all the items with id "2" of the second database collection, "kanas". And when i click on "nagerechten" it has to go to a detail page and list all the items with id "1" of the second database collection, "foie gras" and "ganzenlever".
Hello,
Below tutorial will help you.
http://docs.appery.io/tutorials/build...