Find sitecore items with a specific OMS profile? -


i have find items in sitecore (or rather, in contents) have oms (marketing suite) profile checked in "tracking" attribute. tracking attribute appears stored xml , has raw value like

<tracking>   <profile name="widdly scuds"><!-- irrelevant keys... --></profile> </tracking> 

and need fetch, example, items "widdly scuds" profile.

the first solution thought of fast query on tracking attribute. sitecore query or xml have crawl entire contents each time, probably unacceptably slow, i'll try if there no alternatives.

this first fast query tried:

fast://*[@tracking = '%widdly scuds%'] 

but returns 0 results. tried this:

fast://*[@tracking = '<tra%'] 

and (which match names of many of profiles:

fast://*[@tracking = '%a%'] 

and returns 0 results. i'm not how tracking stored or queried, appears unusual since can't results means.

the query needs fast enough run few dozen times during short page rendering (probably not more 20-30 seconds). results can cached awhile, not long. front page of section of site i'm working on needs display item count each profile i'm querying, , there be, maybe, 50-ish profiles.

so, how items marketing profile?

edit: ended using lucene. details of adventure appear in future questions, maybe...

if use query or iterate descendants, avoid starting query / if possible - start equivalent of /sitecore/content/someitem.

another approach use lucene or other search index. see sitecore reference more info.


Comments

Popular posts from this blog

ASP.NET/SQL find the element ID and update database -

jquery - appear modal windows bottom -

c++ - Compiling static TagLib 1.6.3 libraries for Windows -