I have two repeating groups where one RG is the source for a set of data that the second one will display. I use a button that saves the data from the first RG to a new table that the second RG uses as it’s data source.
Once the data from the first RG is saved, a workflow event that detects the completion is started which then uses the “Make changes to a list…” action to add additional data to each of those records. It’s this additional data that is used in the criteria for the second RG.
Normally, if you add, delete or update records, the RG will update automatically but it does not do that in this instance…at least not when using the “Normal” debug run mode. It works when using Slow or Step-by-step. I know the criteria for the RG (Search for… criteria) is correct because if I refresh the page the data is displayed but in live action, the data only partially displays.
I’ve tried including a “Clear list” and a “Display list” action after updating the records in an attempt to try and force the RG to refresh but this also does not work.
Any suggestions how I can get an RG to display everything after the database has been updated?
I have to admit, I can’t remember exactly where in my app I was doing that but I can tell you that the suggestion to reset data was also tried and did not work for me at the time. I would have tried this also with a dozen other things in an attempt to make it work. If there was an element action that could remotely impact what I was doing, I would have tried it.
Now, to be fair to @ChefThomas, “reset data” may work in your situation, but it would not (or did not) work in my situation.
My app is big, and I have a lot of moving parts, so when I run into a problem and post a question like I did here, I move on until I get some support but I didn’t get what I needed at the time. However, I will eventually come back around to where this was at some point and I’ll let you know then how, or if, I fixed it.
