how to display records count for master (without detail) ?

PHPMaker General Discussion (PHPMaker)
1

hi,

in table options, you have “detail record count” which (i guess) display the number of record in detail.

but, for the master, the number of row in the list page, how can we display it ?
any options ? a way to add/concate it into the caption title or caption menu item ?


Have a great day.

2

You may use MenuItem_Adding server event to concatenate the count to the Text property of the menu item. To get the count you may use, e.g.

$cnt = ExecuteScalar(“SELECT COUNT(*) FROM MyTableTable”);

The Text property contains the table caption, you need to change it back to table name for use in the SQL.

3

hi,

i find another way ( :

in list page startup script, i add :

var tableau=document.getElementById(“tbl_XXXXXXXXXXlist”);
if (tableau)
{
var nb_lignes=tableau.rows.length;
nb_lignes–; // because header
}
else
{
var nb_lignes=“0”;
}
var texte=" (“+nb_lignes+”)";
$( “.text-muted” ).append(texte);