How to exclude fields in a BrowseDialog search


Author
Message
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
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
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
Here's the source that uses it in BrowseDialogWindow



Public Function Search(ByVal WhereStatements As WhereStatementCollection, ByVal useOrNotAnd As Boolean, ByVal tokens As Dictionary(Of String, String)) As Integer

'-- Establish Locals

Dim lnReturn As Integer = 0

Dim loInfo As New QueryInformation()



'-- Build the query information

loInfo.QueryType = QueryTypeOptions.SELECT_TOP

loInfo.TopRowCount = Me._BrowseDialog.MaximumReturnedRecords



If String.IsNullOrEmpty(Me._BrowseDialog.OverrideSearchTableName) Then

loInfo.TableName = Me._BusinessObject.TableName

Else

loInfo.TableName = Me._BrowseDialog.OverrideSearchTableName

End If



If String.IsNullOrEmpty(Me._BrowseDialog.OverrideSearchTableSchema) Then

loInfo.TableSchema = Me._BusinessObject.TableSchema

Else

loInfo.TableSchema = Me._BrowseDialog.OverrideSearchTableSchema

End If

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Edhy Rijo - 16 Years Ago
Edhy Rijo - 16 Years Ago
Alex Luyando - 16 Years Ago
Edhy Rijo - 16 Years Ago
Greg McGuffey - 16 Years Ago
Edhy Rijo - 16 Years Ago
                         I'm not seeing anything either Edhy that would allow the fields...
Greg McGuffey - 16 Years Ago
                             Thanks Greg for the confirmation.

I am going with the View...
Edhy Rijo - 16 Years Ago
                                 Ok here my conclusion, a view should be used and in this case of...
Edhy Rijo - 16 Years Ago
Charles R Hankey - 16 Years Ago
Edhy Rijo - 16 Years Ago
Greg McGuffey - 16 Years Ago
Edhy Rijo - 16 Years Ago
Charles R Hankey - 16 Years Ago
Greg McGuffey - 16 Years Ago
Charles R Hankey - 16 Years Ago
Charles R Hankey - 16 Years Ago
Charles R Hankey - 16 Years Ago
Edhy Rijo - 16 Years Ago
Edhy Rijo - 16 Years Ago
Greg McGuffey - 16 Years Ago
Charles R Hankey - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Edhy Rijo - 16 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search