Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

Add assets from cost center dynamically to filter

Created: 26 Jul 2012 • Updated: 27 Jul 2012 | 1 comment
This issue has been solved. See solution.

I have a filter and I need to add assets from about 4-5 cost center to the filter.

As the assets will change from time to time, I'd like to add them dynamically, so that an asset is removed from the filter, when it is removed from the cost center.

Is that easily doable? I'm not good at SQL :-)

Comments 1 CommentJump to latest comment

mclemson's picture

Would this work?

 

SELECT lcc._ResourceGuid 
FROM vAssetLocationCostCenter lcc
WHERE lcc.CostCenter IN (
'CC1',
'CC2',
'CC3',
'CC4',
'CC5'
)
 
Just replace CC1-5 with your cost center numbers.

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

SOLUTION