Hi All.

I am working on an application where there is an application level filter in effect by user. I would like to use the BrowseDialog to allow the users to search for records but only within a subset that satisfies the filter condition.

Is it possible to do this?

TIA

Marcia

Hi Marcia,
Yes, you can do all that.  Take a look at the Browse Dialog topic in the UI Layer in the help file.  There is a "Visible" property that will allow you to show/hide any search field, also you can set a default value programatically without user know about it.

Edhy Rijo

Hi Edhy.

Thanks for the quick response. I have done what you suggested before for simple filter conditions. However, this one is a bit more complex. It would be something like this:

ProviderID IN (2, 4, 6, 8, 10)

Can I do something like that with an invisible field?

TIA

Marcia

Hi,

I wonder if your intention is to filter the results of the search query? If so, you can add a where clause in the BrowseDialog_Searching event. The following example adds a where condition that only returns records which have two fields equal to 0:-

// Add a "Where" clause to only include records where FIELD1 = 0 and FIELD2 = 0

System.Collections.ArrayList value = new System.Collections.ArrayList();

value.Add(0);

MicroFour.StrataFrame.Data.WhereStatement where1 = new MicroFour.StrataFrame.Data.WhereStatement(new String[] { "FIELD1" }, value, MicroFour.StrataFrame.Data.WhereStatementTypeOptions.Equals);

e.RawWhereStatementsCollection.Add(where1);

MicroFour.StrataFrame.Data.WhereStatement where2 = new MicroFour.StrataFrame.Data.WhereStatement(new String[] { "FIELD2" }, value, MicroFour.StrataFrame.Data.WhereStatementTypeOptions.Equals);

e.RawWhereStatementsCollection.Add(where2);

Hope this helps.

Oops, I crossed posts with you.

There is an "IN" clause, i.e. "MicroFour.StrataFrame.Data.WhereStatementTypeOptions.In"

This is exactly what I want to do! Thanks a million before taxes!

Marcia

Please don't mention taxes.....

Hi Aaron.

Here is the code that I have in brwPatients_searching method and it does not filter the what is returned - it gives me all the records.

What am I doing that is stupid?

// Add a "Where" clause to only include records where the provider id

// is in the current filter condition

System.Collections.ArrayList value = new System.Collections.ArrayList();

value.Add(AppMain.Current_Filter);

MicroFour.StrataFrame.Data.WhereStatement WhereClause = new MicroFour.StrataFrame.Data.WhereStatement(new String[] { "ProvID" }, value, MicroFour.StrataFrame.Data.WhereStatementTypeOptions.In);

Hi Aaron.

Never mind. I must have taken my stupid pills this morning. I was missing this line of code:

e.RawWhereStatementsCollection.Add(where2);

Please don't mention taxes.....

  Amen!