Skip to content

Instantly share code, notes, and snippets.

@gsherman
Created March 30, 2010 03:39
Show Gist options
  • Save gsherman/348730 to your computer and use it in GitHub Desktop.
Save gsherman/348730 to your computer and use it in GitHub Desktop.
var employee_objid = 268435457;
var boReportsEmp = FCSession.CreateGeneric('employee');
var boReportsUser = FCSession.CreateGeneric('user');
boReportsEmp.AppendFilter("emp_supvr2employee", "=", employee_objid);
boReportsUser.TraverseFromParent(boReportsEmp, "employee2user");
boReportsUser.AppendFilter("status","=",1); // This appears to be ignored.
boReportsEmp.Query();
WScript.Echo('Total count of users:' + boReportsUser.TotalCount());
WScript.Echo('Total count of employees:' +boReportsEmp.TotalCount());
WScript.Echo('');
while (!boReportsEmp.EOF)
{
WScript.Echo('(' + boReportsEmp.Position + ') ' + boReportsEmp('first_name') + ' ' + boReportsEmp('last_name'));
boReportsEmp.MoveNext();
}
boReportsEmp.MoveFirst();
WScript.Echo('');
while (!boReportsEmp.EOF)
{
while (!boReportsUser.EOF){
WScript.Echo('(' + boReportsEmp.Position + ') ' + boReportsEmp('first_name') + ' ' + boReportsEmp('last_name') + ' (' + boReportsUser('login_name') + ') status: ' + boReportsUser('status'));
boReportsUser.MoveNext();
}
boReportsEmp.MoveNext();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment