E9: Customization - Display "Query" or Combination of dataViews

Yahoo Archive
1
I can, and did, do this.

When I select UD04View as the EpiBinding view for an EpiUltraGrid, I can
only see the fields in UD04. In my case, I would need to pull all
relevant information from the CustCnt view.

Is there some way to create a view that has the two tables joined?



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Sean McDaniel
Sent: Tuesday, May 04, 2010 4:50 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Customization - Display "Query" or
Combination of dataViews in an EpiUltraGrid





Can't you join in the UD04 table through the wizard? And then you have
access to this table.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Joe Rojas
Sent: Tuesday, May 04, 2010 3:18 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] E9: Customization - Display "Query" or Combination of
dataViews in an EpiUltraGrid

Hi All,

We have customized the Project Entry screen to meet our needs.

One of the requirements was to connect Customer Contacts to a Project.

I am storing these Contacts in the UD04 table.

What I'd like to do is only store the CustNum, ShipToNum, and ConNum in
UD40 and then pull, in real-time, the details for the contact.

In SQL terms, I'd join UD40 to Customer and CustCnt then display my
results.

Is this possible to do in a customization and display the results in a
EpiUltraGrid?

If so, any examples to tips to get me started?

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]












Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
2
Hi All,



We have customized the Project Entry screen to meet our needs.

One of the requirements was to connect Customer Contacts to a Project.



I am storing these Contacts in the UD04 table.

What I'd like to do is only store the CustNum, ShipToNum, and ConNum in
UD40 and then pull, in real-time, the details for the contact.

In SQL terms, I'd join UD40 to Customer and CustCnt then display my
results.



Is this possible to do in a customization and display the results in a
EpiUltraGrid?

If so, any examples to tips to get me started?










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.


[Non-text portions of this message have been removed]
3
Can't you join in the UD04 table through the wizard? And then you have
access to this table.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Joe Rojas
Sent: Tuesday, May 04, 2010 3:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Customization - Display "Query" or Combination of
dataViews in an EpiUltraGrid





Hi All,

We have customized the Project Entry screen to meet our needs.

One of the requirements was to connect Customer Contacts to a Project.

I am storing these Contacts in the UD04 table.

What I'd like to do is only store the CustNum, ShipToNum, and ConNum in
UD40 and then pull, in real-time, the details for the contact.

In SQL terms, I'd join UD40 to Customer and CustCnt then display my
results.

Is this possible to do in a customization and display the results in a
EpiUltraGrid?

If so, any examples to tips to get me started?







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-1264 | fax: 781-341-5694
jrojas@... <mailto:jrojas%40matsinc.com> | www.matsinc.com Ask
us about our clean, green and beautiful matting and flooring

This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]