If I use the sendDocQuery-Function in Get-Resources, I got e.g. a query like this:
SELECT lPortfolioItemId FROM amPortfolio WHERE lPortfolioItemId = 123456
This statement works.
But, if I try to grab more then 1 lPortfolioItemId's, because they are softwareinstallations related to the asset, I got a problem. I mean, sendDocQuery creates then a query like this:
SELECT lPortfolioItemId FROM amPortfolio WHERE (lPortfolioItemId = 123456) AND (lPortfolioItemId = 654321)
This doesn't works, because of the AND-condition.
I need there a OR-condition.
How can I transform, within sendDocQuery, the AND-condition in a OR-condition?
Any help or input would be appreciated. Nick
SELECT lPortfolioItemId FROM amPortfolio WHERE lPortfolioItemId = 123456
This statement works.
But, if I try to grab more then 1 lPortfolioItemId's, because they are softwareinstallations related to the asset, I got a problem. I mean, sendDocQuery creates then a query like this:
SELECT lPortfolioItemId FROM amPortfolio WHERE (lPortfolioItemId = 123456) AND (lPortfolioItemId = 654321)
This doesn't works, because of the AND-condition.
I need there a OR-condition.
How can I transform, within sendDocQuery, the AND-condition in a OR-condition?
Any help or input would be appreciated. Nick