Search a resource Uid by the value of a custom field.

• Friday, April 13, 2012 9:19 AM

   

   
  

  0

  Hi everybody,

  I have some enterprise resources created and a custom field called resourceId for each one. I'm trying to get the RES_UID value but the dataset always get null value. Here I paste the code, can anyone tell me what was wrong?

  // Function that returns the Uid for a enterprise custom field
  Guid? customFieldUId = GetCustomFieldUIdByName("resourceId", EntityTypes.Recursos);
  
  ResourceWebSvc.ResourceDataSet resourceDs = new ResourceWebSvc.ResourceDataSet();
  string tableName = resourceDs.ResourceCustomFields.TableName;
  string cfUidColumn = resourceDs.ResourceCustomFields.MD_PROP_UIDColumn.ColumnName;
  string valueColumn = resourceDs.ResourceCustomFields.NUM_VALUEColumn.ColumnName;
  string resUidColumn = resourceDs.ResourceCustomFields.RES_UIDColumn.ColumnName;
  
  PSLibrary.Filter.FieldOperationType equal = PSLibrary.Filter.FieldOperationType.Equal;
  PSLibrary.Filter.LogicalOperationType and = PSLibrary.Filter.LogicalOperationType.And;
  
  PSLibrary.Filter resourceFilter = new PSLibrary.Filter();
  resourceFilter.FilterTableName = tableName;
  
  resourceFilter.Fields.Add(new PSLibrary.Filter.Field(resUidColumn));
              
  PSLibrary.Filter.FieldOperator byCustomFieldUid = new PSLibrary.Filter.FieldOperator(equal, cfUidColumn, customFieldUId);
  PSLibrary.Filter.FieldOperator byIdRecurso = new PSLibrary.Filter.FieldOperator(equal, valueColumn, idRecurso);
  resourceFilter.Criteria = new PSLibrary.Filter.LogicalOperator(and, byCustomFieldUid, byIdRecurso);
  
  resourceDs = resourceSVC.ReadResources(resourceFilter.GetXml(), false);
  // After this, resourceDs is always null 

  Thank you in advanced!

  • Reply
  • Quote