I have 4 level of Parent & Child relation table,
Which
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.
@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.
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.
@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:
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.
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:
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.
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |