How to exclude fields in a BrowseDialog search

StrataFrame Forum

Back

How to exclude fields in a BrowseDialog search

Author	Message
Edhy Rijo	E Edhy Rijo posted 14 Years Ago HOT Topic Details Share Topic
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	Hi all, Is it possible to specified or exclude the fields to be included in a BrowseDialog? Since a Browse Dialog is assigned to a BO I believe that it will bring all fields in the BO, how to exclude a couple of fields in the SELECT statement so only the ones needed are used in the SELECT Field1, Field2, Field3, etc.? Edhy Rijo
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Threaded View

How to exclude fields in a BrowseDialog search

Edhy Rijo - 14 Years Ago

Forgot to mention that I know I can create a view for this but is...

Edhy Rijo - 14 Years Ago

Edhy -

Hello.

So, you can control the fields...

Alex Luyando - 14 Years Ago

[quote][b]Alex Luyando (03/11/2010)[/b][hr]...When the BO that is to...

Edhy Rijo - 14 Years Ago

Aren't there some events you can use to manipulate the SQL being sent?...

Greg McGuffey - 14 Years Ago

[quote][b]Greg McGuffey (03/11/2010)[/b][hr]Aren't there some events...

Edhy Rijo - 14 Years Ago

I'm not seeing anything either Edhy that would allow the fields...

Greg McGuffey - 14 Years Ago

Thanks Greg for the confirmation.

I am going with the View...

Edhy Rijo - 14 Years Ago

Ok here my conclusion, a view should be used and in this case of...

Edhy Rijo - 14 Years Ago

( I'm posting this without thinking it through completely so bear with...

Charles R Hankey - 14 Years Ago

Hi Charles,

Yes you are right, but in the BD I don't see...

Edhy Rijo - 14 Years Ago

Actually, one of the very cool things about BOs is that you can fill a...

Greg McGuffey - 14 Years Ago

[quote][b]Greg McGuffey (03/11/2010)[/b][hr]The issue Edhy was having...

Edhy Rijo - 14 Years Ago

okay, again I may not be thinking this throug, but my idea is to use...

Charles R Hankey - 14 Years Ago

Where's Override Schema? Is this an event or property or method?

Greg McGuffey - 14 Years Ago

OverrideSearchTableName
OverrideSearchTableSchema
...

Charles R Hankey - 14 Years Ago

Here's the source that uses it in BrowseDialogWindow
...

Charles R Hankey - 14 Years Ago

okay, on searching further here on the forum I get it - the "schema"...

Charles R Hankey - 14 Years Ago

Yes Charles, this refers to the database Schema not the fields, but I...

Edhy Rijo - 14 Years Ago

[center][b]!!!Warning!!!![/b][/center]

For anybody using...

Edhy Rijo - 14 Years Ago

Seems like an analogous method to the OverrideSearchTableName/Schema...

Greg McGuffey - 14 Years Ago

The Public Function Search() in the browsedialogwindow uses the bo...

Charles R Hankey - 14 Years Ago

OK....let me jump in here. First, there is already a way to do both....

Trent L. Taylor - 14 Years Ago

Hi Trent,

Thanks for the explanation and for the new event...

Edhy Rijo - 14 Years Ago

Reading This Topic

Login
Remember Me Reset Password Resend Validation Email Login