Need to add filter condition to one of the field

[Atchamma D]

Hi All,

I need to add the filter condition to one of the field name called "Serial Number" and it is referring to "alm_asset" table .

Exiting Condition:

install_status=6^model_category=81feb9c137101000deeabfc8bcbe5dc4^stockroom.assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744

As of now the condition will work as it will show assets in the alm_asset table that user belongs to one of stock room assignment group

New Requirement:

I need to add few more condition to existing requirement

For two group members all assets should visible

Please help me !!

Thanks,

Atchamma D

[sushantmalsure]

Hi @Atchamma D 

easiest way will be .

1. open alm_asset list layout (alm_asset.list)

2.add all the filter conditions and get satisfied with results (filtered records)

3. right click on filter conditions added and 'Copy Query'

4. open the dictionary of field 'Serial Number' and locate the existing condition and now replace that with copied text condition.

That will be all!!

[piyushsain]

Hi you can update the condition to the below one :

install_status=6^model_category=81feb9c137101000deeabfc8bcbe5dc4^stockroom.assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744^NQstockroom.assignment_group=019ad92ec7230010393d265c95c260dd^ORstockroom.assignment_group=553032e853165110b846ddeeff7b12aa

you can update the last two sys_id in RED with the sys_id of the group that you want.

Please mark it helpful if it helps you in any way

[piyushsain]

@Atchamma DIf my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.