Value of a Custom Field that works with LUT (PS2007)

[asadim]

How do I get the value of a CF that is associated with a LookUp Table? I know
how to get the TEXT_VALUE for a non-LUT CF (using
ProjectDataSet.TaskCustomFieldsRow) but seems like there's a different class
or something that deals with CFs that work with LUTs.

I am programming using PSI in C#. Thanks.

 

[Sharry Heberer [MSFT]]

The column in a DataSet table (like TaskCustomFields or
ResourceCustomFields, for instance) would be CODE_VALUE. That CODE_VALUE
will correspond to a LUT member UID.

Hope this helps,
Sharry

 

[asadim]

Thanks alot Sharry. I am having difficulties using the CODE_VALUE to retrieve
the value of the CF that is associated with the LUT.

I have tried the following (with no luck):
Guid[] lutCode = new Guid[1];
lutCode[0] = r.CODE_VALUE;
lutds = lut.ReadLookupTablesByUids(lutCode, false, 1033);

r is a TaskCustomFieldsRow & lutds is a LookupTable DataSet.

Please advise. Thanks.

 

[Sharry Heberer [MSFT]]

You need to find the LT *struct* that is the same as the CODE_VALUE. The
LT_UID is the Guid for the entire LT. You want to match CODE_VALUE to
LT_STRUCT_UID in the LookupTableDataSet.LookupTableTrees table (use
ReadLookupTables in the LookupTables PSI to populate the DataSet). I looked
briefly, but couldn't find a method to retrieve a single LT member/struct,
so you may need to do some looping and/or filtering to get this data.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Thanks alot Sharry. I am having difficulties using the CODE_VALUE to
retrieve
the value of the CF that is associated with the LUT.

I have tried the following (with no luck):
Guid[] lutCode = new Guid[1];
lutCode[0] = r.CODE_VALUE;
lutds = lut.ReadLookupTablesByUids(lutCode, false, 1033);

r is a TaskCustomFieldsRow & lutds is a LookupTable DataSet.

Please advise. Thanks.

The column in a DataSet table (like TaskCustomFields or
ResourceCustomFields, for instance) would be CODE_VALUE. That CODE_VALUE
will correspond to a LUT member UID.

Hope this helps,
Sharry

--
This posting is provided "AS IS" with no warranties, and confers no
rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

 

[asadim]

Excellent! Thank you Sharry.

You need to find the LT *struct* that is the same as the CODE_VALUE. The
LT_UID is the Guid for the entire LT. You want to match CODE_VALUE to
LT_STRUCT_UID in the LookupTableDataSet.LookupTableTrees table (use
ReadLookupTables in the LookupTables PSI to populate the DataSet). I looked
briefly, but couldn't find a method to retrieve a single LT member/struct,
so you may need to do some looping and/or filtering to get this data.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Thanks alot Sharry. I am having difficulties using the CODE_VALUE to
retrieve
the value of the CF that is associated with the LUT.

I have tried the following (with no luck):
Guid[] lutCode = new Guid[1];
lutCode[0] = r.CODE_VALUE;
lutds = lut.ReadLookupTablesByUids(lutCode, false, 1033);

r is a TaskCustomFieldsRow & lutds is a LookupTable DataSet.

Please advise. Thanks.

The column in a DataSet table (like TaskCustomFields or
ResourceCustomFields, for instance) would be CODE_VALUE. That CODE_VALUE
will correspond to a LUT member UID.

Hope this helps,
Sharry

--
This posting is provided "AS IS" with no warranties, and confers no
rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

How do I get the value of a CF that is associated with a LookUp Table?
I
know
how to get the TEXT_VALUE for a non-LUT CF (using
ProjectDataSet.TaskCustomFieldsRow) but seems like there's a different
class
or something that deals with CFs that work with LUTs.

I am programming using PSI in C#. Thanks.

 

[Sharry Heberer [MSFT]]

Sure, no problem - glad I could help! I didn't actually code this out
myself, so if you have more troubles, just post back and I can review my
advice for um... "issues."

--
This posting is provided "AS IS" with no warranties, and confers no rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Excellent! Thank you Sharry.

You need to find the LT *struct* that is the same as the CODE_VALUE. The
LT_UID is the Guid for the entire LT. You want to match CODE_VALUE to
LT_STRUCT_UID in the LookupTableDataSet.LookupTableTrees table (use
ReadLookupTables in the LookupTables PSI to populate the DataSet). I
looked
briefly, but couldn't find a method to retrieve a single LT
member/struct,
so you may need to do some looping and/or filtering to get this data.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Thanks alot Sharry. I am having difficulties using the CODE_VALUE to
retrieve
the value of the CF that is associated with the LUT.

I have tried the following (with no luck):
Guid[] lutCode = new Guid[1];
lutCode[0] = r.CODE_VALUE;
lutds = lut.ReadLookupTablesByUids(lutCode, false, 1033);

r is a TaskCustomFieldsRow & lutds is a LookupTable DataSet.

Please advise. Thanks.


:

The column in a DataSet table (like TaskCustomFields or
ResourceCustomFields, for instance) would be CODE_VALUE. That
CODE_VALUE
will correspond to a LUT member UID.

Hope this helps,
Sharry

--
This posting is provided "AS IS" with no warranties, and confers no
rights.

Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

How do I get the value of a CF that is associated with a LookUp
Table?
I
know
how to get the TEXT_VALUE for a non-LUT CF (using
ProjectDataSet.TaskCustomFieldsRow) but seems like there's a
different
class
or something that deals with CFs that work with LUTs.

I am programming using PSI in C#. Thanks.

 

[Shashank Dubey]

We Have Requirements with One of Our Direct Client in Washington . Please Let Me Know If You Have Any Good Resource

Requirment No.1

Role: Senior Developer
Location: Redmond, Washington
Client : Direct
Duration: 12 months (On going)
Start Date: within next 2 weeks
Rate: Depend on experince

Required Skills: CSF, HMC, BizTalk and .Net
Experience Description
· 5+ years of experience
· Should have sound knowledge on MPS namespace in HMC.
· Should be able to write Adaptors for BizTalk.
Requirment No.2

Role: Senior Developer
Location: Redmond, Washington
Client : Direct
Duration: 12 months (On going)
Start Date: within next 2 weeks
Rate: Depend on experince
Required Skills: BizTalk, SharePoint and .Net
Experience Description
· 5+ years of experience
· Should have sound experience in BizTalk and Share point.
· Should be able to write Adaptors for BizTalk
Please let me know if you are comfortable with all the skills my client is looking for and if you would like to go ahead with his assignment, let me have your Updated Resume in word format and also let me know the rates you would be looking for along with your availability status
We Are Working On All Verticals Requirements at A Time …If You Are Not Interested At This Point Of Time Let Me Have Your Resume … I Will Be Pleased To Submit You… Accordingly.

Thank You,
Regards
Shashank Dubey
Compunnel Software Group Inc
12 Perrine Road, Suite # 104 Monmouth Jn., NJ 08852
Voice: 609-606-9010 Ext.1351 | Fax: 609-228-4161
Toll Free: (800) 696-8128
E-mail: (e-mail address removed) | --------------------------------------------
Disclaimer:
This is not an unsolicited mail. Under Bills.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you have received this mail in error please notify by replying with a "REMOVE" in subject line.




EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com