Can we publish data out of a view by using "Publish by View" feature in ADB v4.x, if we have a one-many relationship between publishing table & View?

Can we publish data out of a view by using "Publish by View" feature in ADB v4.x, if we have a one-many relationship between publishing table & View?

book

Article ID: KB0088433

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Resolution:
The "publish by view" feature is meant to be a one-to-one mapping between the publishing table and the view. For one-to-many, the view should be designated as a child table. The parent table and the View should be joined in the designer by using the "join to" tab with the appropriate key field.

Issue/Introduction

Can we publish data out of a view by using "Publish by View" feature in ADB v4.x, if we have a one-many relationship between publishing table & View?