Disabling order now button for the agent

[is_12]

Hello Community !..

When agent is ordering the item from configurable workspace then write a logic as follows. On change of primary contact, fetch the primary contact's account and then go to RITM table and check for the catalog item and the account fetched from primary contact. If there is an existing record then restrict the agent from ordering and also display the alert message "You are not allowed to order as there is an existing request for this customer"

already there is a UC for controlling the visibility for the items for customer.

Thanks,

 

[SumanthDosapati · Accepted solution]

@is_12 

Try below approach.

1. Write an onChange client script on primary contact as below"
   

   function onChange(control, oldValue, newValue, isLoading) {
       if (isLoading || newValue == '') {
           return;
       }
   
       // Call GlideAjax to check existing RITMs
       var ga = new GlideAjax('CheckUserRITMs');
       ga.addParam('sysparm_name', 'hasExistingRITM');
       ga.addParam('sysparm_user_id', newValue);
       ga.addParam('sysparm_catalog_item', g_form.getUniqueValue()); // catalog item sys_id
       ga.getXMLAnswer(function(response) {
           if (response == 'true') {
               g_form.showFieldMsg('primary_contact', 'This user has already requested this item.', 'error'); //check field name
           } else {
               g_form.hideFieldMsg('primary_contact', true); //check field name
           }
       });
   }
   ​

2. Write a New Client callable script include as below
   Name: CheckUserRITMs
   Accessible from: All application scopes
   Client Callable: True
   

   var CheckUserRITMs = Class.create();
   CheckUserRITMs.prototype = Object.extendsObject(AbstractAjaxProcessor, {
       
       hasExistingRITM: function() {
           var userId = this.getParameter('sysparm_user_id');
           var catalogItemId = this.getParameter('sysparm_catalog_item');
   
           if (!userId || !catalogItemId) {
               return 'false';
           }
   
           var ritmGR = new GlideRecord('sc_req_item');
           ritmGR.addQuery('cat_item', catalogItemId);
           ritmGR.addQuery('u_primary_contact', userId); // replace with actual field name if different
           ritmGR.query();
   
           if (ritmGR.hasNext()) {
               return 'true';
           }
   
           return 'false';
       }
   
   });
   

This will show an error message at the field level and also user cannot submit even if they click the order button.

Accept the solution and mark as helpful if it does, to benefit future readers.
Regards,
Sumanth

[is_12]

@Ankur Bawiskar both sys_is are matching (item, account, primary)

[Ankur Bawiskar]

@is_12 

what came in row count in logs?

what came in alert? true or false?

any body has created custom query business rule on sc_req_item table which is restricting?

OOTB there is no query business rule

try to use setWorkflow(false) before query to disable that in GlideRecord

var ritmGR = new GlideRecord('sc_req_item');
        ritmGR.addEncodedQuery('cat_item.sys_id=' + catalogItemId + '^company.sys_id=' + userAccount + '^requested_for.sys_id=' + userId);
        ritmGR.setLimit(1);
        ritmGR.setWorkflow(false); // to disable any query business rule
        ritmGR.query();
        gs.info('agentIsh292 ' + ritmGR.getRowCount());
        return ritmGR.hasNext().toString();

If my response helped please mark it correct and close the thread so that it benefits future readers.

[is_12]

@Ankur Bawiskar 

  1) rowCount I'm getting 0, there are 2records with same account, primary contact in th sc_req_item,

2) In the alert - false is returing

and I tried by setWorkFlow(false) still it is the same

[Ankur Bawiskar]

@is_12 

are you running with admin user?

share the sc_req_item.LIST filter screenshot as per the values you got from log

In this case it should work fine then, I don't see any other issue

If my response helped please mark it correct and close the thread so that it benefits future readers.

[is_12]

@Ankur Bawiskar I'm have impersonated with agent,

both sys_id's are same

Thanks,