Queries based on a form

kklosson

When a query is created based on a form for setting the query criteria, the search is always based on a CONTAINS operator. I've even tried altering the sql for the query but it still always does this. So if you have a male/female attribute and you select male, it returns male and female. Basically unacceptable.

Does anyone know of a way to overcome this?

BobK

When using forms for queries, you can also enter expressions (see page 35 and 36 of the user guide).

For example, to search for male enter =male

tford

I build my own queries using a Form of LoggedInSystemUser and stack the form on top of the query. That gets around the limitation you mentioned here & gives users complete visibility of the search criteria as well as the results all on 1 screen. Using auto refresh and save a form when attribute changes, the results below the form change dynamically as the user selects each form field. Users seem to love this approach.

kklosson

Re: BobK's response, yes indeed, but this attribute is presented as a drop list (Male/Female). Expressions do not seem to work. I had to change the attribute to "accept other values" so that the form would even accept "=Male". Even then, no good.

kklosson

So Tom, you have attributes associated with the SystemUser object which you load and then present the query off of those values? For example:

Customer.LastName=SystemUser.SrchLastName

Something like that?

tford

So Tom, you have attributes associated with the SystemUser object which you load and then present the query off of those values? For example:

Customer.LastName=SystemUser.SrchLastName

Something like that?

In the example above, the query is:

FIND Movement WHERE (Movement.Movement.Description=LoggedInSystemUser.Selected_Movement.Description OR LoggedInSystemUser.Selected_Movement IS UNDEFINED) AND Movement.WhenCompleted>=LoggedInSystemUser.Selected_Date_From AND Movement.WhenCompleted<=LoggedInSystemUser.Selected_Date_To AND (Movement.Movement.Group_List CONTAINS LoggedInSystemUser.Selected_Movement_Group.Grouping OR LoggedInSystemUser.Selected_Movement_Group IS UNDEFINED) AND (Movement.Timing.Timing=LoggedInSystemUser.Selected_Movement_Timing.Timing OR LoggedInSystemUser.Selected_Movement_Timing IS UNDEFINED) ORDER BY Movement.WhenCompleted DESC,Movement.TimingNbrSC,Movement.ID

kklosson

Thanks. While that is a good approach, I have some reference attributes to lookup, for example, a Customer's Account Manager is a lookup to AccountManager object, so I'd have to create a relationship between the AccountManager and the SystemUser. I don't think I will do this but for other uses, I like the concept and appreciate it.

Thanks

hpl123

kklosson,
I use a variation of Tom´s solution that might work in your scenario. I create a Index BO I use as the main "filter" i.e. I have reference queries on the index instance and then also dropdowns working as a filter on the index instance (e.g. ExerciseIndex > Exercises). The index instance is per user meaning the owner is always close at hand when needed for operations etc..