Congrats to Wappler 1.7.2 and Server Side API! Lets say I have two tables:
@Hyperbytes Maybe you as DB freak know that or @Teodor
Short Example:
What is what:
t_ = table
f_ = foreinkey
DB Structure Example:
t_article (artid, artname)
t_cat_art_depencies (catartid,f_artid, fcatid)
t_category
Now i have articles like: banana which is category fruit and vegan, then i have an article “T Bone Steak” which is category meat.
SO now how to list the categories within a table query which should give a result like:
| ID | Article | Category | ||
|---|---|---|---|---|
| 1 | Banana | Fruit, Vegan | ||
| 2 | Steak | Meat | ||
| 3 | Cellerie | Vegetables, Vegan |
Bonus Question:
As I guess the output would be like:
Var, Var, Var,
and how to strip the last comma then? 
Community Page
Last updated:
Last updated: