Is a part of deleting Parent and Child relation

I have 4 level of Parent & Child relation table,
Which

  • Table1(Parent) Table2(Child)
  • Table2(Parent) Table3(Child)
  • Table3(Parent) Table4(Child)
  • Table4(Parent) Table5(Child)

all of those tables I’ve ref. and set "Is a part of " on, here is the problem, when I delete the parent table of table1 only table1 of that Table1ID, and every table2 relate got deleted
but left Table3, Table4, Table5, data that technically still part of Table1. And without the Table1ID existing, those data have no uses
Is there a place I didn’t set up right?

Sounds like a bug to me. You should send it to support@appsheet.com.

1 Like

@Bellave_Jayaram Thank you, I have email the support
@Aleksi Thank you for quick respond on the email, got you

I tried the following test.

  1. I created a four level hierarchy containing Table1, Table2, Table3, and Table4.
  2. Each child table contains a Ref to its parent and specifies “Is Part Of”.
  3. I populated the Google worksheets with test data.
  4. I deleted a record in Table1.
  5. All child records in Table2, Table3, and Table4 were deleted.

My basic test seemed to work correctly.
I presume there must be some difference in how your app is configured.
Hopefully, your bug report will shed light on that.

1 Like

@Phil Thank you quick helping,
I have check the table setup again, and yes, I’ve make sure that all of the child table contains the Ref to “Is a Part Of” on.
And I put in some testing data through 4 level again, but this time only the Table 1 and Table 4’s data got deleted. seem odd.
Please help me check my APP, OxRMeeting-52085 Thank you very much

I wonder if the problem is Security Filter related?
Can you try eliminating the security filters and see if it works correctly?

If that does not work, I am going to need to try it in the debugger.
That would require that you:

  1. Populate the tables with test data.
  2. Tell me the exact steps to reproduce the problem.

Often it takes several iterations in the debugger, so I may need to ask you to repeat this a few times.

Your application is significantly more complex than my simple test.

  1. It has security filters
  2. It has Refs to several other tables that are not “IsPartOf”.

It is not obvious to me why your app fails while my simple test does not.

I think your table hierarchy is:
Meeting
Detail
Agandaoption
Optionvote

Can you confirm that?
You mentioned five levels of tables, so I may be missing something.

@Phil Yes, Phil Yes, That is the table hierarchy, after my post, I have remove the fifth table, sorry for the confusion.
For the security filters just using a simple IN() statement to filter out the unnecessary data that is not relate to that group(level) of user, try to keep the data minimized

And for question 2? I thought in one table we can only set 1 Ref as “Is a Part Of” to the Parent table? So on any table that has more than 1 Ref, i’ve make sure that “Is a Part Of” is OFF

OK let me remove all of the security filters to see if it work


Unfortunately, after I remove all tables security filters and still didn’t work, only the Meeting(Lv1) and Optionvote(Lv4) 's data got deleted from the google sheets
Yesterday, when I notice this problem, when I deleted data, only Meeting(Lv1) and Details(Lv2)'s data were deleted
All of the deleting action is from the top of the root, which is the Meeting(Lv1)

Thanks for conducting the experiment regarding the security filters.

Your are correct about only setting 1 Ref to “Is a Part Of” per table. I was just trying to list the things that were different between my simple test case and you app. Your app seems fine.

I need to try diagnosing the problem in the debugger.
That would require that you:

  1. Populate the tables with test data.
  2. Tell me the exact steps to reproduce the problem.

Often it takes several iterations in the debugger, so I may need to ask you to repeat this a few times.
Are you willing to do this?

If you wish, you can create a copy of your app and we can test with the copy.

It is getting late in the day here in Seattle. I may not be able to investigate further until Monday morning Seattle time.

@Phil Thank you! Sure I can make a copy of the APP

This copy for testing APP name OxRMeetingForTesting-52085

Thank you @Phil greatly appropriated