E10 sql query for table & corresponding UD table

Yahoo Archive
1
Thanks!

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 17, 2015 4:31 PM
To: Vantage
Subject: Re: [Vantage] Re: E10 sql query for table & corresponding UD table


You can run SELECT * FROM Part (no Erp.) it will use the combined view


Jose C Gomez
Software Engineer

T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/>

Quis custodiet ipsos custodes?

On Wed, Jun 17, 2015 at 5:21 PM, jckinneman@...<mailto:jckinneman@...> [vantage] <vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> wrote:


There is a view that combines the two tables for you. View will have same name as the primary table. View only exists if there is a UD table partner.

Jim Kinneman
Encompass Solutions, Inc




[Non-text portions of this message have been removed]
2
What are folks using out there for syntax if any when you want to look at the part table along with all the UD fields like we used to be able to do it in versions 9 or earlier(other than hammering in every field individually). Just curious.

Select * from Erp.Part doesn't obviously bring in anything from Erp.Part_UD but a select * on two joined tables isn't the method either?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>



[Non-text portions of this message have been removed]
3
Never mind...

select * from Erp.part
inner join Erp.Part_UD on part.SysRowID = Part_UD.ForeignSysRowID


Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, June 17, 2015 4:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E10 sql query for table & corresponding UD table



What are folks using out there for syntax if any when you want to look at the part table along with all the UD fields like we used to be able to do it in versions 9 or earlier(other than hammering in every field individually). Just curious.

Select * from Erp.Part doesn't obviously bring in anything from Erp.Part_UD but a select * on two joined tables isn't the method either?

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

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



[Non-text portions of this message have been removed]
4
There is a view that combines the two tables for you.  View will have same name as the primary table.  View only exists if there is a UD table partner.

Jim Kinneman
Encompass Solutions, Inc
5
You can run SELECT * FROM Part (no Erp.) it will use the combined viewÂ


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Wed, Jun 17, 2015 at 5:21 PM, jckinneman@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>There is a view that combines the two tables for you.  View will have same name as the primary table.  View only exists if there is a UD table partner.</p><div><br></div><div>Jim Kinneman</div><div>Encompass Solutions, Inc</div><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>