wrong related record after sorting list
Posted: Wed Apr 14, 2010 9:16 amHello,
My apologies if this is something that has come up previously.
We just noticed some odd behavior in our implementation. When we go to a table, filter this, and then sort the list *twice* (2 clicks on the heading), upon going into the record and then to a related table via the tabs in the record view, we end up at the wrong related record.
So, for instance, when it works correctly, we should get the following url after 2 clicks:
However, what we get is:
So the cursor in this latter case is incorrect and we don't understand why this is happening. Cursor 7 in this case actually points at record in House_survey sid=183632.
We did find a solution: restart apache.
Steve
My apologies if this is something that has come up previously.
We just noticed some odd behavior in our implementation. When we go to a table, filter this, and then sort the list *twice* (2 clicks on the heading), upon going into the record and then to a related table via the tabs in the record view, we end up at the wrong related record.
So, for instance, when it works correctly, we should get the following url after 2 clicks:
- Code: Select all
https://dengue.ucdavis.edu/db/PD/index.php?-table=House_survey&-action=related_records_list&-cursor=6&-skip=0&-limit=30&-mode=list&Proyecto=%3DMBMI&survey_date=%3D2010-02-09&-sort=location_code+desc&-recordid=House_survey%3Fsid%3D183622&-relationship=coleccion
However, what we get is:
- Code: Select all
Index.php?-table=House_survey&-action=related_records_list&-cursor=7&-skip=0&-limit=30&-mode=list&Proyecto=%3DMBMI&survey_date=%3D2010-02-09&-sort=location_code+desc&-recordid=House_survey%3Fsid%3D183622&-relationship=coleccion
So the cursor in this latter case is incorrect and we don't understand why this is happening. Cursor 7 in this case actually points at record in House_survey sid=183632.
We did find a solution: restart apache.
Steve