We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

how to filter based on selected stock room ?

Go to solution
chercm
Mega Sage

‎10-05-2023 06:10 PM

Stockroom -> alm_stockroom

Consumable -> alm_consumable

 

i tried to use this qualifier on the consumable but i kept getting everything not the one specified to the selected stock room 

 

javascript: "install_status=6^stockroom=" + current.getValue('stockroom');
0 Helpfuls
  • 4,860 Views
3 ACCEPTED SOLUTIONS

Go to solution
Danish Bhairag2
Tera Sage
In response to chercm

‎10-05-2023 07:16 PM

Hi @chercm ,

 

It should be u_stockroom. Replace with u_ for stockroom n check.

 

Thanks,

Danish

View solution in original post

0 Helpfuls

Go to solution
AnveshKumar M
Tera Sage
In response to chercm

‎10-05-2023 07:16 PM

@chercm It is a custom field change your reference qualifier to this.

 

javascript : "install_status=6^stockroom=" + current.u_stockroom;

 

Thanks,
Anvesh

View solution in original post

Go to solution
AnveshKumar M
Tera Sage
In response to chercm

‎10-05-2023 08:42 PM

Hi @chercm 

What I understood is you are expecting to deduct the stock when a Catalog Task is closed.

 

Try creating a business rule like the one below.

 

Name: Deduct asset quantity from stock

Table: sc_task

Advanced: True

 

When to Run Section:

When: After

Insert: True

Update: True

 

Conditions:

Asset :: is Not Empty

Stock Room :: is Not Empty

State :: Changes to :: Closed Complete

 

 

Advanced Section:

 

Script:

 

(function executeRule(current, previous){

var almGr = new GlideRecord('alm_asset');

almGr.addQuery('sys_id', current.u_reference_1);

almGr.query();

if(almGr.next()){

   var quantity= almGr.getValue('quantity');

   var req_quantity= current.request_item.quantity;

   try{

      quantity = quantity - req_quantity;

      if(quantity >= 0){

         almGr.setValue('quantity', quantity);

         almGr.update();

      } else{

         gs.addErrorMessage('Available quantity is less than the requested quantity, unable to update the stock.');

      }

   }catch(ex){

      gs.addErrorMessage('Unexpected Error:' + ex.message);

   }

}

 

}

 

)(current, previous)

 

 

Please mark my answer helpful and accept as solution if it helped you 👍✅

Thanks,
Anvesh

View solution in original post

32 REPLIES 32

Go to solution
chercm
Mega Sage
In response to Danish Bhairag2

‎10-05-2023 09:54 PM - edited ‎10-05-2023 09:56 PM

@Danish Bhairag2 

 

how can i remove the selection on the right like add to cart? instead to have only 1 submit button to trigger the flow. is it due to the fact i park this form under service catalog -> periperals ?

 

0 Helpfuls

Go to solution
Danish Bhairag2
Tera Sage
In response to chercm

‎10-05-2023 09:57 PM

Hi @chercm ,

 

Please look at the below screenshot please.

DanishBhairag2_0-1696568207549.png

 

This will only keep the submit button on the portal whenever requestor opens to submit the form.

 

Mark my answer helpful & accepted if it helps you resolve your query.

 

Thanks,

Danish

Go to solution
chercm
Mega Sage
In response to Danish Bhairag2

‎10-05-2023 10:12 PM - edited ‎10-05-2023 10:37 PM

@Danish Bhairag2 @AnveshKumar M 

 

i followed what you were saying and there is no submit button 

Screenshot 2023-10-06 at 1.11.28 PM.png

 

 

Screenshot 2023-10-06 at 1.10.23 PM.png

 

0 Helpfuls

Go to solution
Danish Bhairag2
Tera Sage
In response to chercm

‎10-05-2023 10:51 PM - edited ‎10-05-2023 10:53 PM

Hi @chercm ,

 

That is because you are trying to open the form in Backend view not on service Portal. End users/Requestors mostly has access to portals only so the above configuration will work in portal.

 

Also I would suggest @chercm to open a new thread/post a new question so that it can be helpful for others who visit your posts to track the solution.

 

Thanks,

Danish