I have a problem that is difficult to describe but I really need help with so please bear with me
I have two lists : LIST1 and LIST2, LIST1 is the parent of LIST2 and LIST2 has been set to pre loaded data. LIST2 is linked to LIST1 via an argument populated by LIST1 and used as a filter on LIST2. In the real world LIST is a list of Surveyors and LIST2 is their Surveys. I only show Surveys that have a "status" of "Assigned". LIST1's data comes from SQL View that has a filter which says status = 'Assigned' and LIST2 has a filter which says surveyorID = :what_surveyor AND Status = 'Assigned'. During the workings of LIST2 the status changes to 'Completed' which obviously makes the survey disappear and if its the last survey for a given surveyor they disappear too. There is no mechanism to add surveys or surveyors within the app. Phew!
So : MOST of this time this works perfectly! However occasionally (with no pattern that I can discern) after a RefreshList a 'Completed' survey appears in the app with the red and blue tag (indicating it is dirty, newly added and has a problem) but linked to a Surveyor which it is not linked to! The data as far is SQL is concerned is correct. This should be impossible and I can't see any circumstance under which it could occur. It cannot be there as its value in Status should filter it out and the data structure in the app is wrong as the surveyor shown is not what's in the SQL data
Anyone ever seen anything like this?
Any clue as to how to go about tracking it down and / or what to do about it?
Thanks in advance to anyone that can be bothered to read this!
I have two lists : LIST1 and LIST2, LIST1 is the parent of LIST2 and LIST2 has been set to pre loaded data. LIST2 is linked to LIST1 via an argument populated by LIST1 and used as a filter on LIST2. In the real world LIST is a list of Surveyors and LIST2 is their Surveys. I only show Surveys that have a "status" of "Assigned". LIST1's data comes from SQL View that has a filter which says status = 'Assigned' and LIST2 has a filter which says surveyorID = :what_surveyor AND Status = 'Assigned'. During the workings of LIST2 the status changes to 'Completed' which obviously makes the survey disappear and if its the last survey for a given surveyor they disappear too. There is no mechanism to add surveys or surveyors within the app. Phew!
So : MOST of this time this works perfectly! However occasionally (with no pattern that I can discern) after a RefreshList a 'Completed' survey appears in the app with the red and blue tag (indicating it is dirty, newly added and has a problem) but linked to a Surveyor which it is not linked to! The data as far is SQL is concerned is correct. This should be impossible and I can't see any circumstance under which it could occur. It cannot be there as its value in Status should filter it out and the data structure in the app is wrong as the surveyor shown is not what's in the SQL data
Anyone ever seen anything like this?
Any clue as to how to go about tracking it down and / or what to do about it?
Thanks in advance to anyone that can be bothered to read this!
Comment