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
  • 1,400 Views
3 ACCEPTED SOLUTIONS

Go to solution
Danish Bhairag2
Tera Sage
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
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
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
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
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