Highlighted
Acclaimed Contributor.
Acclaimed Contributor.
965 views

VirtualJoin from several tables

I need to display in contacts form for subscription tab subscriptions of user but for current dispalyed table taken from Subscription table using VJ i need add one more column with date of canceled subscription but this data in table activitySubscription.

So need display data from different table in current form in one - on form table

0 Likes
7 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: VirtualJoin from several tables

For example i need to display on contacts.g form in Subscribers tab next columns:

DisplayName (subscription), status(subscription), Subscriber(subsciption), subscriberType(subscription), datestamp(activitySubscription)

 

datestamp - last date for current status(subscription)

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: VirtualJoin from several tables

There are answers here:
https://community.microfocus.com/t5/Service-Manager-Service-Center/service-manager-how-to-add-data-from-another-table-to-an/m-p/1123421#M60070
It is necessary to create a join table of 2 and take information from it. Works good.

 

Тут есть ответы:
https://community.microfocus.com/t5/Service-Manager-Service-Center/service-manager-how-to-add-data-from-another-table-to-an/m-p/1123421#M60070
Нужно создать join таблицу из 2-х и брать информацию из нее. Работает хорошо.

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: VirtualJoin from several tables

1. Make new "joindef" record add so many tables as you need).

2. Check erddef record, if it not created automatically you need to do it manually.

3. Setup your link to use new join file and write form name to show list.

4. make new form for your join file.

On form use syntax file.yourfilename.yourfieldname:
for example:
file.Subscription,subscriberType
file.activitySubscription,
datestamp

If fieldname is unique you can use just fieldname, it will work.

1.
J_defs_1.jpg

 

 

 

 

2.
J_defs_2.jpg

3.
J_defs_3.jpg

4.
J_defs_4.jpg

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: VirtualJoin from several tables

The problem is that contacts table (where i need to display data from 2 other tables) has a relation (link VJ) with only1 table (Subscription) and has no direct relation with second table (activitySubscription). But Subscription table has relation (link VJ) with activitySubscription.

 

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: VirtualJoin from several tables

Make join table SubscriptionactivitySubscription

0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Re: VirtualJoin from several tables

joindef Subscription-activitySubscription ?

And then ? Use link for contacts with this new joindef ?

0 Likes
Highlighted
Super Contributor.
Super Contributor.

Re: VirtualJoin from several tables

In your link you need to change the destination table from Subscriptions to a new join table Subscriptions-activitySubscriptions. And specify qbe form name for the join file. And don't forget to make it (new form)

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.