StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Working with Browsedialog with view

Working with Browsedialog with view

Doron Farber — Thu, 27 Aug 2009 08:46:56 GMT

Hi Trent,

I found this link at: [url]http://forum.strataframe.net/Topic23458-7-1.aspx?Highlight=browsedialog+with+view [/url]

I tried to implement it and so far it does not work for me.;)

Reading the below I was not sure where do I add the fields that do not exits in the mainBO.
[quote]I will also add the search fields even though they do not exist as part of the original table structure:[/quote]

Like in my BO I have 2 FKs like: SearchOptions_FK and SearchCategories_FK and need to add the actual description fields for those FKs some where. Also the Result I have some more FKs that is needed to be shown as well.

The View name is: Get_Products_MenuOptions_View and main table for that form is: ProductsMGR

I appreciate some clarifications in that matter.

Thanks,

Doron

RE: Working with Browsedialog with view

Trent L. Taylor — Thu, 27 Aug 2009 08:46:56 GMT

Thiw is somewhat hard to diagnose without actually having your data anb the environment setup.

On a small scale, outside of your application, can you make this work? If you create a test project to setup this one thing, can you get it to work?

RE: Working with Browsedialog with view

Doron Farber — Wed, 26 Aug 2009 11:31:09 GMT

Hi Trent,

I download the sample app found at: [url]http://forum.strataframe.net/Topic24160-6-1.aspx#bm24293 [/url] for the browse dialog and it is works fine on my computer. But in my scenario I can not make it to work.

I even tried a to test with a simple form as you did in your sample. When I had the fields name like: SearchOption and SearchCategory I still loose these names when looking into other fields in the combo box for Search Fields or the BrowseResultLayout. For the SearchOption and SearchCategory I have actually the FKs in that BO. If I type the names of those 2 fields and running the browse dialog I am getting this error as well: Object reference not set to an instance of an object.

If I had another field which is part of the BO then the browse dialog is loaded but those 2 fields SearchOption and SearchCategory are not shown.

This the main bo is named: ProductsMGRBO and it has the below fields:
ProductsMGR_PK
SearchOptions_FK
SearchCategories_FK
Products_FK
DisplayProdutOrder
DateTimeCreated

Actually me Edhy tried to make it work, but it just did not happen. Is there a view problem in here? See also attached data after running the view. If you look at the attached spread sheet there is no any NULL record. It is a straight forward data.:)

The below view is based on a SP that I used all the time with no problem.
[u]Here is the corrected view:[/u]

[codesnippet]CREATE VIEW [dbo].[Get_Products_MenuOptions_View]
AS
SELECT
dbo.ProductsMGR.ProductsMGR_PK,
dbo.ProductsMGR.SearchOptions_FK,
dbo.ProductsMGR.SearchCategories_FK,
dbo.ProductsMGR.Products_FK,
dbo.ProductsMGR.DisplayProdutOrder,
dbo.ProductsMGR.DateTimeCreated,
dbo.Products.ProductName,
dbo.Products.Price,
dbo.Products.OriginalPrice,
dbo.Products.DiscountedPrice,
dbo.SearchCategories.SearchCategory,
dbo.SearchOptions.SearchOption,
dbo.Products.ProductNo,
COALESCE(dbo.Products.Percentage,'UNKNOWN') AS Percentage
FROM
dbo.ProductsMGR
INNER JOIN dbo.Products
ON dbo.ProductsMGR.Products_FK = dbo.Products.Products_PK
INNER JOIN dbo.SearchOptions
ON dbo.ProductsMGR.SearchOptions_FK = dbo.SearchOptions.SearchOptions_PK
INNER JOIN dbo.SearchCategories
ON dbo.ProductsMGR.SearchCategories_FK = dbo.SearchCategories.SearchCategories_PK
GO
[/codesnippet]

Thanks,

Doron

RE: Working with Browsedialog with view

Trent L. Taylor — Fri, 14 Aug 2009 10:37:34 GMT

Well, the first red flag that I see is that you are using LEFT JOINs and then not COALESCEing anything from those JOINs. This can produce an error. If you look at the sample that you referenced that I added, I avoided using the LEFT JOIN and placed all logic within inline SELECTs. You don't necessarily have to do this, but if you are going to use LEFT JOINs, you MUST take any type of NULL value into account. That is the first thing that I suggest you address.

RE: Working with Browsedialog with view

Doron Farber — Thu, 13 Aug 2009 10:06:42 GMT

Hi Trent,

Thanks for your reply.

I have done the below already before, and let me explain what I have done.

[quote]Before you get too deep, first, just create a view that returns all of the same columns and attach it and see it the browse still works. If so, then let's go from there.[/quote]

BrowseResultLayout - All fields needed from the ProductsMGRBO (mainBO)
BusinessObjectToPopulate - ProductsMGRBO1 (main biz object)
BusinessObjectTipe - ProductsMGRBO

OverRideSearchTableName - Get_Products_MenuOptions_View1
OverRideSearchTableSchema - dbo

SearchFields - Need to place the SearchCategory and SearchOption fields which are part of the view and also in the Result Layout.

Here is the actual view name: Get_Products_MenuOptions_View

I am trying to search based of these fields: SearchCategory and SearchOption(part of the view) while the FKs of those fields are in the main BO named: ProductsMGRBO. The ProductsMGR is the main BO.

[codesnippet]SELECT
dbo.ProductsMGR.ProductsMGR_PK,
dbo.ProductsMGR.SearchOptions_FK,
dbo.ProductsMGR.SearchCategories_FK,
dbo.ProductsMGR.Products_FK,
dbo.ProductsMGR.DisplayProdutOrder,
dbo.ProductsMGR.DateTimeCreated,
dbo.Products.ProductName,
dbo.Products.Price,
dbo.Products.OriginalPrice,
dbo.Products.DiscountedPrice,
dbo.Products.ProductNo,
dbo.SearchCategories.SearchCategory,
dbo.SearchOptions.SearchOption
FROM
dbo.ProductsMGR
LEFT OUTER JOIN dbo.Products ON (dbo.ProductsMGR.Products_FK = dbo.Products.Products_PK)
LEFT OUTER JOIN dbo.SearchOptions ON (dbo.ProductsMGR.SearchOptions_FK = dbo.SearchOptions.SearchOptions_PK)
LEFT OUTER JOIN dbo.SearchCategories ON (dbo.ProductsMGR.SearchCategories_FK = dbo.SearchCategories.SearchCategories_PK)[/codesnippet]

Now how do I add the other fields from the view. Please provide some steps.

Thanks,

Doron

RE: Working with Browsedialog with view

Trent L. Taylor — Thu, 13 Aug 2009 08:55:16 GMT

Doron,

Before you get too deep, first, just create a view that returns all of the same columns and attach it and see it the browse still works. If so, then let's go from there.

This feature simply allows you to create a query that returns all rows (perform joins etc.) that can be searched on within the view results. But you will want to make sure that the BO pulling the result set still includes any fields associated with that table that are being referenced. Try the first step from above and see if you can at least query the exact same results that the BO table pulls.

For example:

[codesnippet]SELECT * FROM MyTable[/codesnippet]