show assets based on assignment group of stockroom

[Ramakrishna Rao]

Hi ServiceNow Community,

There is one catalog item for asset allocation in which when the req is submitted and sc_task is created under RITM for specific group. If I change the assignment group on sc_task(manually) then i want to show assets belong to the stockroom of that assignment group which are in stock and available. How can I do this One?

Please give your inputs.

[DrewW]

Yes it will, at least it has for me.

You need to be more clear on what is not working.  Are you seeing errors in the system log?  Is there a browser console error? Is it showing no records, all records or something else.  Have you verified that the filter you set returns at least some records?

[Ramakrishna Rao]

It is showing no records

[DrewW]

If removing the ref qual causes records to show then its an issue with the setup of the ref qual and you need to figure out what is wrong with that.  I would make sure you query the asset table using the filter that you thing is should be just to make sure the data is what you think it is.  There has been more than once it has turned out that my filter is working and I am mistaken on what should be displaying.

[Ramakrishna Rao]

Please tell me one thing if (is one of) is not available in list filter on asset tableif i have given reference qualifier as 'sys_idIN' + stockrooms will work or not?

[DrewW]

It will but you have to use the sys_id's of the stock rooms.  But you said you wanted to filter the list of assets based on the assignment group of the stock room.  That in no way fits into a sys_idIN filter unless you use a script include to query for the list of stock rooms and return a comma delimited list of there sys_ids.  That was why I suggested "stockroom.assignment_group=".

I feel like there is something missing from the requirements that you provided.