Version 9.8 added an option to use Grid Tabs. Besides static tabs we also developed an API that allows to create and manage tabs from your code.
In this example we will use the typical Orders table to demonstrate how this API works. We will create a tab for each employee that lists her own orders only. This is how it is going to look in generated application.
This code needs to be added to List page: BeforeProcess event.
PHP
$sql = "select * from employees";
$rs = CustomQuery($sql);
while ($data = db_fetch_array($rs)) {
$pageObject->addTab("EmployeeID='".$data["EmployeeID"]."'",
$data["FirstName"], $data["EmployeeID"]);
}
C#
string sql = "select * from employees";
XVar rs = tDAL.CustomQuery(sql);
XVar data;
while (data = CommonFunctions.db_fetch_array(rs)) {
pageObject.addTab("EmployeeID='"+data["EmployeeID"].ToString()+"'",
data["FirstName"], data["EmployeeID"].ToString());
}
ASP
sql = "select * from employees"
set rs = CustomQuery(sql)
do while bValue(DoAssignment(data,db_fetch_array(rs)))
pageObject.addTab "EmployeeID='" & data("EmployeeID") & "'", _
data("FirstName"), data("EmployeeID")
loop
What happens if the list of employees makes the tabset wider than the screen width?
A point on list tabs in general: It would be great if the filters (along the left) were in sync with the tab queries. It’s confusing when the filter includes records that aren’t on the current tab’s list.
This is great. Thank you. It will definitely come in handy for certain use cases.
Hi
I’ve added this code, however gives error 256..
$sql = select * from Traders;
$rs = CustomQuery ($sql);
while($data = db_fetch_array($rs)){
$pageObject->addTab(“ID='”.$data[“ID”].”‘”,
$data[“ID”],$data[“ID”]);
}
Could someone help me out, on how to fix this.. I need to select users / trader from 1 database, and need the tabs to be split accordingly.
How do we add record count in each tab
Great new feature and addition in Runner.
How you did the tab “All orders”?