StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
WinForms (How do I?)
»
How to exclude fields in a BrowseDialog search
How to exclude fields in a BrowseDialog search
Post Reply
Like
0
How to exclude fields in a BrowseDialog search
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Edhy Rijo
E
Edhy Rijo
posted 15 Years Ago
ANSWER
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
Replies
Edhy Rijo
E
Edhy Rijo
posted 15 Years Ago
ANSWER
Post Details
Share Post
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
Greg McGuffey (03/11/2010)
Aren't there some events you can use to manipulate the SQL being sent?
I looked at the Searching event, but it does handle the "WHERE" not the fields included or excluded from the BO.
Edhy Rijo
Reply
Like
0
Greg McGuffey
Greg McGuffey
posted 15 Years Ago
ANSWER
Post Details
Share Post
Group: Forum Members
Posts: 2K,
Visits: 6.6K
I'm not seeing anything either Edhy that would allow the fields included in the select to be manipulated.
Reply
Like
0
Edhy Rijo
E
Edhy Rijo
posted 15 Years Ago
ANSWER
Post Details
Share Post
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
Thanks Greg for the confirmation.
I am going with the View route and will do some testing soon, just that I need to do several changes since I want this to be used in all BDs.
Edhy Rijo
Reply
Like
0
Edhy Rijo
E
Edhy Rijo
posted 15 Years Ago
ANSWER
Post Details
Share Post
E
Group: StrataFrame Users
Posts: 2.4K,
Visits: 23K
Ok here my conclusion, a view should be used and in this case of refactoring the source BO for the Browse Dialog it was worthy because in the BrowseResultLayout I need to show some calculated fields which I created using Custom Field Properties and those where also slowing things down a bit, so I decided to create my BrowserDialog view with a JOIN condition to get the calculated fields in a single trip and now getting and showing the data in the Browse Dialog is much faster and responsive.
One caveat to take into consideration using this approach is that after the user selects the record to work with from the BD, I them have to search that PK in the primary BO used in the form which in this case is not the one used in the BD. I know this can be confusing sometimes but in my case it works just fine because searching a record using the BO.FillByPrimaryKey(PKValue) is much faster than looking for many records in the BD which will include those VarBinary or Varchar fields that are not used in the BD.
Hey Alex, hope all this makes sense and if not, please let us know.
Edhy Rijo
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
How to exclude fields in a BrowseDialog search
Edhy Rijo
-
15 Years Ago
Forgot to mention that I know I can create a view for this but is...
Edhy Rijo
-
15 Years Ago
Edhy -
Hello.
So, you can control the fields...
Alex Luyando
-
15 Years Ago
[quote][b]Alex Luyando (03/11/2010)[/b][hr]...When the BO that is to...
Edhy Rijo
-
15 Years Ago
Aren't there some events you can use to manipulate the SQL being sent?...
Greg McGuffey
-
15 Years Ago
[quote][b]Greg McGuffey (03/11/2010)[/b][hr]Aren't there some events...
Edhy Rijo
-
15 Years Ago
I'm not seeing anything either Edhy that would allow the fields...
Greg McGuffey
-
15 Years Ago
Thanks Greg for the confirmation.
I am going with the View...
Edhy Rijo
-
15 Years Ago
Ok here my conclusion, a view should be used and in this case of...
Edhy Rijo
-
15 Years Ago
( I'm posting this without thinking it through completely so bear with...
Charles R Hankey
-
15 Years Ago
Hi Charles,
Yes you are right, but in the BD I don't see...
Edhy Rijo
-
15 Years Ago
Actually, one of the very cool things about BOs is that you can fill a...
Greg McGuffey
-
15 Years Ago
[quote][b]Greg McGuffey (03/11/2010)[/b][hr]The issue Edhy was having...
Edhy Rijo
-
15 Years Ago
okay, again I may not be thinking this throug, but my idea is to use...
Charles R Hankey
-
15 Years Ago
Where's Override Schema? Is this an event or property or method?
Greg McGuffey
-
15 Years Ago
OverrideSearchTableName
OverrideSearchTableSchema
...
Charles R Hankey
-
15 Years Ago
Here's the source that uses it in BrowseDialogWindow
...
Charles R Hankey
-
15 Years Ago
okay, on searching further here on the forum I get it - the "schema"...
Charles R Hankey
-
15 Years Ago
Yes Charles, this refers to the database Schema not the fields, but I...
Edhy Rijo
-
15 Years Ago
[center][b]!!!Warning!!!![/b][/center]
For anybody using...
Edhy Rijo
-
15 Years Ago
Seems like an analogous method to the OverrideSearchTableName/Schema...
Greg McGuffey
-
15 Years Ago
The Public Function Search() in the browsedialogwindow uses the bo...
Charles R Hankey
-
15 Years Ago
OK....let me jump in here. First, there is already a way to do both....
Trent L. Taylor
-
15 Years Ago
Hi Trent,
Thanks for the explanation and for the new event...
Edhy Rijo
-
15 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search