If record exist in the table, the catalog form should not allow to submit and should display the alert message with Record already exist.

[Suresh36]

If record exist in the table, the catalog form should not allow to submit and should display the alert message with Record already exist. If it is new record the form is allowed to submit and insert the record.

But when Iam trying to submit the form with duplicate record, alert message is populating but form is submitted with data. It should not be allowed to submit the form, if it is duplicate.  

Please find the below code, pls correct if anything wrong.

 if (g_form.getValue('oss_gov_package_registry') == 'npm' || g_form.getValue('oss_gov_package_registry') == 'nuget') {
        alert('inside npm :' + g_form.getValue('oss_gov_package_registry'));
        //var ga1=new GlideAjax('InsertLicenseRecord');
        ga1.addParam('sysparm_name', 'isRecordExistInOSSLibrary');
        ga1.addParam('sysparm_packageName', g_form.getValue('package_name'));
        ga1.addParam('sysparm_packageRegistry', g_form.getValue('oss_gov_package_registry'));
        ga1.addParam('sysparm_packageVersion', g_form.getValue('oss_gov_version_number'));
        ga1.getXML(validatePackage);     

    } 

    function validatePackage(response) {
        result = response.responseXML.documentElement.getAttribute('answer');
        alert("result" + result);

        if (result == 'true') {
            alert('Record is already exist so please submit the record with different value');
            }
    }

    return false;

}

Script Include :

var ValidateOSSLibraryRecord = Class.create();
ValidateOSSLibraryRecord.prototype = Object.extendsObject(AbstractAjaxProcessor, {
    isRecordExistInOSSLibrary: function() {
        gs.log('insertRecordOSSLibrary : npm : ');
        var retVal = 'false';
        var packageRegistry = this.getParameter('sysparm_packageRegistry');
        var gr = new GlideRecord('u_oss_library');

if (packageRegistry == 'npm' || packageRegistry == 'nuget') {
            var packageName = this.getParameter('sysparm_packageName');
            var packVersion = this.getParameter('sysparm_packageVersion');
            gs.info('Package Name : '+packageName);
            gs.info('Package Version : '+packVersion);
            
            //var gr = new GlideRecord('u_oss_library');
            gr.addQuery('u_library_name', packageName);
            //gr.addQuery('u_packagetype', packageRegistry);
            gr.addQuery('u_version', packVersion);
            gr.query();
            if (gr.next()) {
                 gs.info('NPM/nuget Package Name is already exist');
               retVal = 'true';
                
            }

return retVal;

},

[Suresh36]

I have tried with this code, but getting record Exist value is null , it is not enter in to if condition. 

[Mahendra RC]

Could you please check once with below script in your onSubmit client script:

if (g_form.getValue('oss_gov_package_registry') == 'npm' || g_form.getValue('oss_gov_package_registry') == 'nuget') {
        alert('inside npm :' + g_form.getValue('oss_gov_package_registry'));
        var ga1=new GlideAjax('ValidateOSSLibraryRecord');
        ga1.addParam('sysparm_name', 'isRecordExistInOSSLibrary');
        ga1.addParam('sysparm_packageName', g_form.getValue('package_name'));
        ga1.addParam('sysparm_packageRegistry', g_form.getValue('oss_gov_package_registry'));
        ga1.addParam('sysparm_packageVersion', g_form.getValue('oss_gov_version_number'));
        ga1.getXMLWait(); 
        var recordExist =ga1.getAnswer();
        if (recordExist == "true") {
                alert('Record is already exist so please submit the record with different value');
                return false;
        }
}

Please mark my respsone as helpful/correct, if it answer your question.

Thanks