StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Marcia G Akins — Wed, 16 Mar 2011 07:42:34 GMT

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

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Marcia G Akins — Wed, 16 Mar 2011 07:42:34 GMT

[quote][b]Aaron Young (3/15/2011)[/b][hr]Hi Marcia,

Sorry for the late reply. Is this still your code?

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);

Assuming you are still using the code above, I think AppMain.Current_Filter is the problem. I suspect it is a list of provider ID numbers but they are being added to the value array as a single element. They should be split and added as individual array elements. For example, take a look at this code:-

// This code adds a WHERE clause of "ID IN (10000145, 10000146, 10000149)
System.Collections.ArrayList value = new System.Collections.ArrayList();
value.Add(10000145);
value.Add(10000146);
value.Add(10000149);
MicroFour.StrataFrame.Data.WhereStatement where1 = new MicroFour.StrataFrame.Data.WhereStatement(new String[] { "ID" }, value, MicroFour.StrataFrame.Data.WhereStatementTypeOptions.In);
e.RawWhereStatementsCollection.Add(where1);

Aaron[/quote]

Hi Aaron. Thanks so much for all the help you have given me. Everything is working now. The problem was not Current_Filter. I am embarrassed to say that it was the loose nut behind the keyboard :blush:

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Aaron Young — Tue, 15 Mar 2011 17:55:25 GMT

Hi Marcia,

Sorry for the late reply. Is this still your code?

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);

Assuming you are still using the code above, I think AppMain.Current_Filter is the problem. I suspect it is a list of provider ID numbers but they are being added to the value array as a single element. They should be split and added as individual array elements. For example, take a look at this code:-

// This code adds a WHERE clause of "ID IN (10000145, 10000146, 10000149)
System.Collections.ArrayList value = new System.Collections.ArrayList();
value.Add(10000145);
value.Add(10000146);
value.Add(10000149);
MicroFour.StrataFrame.Data.WhereStatement where1 = new MicroFour.StrataFrame.Data.WhereStatement(new String[] { "ID" }, value, MicroFour.StrataFrame.Data.WhereStatementTypeOptions.In);
e.RawWhereStatementsCollection.Add(where1);

The above code definitely 100% works so if you can split AppMain.Current_Filter into separate IDs and add them to the array then you could be in luck. If it still doesn't work, can you give me an example for AppMain.Current_Filter?

Aaron

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Edhy Rijo — Tue, 15 Mar 2011 15:21:19 GMT

[quote][b]Marcia G Akins (3/15/2011)[/b][hr]...What I really need is for the code that Aaron gave me to put in the BrowseDialog_searching method to work as advertised. I followed his instructions exactly, but the result set was not filtered by the current provider(s). [/quote]
I see. Sorry, I have not used that functionality of the Dialog Browser yet.

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Marcia G Akins — Tue, 15 Mar 2011 14:51:18 GMT

[quote][b]Edhy Rijo (3/15/2011)[/b][hr]Probably this thread can help you out: http://forum.strataframe.net/FindPost23458.aspx[/quote]

Hi Edhy.

Thanks for trying to help. I don't think that this is going to do what I want. What I really need is for the code that Aaron gave me to put in the BrowseDialog_searching method to work as advertised. I followed his instructions exactly, but the result set was not filtered by the current provider(s).

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Edhy Rijo — Tue, 15 Mar 2011 14:31:50 GMT

Probably this thread can help you out: http://forum.strataframe.net/FindPost23458.aspx

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Marcia G Akins — Tue, 15 Mar 2011 10:32:05 GMT

[quote][b]Trent L. Taylor (3/15/2011)[/b][hr]One other thought on this would be to create a View. The Browse dialog has the ability to change the query table. This include the support of a view. You can also change this at run-time allowing you to have multiple views if necessary. Just another thought :)[/quote]

Can you share some sample code with me? I do not think that the multiple views would work because the user can select one or more providers so the data that the browse dialog runs over would have to change with a dynamic WHERE clause at run time.

TIA

Marcia

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Marcia G Akins — Tue, 15 Mar 2011 09:18:14 GMT

This code is still not working to filter the result set. This is what I am trying to do. I have an application level filter set up to displat information from one or more selected providers. When I go to select a patient, I want the result set to include only patients for the provider(s) that have been set up as the application level filter.

When I search, all patient records are being returned.

What am I doing wrong?

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Marcia G Akins — Tue, 15 Mar 2011 09:14:51 GMT

This code is not filtering the result set. Here is what I am trying to do. I am searching for patients but I only want the browse dialog to search patients for one or more specific providers that have been set as an application level filter.

Even with the code in the Searching method, I am still getting all the patients back.

What am I doing wrong?

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Trent L. Taylor — Tue, 15 Mar 2011 08:56:43 GMT

One other thought on this would be to create a View. The Browse dialog has the ability to change the query table. This include the support of a view. You can also change this at run-time allowing you to have multiple views if necessary. Just another thought :)

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Trent L. Taylor — Tue, 15 Mar 2011 08:55:18 GMT

[quote]Please don't mention taxes.....[/quote]

:) Amen!

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Marcia G Akins — Tue, 15 Mar 2011 08:16:07 GMT

Hi Aaron.

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

e.RawWhereStatementsCollection.Add(where2);

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Marcia G Akins — Tue, 15 Mar 2011 08:14:27 GMT

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);

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Aaron Young — Mon, 14 Mar 2011 15:10:58 GMT

Please don't mention taxes.....

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Marcia G Akins — Mon, 14 Mar 2011 15:07:54 GMT

[quote][b]Aaron Young (3/14/2011)[/b][hr]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:-

[/quote]

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

Marcia

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Aaron Young — Mon, 14 Mar 2011 15:00:08 GMT

Oops, I crossed posts with you.

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

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Aaron Young — Mon, 14 Mar 2011 14:57:51 GMT

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.

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Marcia G Akins — Mon, 14 Mar 2011 14:54:39 GMT

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

RE: Is it possible to add a filter condition to what gets displayed in the BrowseDialog?

Edhy Rijo — Mon, 14 Mar 2011 14:45:16 GMT

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.