Does any body know how to get the property Id in T-SQL? this is how I do it on Umbraco API. I want the process to be done on store procedure for a good reason.
Thanks,
Simiplicio
DocumentType documentType = DocumentType.GetByAlias("Employee");
PropertyType propertyMobileNum = documentType.getPropertyType("MobileNumber");
int ix=propertyMobileNum.Id;
I thinks this one will do. Le me know if this one is not the rigth way. thanks
declare @PropertyIdMobile int
declare @ContentTypeIdEmployee int
SELECT @ContentTypeIdEmployee =nodeId
FROM cmsContentType
where Alias='Employee'
SELECT @PropertyIdMobile=ID
FROM cmsPropertyType
where Alias='MobileNum' and contentTypeId=@ContentTypeIdEmployee
PropertyType & ID on T-SQL
Hi Guys,
Does any body know how to get the property Id in T-SQL? this is how I do it on Umbraco API. I want the process to be done on store procedure for a good reason.
Thanks,
Simiplicio
DocumentType documentType = DocumentType.GetByAlias("Employee"); PropertyType propertyMobileNum = documentType.getPropertyType("MobileNumber"); int ix=propertyMobileNum.Id;I thinks this one will do. Le me know if this one is not the rigth way. thanks
is working on a reply...