E10 and UD fields

Yahoo Archive
1
ah I just went back through your email if you are doing a GetList then your UD fields are not available. Change it to GetRows.l;=


Jose C Gomez
Software Engineer



T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Fri, Aug 8, 2014 at 5:29 PM, don.n.doan@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>Case doesn&#39;t seem to be an issue.  It&#39;s exactly as shown in the DB/BAQ ect..  BAQ accepts the field fine and the object explorer also shows it.  I&#39;m thinking I&#39;m calling the wrong adapter(maybe this one doesn&#39;t include UD?) or I&#39;m missing something in the whereclause quotes to notify that its on the Part_UD table. </p>



</div>
 


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

2

Does anyone know how to write to the UD fields?

C# E10.


adapterSalesOrder.SalesOrderData.OrderHed[0].Date01 = (System.DateTime)Project_DataView[0]["Date01"];


3
In a customization? Just use the array myobject["CustomField"]= xx;


Though if all your Model is up to date you should be able to just use myObject.UDField





Jose C Gomez

Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Tue, Jul 29, 2014 at 4:11 PM, don.n.doan@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p></p><p>Does anyone know how to write to the UD fields?</p><p>C# E10.</p><p><br></p><p><span>adapterSalesOrder.SalesOrderData.OrderHed[0].Date01 = (System.DateTime)Project_DataView[0][&quot;Date01&quot;];<br></span></p>



</div>
 


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

4
Easy enough.  I knew it was just something simple like that.  Thanks Jose.
5
i'm running into another issue with these UD fields.  I'm trying to apply a whereclause on a part adapter list lookup.  

whereclause = "checkbox01 = 1".  

I'm getting an invalid column error.  I have the field on extended UD and the tables are sync'd and data model is up to date.  Any suggestions would be appreciated.  

Thanks!
6

Try = true instead of 1?

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, August 08, 2014 2:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10 and UD fields

 

 

i'm running into another issue with these UD fields.  I'm trying to apply a whereclause on a part adapter list lookup.  

 

whereclause = "checkbox01 = 1".  

 

I'm getting an invalid column error.  I have the field on extended UD and the tables are sync'd and data model is up to date.  Any suggestions would be appreciated.  

 

Thanks!

7
Also make sure its not CheckBox01_cÂ


Jose C Gomez

Software Engineer


T: 904.469.1524 mobile

E: jose@…

http://www.josecgomez.com
     Â


Quis custodiet ipsos custodes?


On Fri, Aug 8, 2014 at 3:51 PM, Karen Schoenung kschoenung@... [vantage] <vantage@yahoogroups.com> wrote:

 
<div>
  
  
  <p>

Try = true instead of 1?

Â

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, August 08, 2014 2:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: E10 and UD fields

Â

Â

i'm running into another issue with these UD fields. Â I'm trying to apply a whereclause on a part adapter list lookup. Â

Â

whereclause = "checkbox01 = 1". Â

Â

I'm getting an invalid column error. Â I have the field on extended UD and the tables are sync'd and data model is up to date. Â Any suggestions would be appreciated. Â

Â

Thanks!

</div>
 


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

8
No luck Karen,  I still get the same exact error.

Jose, I'm not completely sure what you mean.
9
Check the case of the name of the field, in a few places I have seen not having the case of the name correct causes a problem.  So if the definition is CheckBox01 make sure any reference you have to it matches and isn't something like checkbox01.

You can also check and see if the field is there by looking at the epidataview on the object explorer.  The field should show up there.  If you aren't in a screen that has a sales dataview you can open up sales order entry in developer mode and take a look.

Another check is to try running a BAQ against the UD field, the BAQ will typically complain if the field isn't setup all the way.

If it doesn't show up in the dataview or the BAQ complains you need to run regenerate database again. You sometimes have to do an IISReset after running database regenerate also.

Jim Kinneman
Encompass Solutions, Inc
10
Case doesn't seem to be an issue.  It's exactly as shown in the DB/BAQ ect..  BAQ accepts the field fine and the object explorer also shows it.  I'm thinking I'm calling the wrong adapter(maybe this one doesn't include UD?) or I'm missing something in the whereclause quotes to notify that its on the Part_UD table.