browseDialog


Author
Message
Ian Johnston
Ian Johnston
StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)
Group: StrataFrame Users
Posts: 77, Visits: 470
Yes and rebuilt project.
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
After you set the Primary Key Specification, have you rebuilt the partial for this BO?
Ian Johnston
Ian Johnston
StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)
Group: StrataFrame Users
Posts: 77, Visits: 470
here is the code for the view:

SELECT     dbo.Certificate.Cert_number AS Certificate, dbo.Certificate.Cert_inbound_date AS date, dbo.Certificate.Cert_trans AS Tr, dbo.Certificate.Cert_net AS net,
                      dbo.Customer.cust_name AS Customer, dbo.Certificate.Cert_trk_license, dbo.Certificate.Cert_Front_trl, dbo.Certificate.Cert_Rear_trl,
                      dbo.Commodity.Commod_name AS commodity, Customer_1.cust_name AS Carrier, dbo.Certificate.PK_Certificate
FROM         dbo.Certificate INNER JOIN
                      dbo.Commodity ON dbo.Certificate.FK_Commodity = dbo.Commodity.PK_Commodity INNER JOIN
                      dbo.Customer ON dbo.Certificate.FK_Customer = dbo.Customer.cust_pk INNER JOIN
                      dbo.Customer AS Customer_1 ON dbo.Certificate.FK_Customer2 = Customer_1.cust_pk

In the sql management studio this will return the expected data. dbo.Certificate.PK_Certificate is the primary key in dbo,Certificate, this was the field I specified in the BO mapper, is that correct. Still no results in the browseDialog.

Ivan George Borges
Ivan George Borges
Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)Strategic Support Team Member (4.9K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hi Ian.

For a View, you need to have a Pk into it, and the override the primary key once in the BO Mapper, have a look at this picture:


Ian Johnston
Ian Johnston
StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)StrataFrame User (221 reputation)
Group: StrataFrame Users
Posts: 77, Visits: 470
I have a view as a BO named cert_viewBO this I set as the BussinessObjectToPopulate and BusinessObjectType, I have selected the search fields and the resultlayout but when I run the browsezDialog no results are returned.

Any ideas?

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search