![\"\"](\"https:\/\/xlinesoft.com\/blog\/wp-content\/uploads\/2020\/02\/scr.png\")
<\/a>\n<\/p>\n
Things to change in the code: Saving new record ID in the session variable. Execute previously saved SQL query, loop through the recordset finding our new record. Redirect to the corresponding page.<\/p>\n PHP code:<\/strong><\/p>\n C# code:<\/strong><\/p>\n Saving the current SQL query and page size in session variables<\/p>\n PHP code:<\/strong><\/p>\n C# code:<\/strong><\/p>\n Changing the background color of the new record. <\/p>\n PHP code:<\/strong><\/p>\n C# code:<\/strong><\/p>\n Bullets 4 and 5 are only required if you display a lot of records on the list page and need to scroll the page so the new record is visible. This code most likely is not required if you only display twenty records per page. <\/p>\n PHP code:<\/strong><\/p>\n C# code:<\/strong><\/p>\n Enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":" When we added a new record and returned back to the List page that new record may not be clearly visible on the page. Depending on what page we on, what sort or is applied, how many records are on the page – we may simply be on the wrong page. This can be useful when, for instance, you are transferring a large amount of data from paper to the database and this kind of visual indication can be helpful to keep track of the…<\/span>Continue Reading “Making new record visible on the List page”<\/span>
\n– products<\/strong> – the name of the table, we need it for the redirect
\n– ProductID<\/strong> – the name of the key column<\/p>\n1. Add page: AfterAdd event:<\/h4>\n
\r\n$_SESSION[\"ProductID\"]=$keys[\"ProductID\"];\r\n\r\n$i=0;\r\n$rs = DB::Query($_SESSION[\"ProductsSQL\"]);\r\n \r\nwhile( $data = $rs->fetchAssoc() )\r\n{\r\n$i++;\r\nif ($data[\"ProductID\"]==$keys[\"ProductID\"])\r\n\tbreak;\r\n}\r\n\r\n$page = floor($i \/ $_SESSION[\"pageSize\"] )+1;\r\n\r\nheader(\"Location: products_list.php?goto=\".$page);\r\nexit();\r\n<\/pre>\n\r\ndynamic i = null, page = null;\r\nXSession.Session[\"ProductID\"] = keys[\"ProductID\"];\r\ni = new XVar(0);\r\nrs = XVar.Clone(DB.Query((XVar)(XSession.Session[\"ProductsSQL\"])));\r\nwhile(XVar.Pack(data = XVar.Clone(rs.fetchAssoc())))\r\n{\r\n\ti++;\r\n\tif(data[\"ProductID\"] == keys[\"ProductID\"])\r\n\t{\r\n\t\tbreak;\r\n\t}\r\n}\r\npage = XVar.Clone((XVar)Math.Floor((double)(i \/ XSession.Session[\"pageSize\"])) + 1);\r\nMVCFunctions.HeaderRedirect((XVar)(MVCFunctions.Concat(\"products_list.php?goto=\", page)));\r\nMVCFunctions.ob_flush();\r\nHttpContext.Current.Response.End();\r\nthrow new RunnerInlineOutputException();\r\n<\/pre>\n2. List page: BeforeSQLQuery event<\/h4>\n
\r\n$_SESSION[\"ProductsSQL\"] = $strSQL;\r\n$_SESSION[\"pageSize\"] = $pageObject->pageSize;\r\n<\/pre>\n
\r\nXSession.Session[\"ProductsSQL\"] = strSQL;\r\nXSession.Session[\"pageSize\"] = pageObject.pageSize;\r\n<\/pre>\n
3. List page: AferRecordProcessed event<\/h4>\n
\r\nif ($data[\"ProductID\"] == $_SESSION[\"ProductID\"] ) \r\n$record[\"css\"]=\"background:yellow;\";\r\n<\/pre>\n
\r\nif(data[\"ProductID\"] == XSession.Session[\"ProductID\"])\r\n{\r\n\trecord.InitAndSetArrayItem(\"background:yellow;\", \"css\");\r\n}\r\n<\/pre>\n4. List page: BeforeDisplay event<\/h4>\n
\r\n$pageObject->setProxyValue(\"ProductID\", $_SESSION[\"ProductID\"]);\r\n<\/pre>\n
\r\npageObject.setProxyValue(new XVar(\"ProductID\"), (XVar)(XSession.Session[\"ProductID\"]));\r\n<\/pre>\n
5. List page: Javascript OnLoad event<\/h4>\n
\r\nvar allRecords = pageObj.getAllRecords();\r\nallRecords.forEach(function(row){\r\nif( row.getFieldText('ProductID')==proxy['ProductID']) {\r\n$([document.documentElement, document.body]).animate({\r\n scrollTop: row.fieldCell('ProductID').offset().top\r\n }, 2000);\r\n}\r\n})\r\n<\/pre>\n