Skip to main content

GlideAggregate function with passed-in parameters


var queryParam='email';
checkDuplUsers(true, queryParam);

function checkDuplUsers(activeUser, queryParam){
  var ga= new GlideAggregate('sys_user');
  ga.addAggregate('COUNT', queryParam);
  if (activeUser){
    ga.addActiveQuery();
  }
  ga.addHaving('COUNT', '>', 1);

  ga.query();
  gs.log("The following " + ga.getRowCount() + " users are duplicate on " + queryParam);
  while (ga.next()) {
      gs.log("GatherDuplicates " + queryParam + " " + ga.getAggregate('COUNT', queryParam) + " => " + ga.getElement(queryParam));
      
 }
}

Comments

Popular posts from this blog

Get URL Parameter - server side script (portal or classic UI)

Classic UI : var sURL_editparam = gs . action . getGlideURI (). getMap (). get ( ' sysparm_aparameter ' ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); } Portal : var sURL_editparam = $sp . getParameter ( " sysparm_aparameter " ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); }

URL link in addInfoMessage

var ga=new GlideAjax('gld_HR_ajax'); ga.addParam('sysparm_name', 'checkEmployeeNumber_hrProfile'); ga.addParam('sysparm_hrprofilenumber', g_form.getValue('number')); ga.addParam('sysparm_employeenumber', newValue); ga.getXMLAnswer(function(answer) { if (answer!='undefined' && answer!=''){ var navURL="<a style='text-decoration:underline;color:blue' href=hr_profile.do?sysparm_query=number=" + answer + ">" + answer + "</a><img width='3' src='images/s.gif'/>"; var sMsg='The employee number entered already exists on another HR Profile ' + navURL; //alert(sMsg); g_form.showErrorBox('employee_number', 'error - please check'); g_form.addInfoMessage(sMsg); } });