Skip to Content
0
Former Member
Oct 19, 2011 at 12:48 PM

How to use @WHERE?

25 Views

I want to make 2 predefined filters where one is dependent on the other. For example:

filter one allows to select a class from a list and filter two allows to select names from persons, but only persons from the previous selected class.

I have made a predifined filter(1) in a universe with the whereclause:

@Select(Class\Classlist) IN @Prompt('Select a class','A','Class\Classlist',multi,constrained)

The second filter so far is:

@Select(Names\LastNames) IN @Prompt('Select a name','A','Names\Lastnames',multi,constrained) @WHERE (Class\Classlist)

Unfortunately I got the message 'sql statement not properly ended. Where do I go wrong?