PICK FROM requires WHERE for Business Objects

baskosi · Post by **baskosi** » Wed Jan 10, 2007 9:12 am

Hi,

It seems to me that rules in Processes require WHERE clause to be added when using PICK FROM <business object>.

If PostCode is a BO, following doesn't work:

PICK FROM PostCode

It says: "rule '' uses query 'PostCode' which has not been found"

It looks like it is interpreting PostCode to be a query name. When I add WHERE clause it doesn't complain:

PICK FROM PostCode WHERE PostCode.ID IS DEFINED

I have no problem adding WHERE. It is much easier than creating all those queries I wrote before realizing this

aware_support · Post by **aware_support** » Wed Jan 10, 2007 9:16 am

If you want to pick from all instances of a BO you should write your rule as:

PICK FROM ALL PostCode

Otherwise the name is interpreted as query name.

baskosi · Post by **baskosi** » Wed Jan 10, 2007 9:57 am

Thanks.

User Guide doesn't mention this option but it looks familiar now that you wrote it. Maybe I've read it in some other manual.