Record Producer - Check if User Registered Already

[michaelcory]

Hi,

I have a Training Class Registration application with Attendee,Training Class, & Training Room tables.   A Record Producer form (on Attendee table) allows someone to register for a Class by entering the Attendee Name and selecting a Training Class. The Attendee Name variable references the User table.   The Training Class variable references the Training Class table.   Training Class variable is mapped to the Training Class table and already includes a reference qualifier (java script call to script includes) that sets the filter to only show Classes with a Status of "Open".

I have a new requirement to check if an Attendee has already registered for a Class that they are trying to select again.   Before the Record Producer is submitted, I would need to check the Training Class (sys id) selected against the Attendee Name (User sys id) selected and I assume query the Class related list of Attendees to check if the Attendee sys id is listed.   If a match is found, show alert that "Attendee has already registered".  

Can this be done in a Business Rule with glide query or is there another way to accomplish it?   Any insight into how to do this would be greatly appreciated.

[michaelcory]

I am getting the alert for attendee and trclass.   Alert shows sys_id for both.

[SanjivMeher]

Correct the below makred bold ga.addparm. it should be ga.addParam

function onSubmit(){

var attendee = g_form.getValue('u_attendee_name');

var trClass = g_form.getValue('u_training_class');

alert('+++++++++attendee '+attendee );

alert('+++++++++trClass '+trClass );

var ga = new GlideAjax('RegisterAttendee');

ga.addParam('sysparm_name','getAttendee');

ga.addParam('sysparm_attendee_name',attendee);

ga.addparm('sysparm_class_name',trClass);

ga.getXMLWait();

alert('=============my ga.getAnswer() is ========='+ga.getAnswer());

if(ga.getAnswer()=="false"){ //add the attendee;

}else{

alert("The Attendee you are trying to enter is already registered for this Class.");

}

}

[michaelcory]

arggh!   Hate it when I do that.   Great eye Sanjiv!   I'm getting output now, but still not working.   Getting a null answer and Attendee Already Registered prompt, regardless if Attendee is already in the related List or not.   Clicking OK submits the form and generates the Attendee record.

 

[SanjivMeher]

Now lets check your script include. I added few debug statements. Submit again and check the logs.

Also why do you have this commented - //type: 'RegisterAttendee'. I think you need to uncomment that

var RegisterAttendee = Class.create();

RegisterAttendee.prototype = Object.extendsObject(AbstractAjaxProcessor, {

getAttendee: function() {

gs.log('++++++++++Inside the script include++++++++++++++');

var an = this.getParameter('sysparm_attendee_name');

var tc = this.getParameter('sysparm.class_name');

var att = new GlideRecord('u_attendee');

att.addQuery('u_attendee_name',an);

att.addQuery('u_training_class',tc);

att.query();

if(att.next()){

gs.log('++++++++++Inside the if statement+++++++++att.u_attendee_name+++++'+att.u_attendee_name);

if(att.u_attendee_name == an && att.u_training_class == tc){

return true;

}

else {

return false;

}

}

}

      //type: 'RegisterAttendee'

});

[michaelcory]

I'm getting a log entry for "inside the script include" but nothing for "inside the if statement"

I commented the type: 'RegisterAttendee' because it's giving the following errors and I tried several variations of brackets, parens, semicolon, but nothing seems to work.   I looked at other Script Include examples and didn't see it in those, so I commented it out.   It got auto-generated when I created the SI.   It probably does have a purpose, but can't figure out how to leave it in with no errors.