C:/Data/Projects/MCS EPM Global Practice/Frameworks/Public/mpfX/1.0/Libraries/Mcs.Epm.MicrosoftProject.mpFx/LookupTableFilters.cs

/*  ----------------------------------------------------------------------------
 *  Microsoft Corporation
 *  ----------------------------------------------------------------------------
 *  Microsoft Project Server mpFx (mpFx)
 *  ----------------------------------------------------------------------------
 *  Author: Colby Africa
 *  ----------------------------------------------------------------------------
 *  License: http://code.msdn.microsoft.com/mpFx/Project/License.aspx
 *  ----------------------------------------------------------------------------
 */

using System;
using Mcs.Epm.MicrosoftProject.mpFx.LookupTablesWebService;
using Microsoft.Office.Project.Server.Library;

namespace Mcs.Epm.MicrosoftProject.mpFx
{
    /// <summary>
    /// Create commonly used filters for lookup table information 
    /// </summary>
    public static class LookupTableFilters
    {
        /// <summary>
        /// Create a filter of basic lookup table columns
        /// </summary>
        /// <param name="lookupTableGuid">The lookup table's GUID</param>
        /// <returns>Filter string</returns>
        public static string ItemBasicInformation(Guid lookupTableGuid)
        {
            Filter filter = new Filter();

            using (LookupTableMultiLangDataSet lookupTable = new LookupTableMultiLangDataSet())
            {
                filter.FilterTableName = lookupTable.LookupTableValues.TableName;
                filter.Fields.Add(new Filter.Field(lookupTable.LookupTableValues.LT_UIDColumn.ColumnName));
                filter.Fields.Add(new Filter.Field(lookupTable.LookupTableValues.LT_STRUCT_UIDColumn.ColumnName));
                filter.Fields.Add(new Filter.Field(lookupTable.LookupTableValues.LT_VALUE_TEXTColumn.ColumnName));

                Filter.FieldOperator equalUID =
                    new Filter.FieldOperator(Filter.FieldOperationType.Equal,
                                             lookupTable.LookupTableValues.LT_UIDColumn.ColumnName, lookupTableGuid);
                filter.Criteria = equalUID;
                return filter.GetXml();
            }                
       }
    }
}

---