This documentation supports the 9.1 version of Remedy Action Request System.

To view the latest version, select the version from the Product version menu.

Modifying join form properties

After you create a join form, you can modify properties that determine the characteristics of how that join form looks and performs during operations performed in a browser.

You can "swap" which form is primary and which is secondary. You can also change the type of join — inner or outer. Depending on whether you are working with an inner join or outer join, swapping forms can result in completely different criteria. For example, if the primary form (A) has three fields (1, 2, 3) and the secondary form (B) has three fields (3, 4, 5), an inner join retrieves the field that the two forms have in common (field 3), and an outer join retrieves this field and the remaining primary form fields, that is, fields 1, 2, and 3. If you swap forms so that form B becomes the primary form and form A becomes the secondary form, an inner join yields the same results (field 3), but an outer join now retrieves the fields 3, 4, and 5. For more information about inner and outer joins, see Inner and outer joins.

The Join Information panel in the Definitions tab of BMC Remedy Developer Studio allows you to modify options specific to join forms.

Definitions tab — Join Information panel
(Click the image to expand it.)

Was this page helpful? Yes No Submitting... Thank you