SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
i have a TergmGroup and under this a TermSet called "Automotive". Under this TermSet i have hierarchical Terms. How can i "query" the terms under this TermSet for two Custom Properties?
I have the following Custom Properties set for each Term in my TermStore:
ID
MODEL
I want something like this:
SELECT * FROM TERMSET-AUTOMOTIVE
WHERE CUSTOM-PROPERTY-ID = 12 AND CUSTOM-PROPERTY-MODEL = "S600"
How could i achieve this?
Something like this has worked for me:
TaxonomySession taxSession = new TaxonomySession(rootSite);
TermStore termStore = taxSession.TermStores.DefaultIfEmpty(null).FirstOrDefault(x => x.Name == managedMetadataServiceName);
Group termGroup = termStore.Groups.DefaultIfEmpty(null).FirstOrDefault(x => x.Name == managedMetadataGroupName);
TermSet termSet = termGroup.TermSets.DefaultIfEmpty(null).FirstOrDefault(x => x.Name == managedMetadataTermSetName);
...and then you can iterate through the termset using Linq if you want with the criteria you have. For instance (this is untested code so bear with me; the pseudo-code is really what you should be interested in):
List<Term> termList = termSet.FindAll(x => x.LocalCustomProperties["ID"] == "12" && x.LocalCustomProperties["Model"] == "S600");
A couple things to note: - The LocalCustomProperties bag stores everything as a string, so if you want to do numerical work with them, you have to convert them first. - If you've set up a term hierarchy within the termset (for instance, you have 25 items under Nissan and 40 under Honda), you'd need to set up a function to run that last statement recursively to build the list.
