The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

CI's - Contacts

Highlighted
Alfio Torrisi
Collector

CI's - Contacts

Hi,

i need to view in contact.g module ci's assigned to every contact.

I create a VJ and now i have a table in contact.g that shows ci's of contact. It works.
But now my customer wants the possibility to click on every ci's (in contact.g) to modify them...

How i can do it?
I attach some screen shoot...

Thank you!
1 REPLY
Jacob Heubner
Honored Contributor

Re: CI's - Contacts

Actually, this isn't that hard to do.

First, though, I would recommend copying the device.qbe.g form that you're using in your virtual join and use the copy instead, because we're going to be making some changes to it. Let's call it "contact.device.vj"

Use that as the subform used in your virtual join.

Then, edit the "contact.device.vj" form in Form Designer. Select the table, and in the Properties window, you'll see a "Double-Click Button ID" field and a "Double Click Field" field. In the "Double-Click Button ID" field, put 8 (that's the button for "Find") and in the "Double-Click Field" field, put "logical.name" (the unique field in the device table). Then save this form.

Then, you need to edit your link record for the contacts table to add a link for this virtual join.

Add the following line in the "contacts" link record:

Source Field Name: logical.name
Target File Name: device
Target Field Name: logical.name
Add Query: $query
Comments: VJ Only

Then, select that line and add the following:

Expressions:
$query="logical.name=cursor.field.contents()"


That should do it.

If that helps, I appreciate points.
//Add this to "OnDomLoad" event