Query Filtering - Query by Form

eyeargan · Post by **eyeargan** » Mon Mar 19, 2007 7:48 pm

Hello,

Here is my problem:
I need to allow users to query by form, but I need to filter OUT all instances where object.attribute <> blah.

In my process, I FIND using a query by form, then I CREATE a new instance of a temporary object (non-persist) where I INSERT the instances returned by the query. Then I DISPLAY using another query that filters the instances placed in the temporary object.

This doesn't work - it skips the query form completely.

I'm sure there is a correct way to do this...

Thanks,
Erik

Hubertus · Post by **Hubertus** » Mon Mar 19, 2007 10:03 pm

IMHO you could use a query with both predefined and ask-at-runtime WHERE statements.
Attribute1 = 'blah'
Attribute2 = (Ask at runtime)
Attribute3 = (Ask at runtime)
and so on.
The only insufficiency is that you cannot control the layout of the input form. Which means that the imput fields are placed one after the other.

Hope it helps,
Hubertus

eyeargan · Post by **eyeargan** » Tue Mar 20, 2007 1:55 am

I have used that approach in other cases, but here my forms include several drop-down combo boxes and ask-at-runtime only provides blank text boxes.

Thanks though,
Erik