We have a new requirement for our project. We need to create a folder/file structure.
Now we are doing brainstorming to support this change.
As you can see, john is a member of both a tower and a group.
a genome contains the root virtual folder and which consists of more folders and files
user can be a member of multiple groups and we maintain a relationship (CAN_ACCESS_DIR) between group1 and a folder (DCL) or file.
case 1 :
if there is no relationship (CAN_ACCESS_DIR) between group1 and DCL folder then we need to skip it and show the next folder (only) which has a relationship (CAN_ACCESS_DIR) with group example in this case
root, mongo.pdf, java
(First level relation match only)
if group1 has a relationship (CAN_ACCESS_DIR) with DCL folder then we don't need to skip. we only need to return root, mongo.pdf and DCL folder (First level relation match only)