I believe there is an issue with the stored procedure DMX_GetCategoryByName. In it, there is an INNER JOIN dbo.DMX_CategoriesML cl ON c.CategoryId=cl.CategoryId AND cl.Locale=@Locale.
This causes the query to return no values unless there is a corresponding entry in DMX_CategoriesML which is not always the case.
To provide some context, I am using the following code block to populate a dropdown with a list of subcategories based on a category name. The only way I was able to get this to work is to change the above relationship to a left join. I believe this is correct based upon the logic in other similar SPs such as DMX_GetSubCategories which joins the same tables but uses a left join.
-------------------------------------
int industries = CategoriesController.GetCategoryByName(PortalId, "Industries", string.Empty).CategoryId;
ddlIndustries.DataValueField = "CategoryId";
ddlIndustries.DataTextField = "CategoryName";
ddlIndustries.DataSource = CategoriesController.GetSubCategories(PortalId, industries, System.Threading.Thread.CurrentThread.CurrentCulture.Name);
ddlIndustries.DataBind();
ddlIndustries.Items.Insert(0, "All Industries");
}
-------------------------------------------
I was hoping to get your thoughts on whether this is an actual issue with that query or if I'm misinterpreting how to use that. I'm updating a custom document list module we have built to work in DMX 6 and ran into this issue after working in the new API. |