on 01-23-2022 11:37 AM
What would be the best way to handle JSON object into HANA Schema,
and fetching it by query using CAP Nodejs
Example:
I have items entity, for each item i have owners that i store as a json Object.
{ [owner1,owner2,owner3]}
Owners can be linked to multiple items, and items could be linked to multiple owners
So I Need to do a query to fetch all items under a specific owner,
items Entity:
items:{
key ID : UUID;
subItems: Integer;
description: String;
owners: String;
}
User | Count |
---|---|
76 | |
10 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.