How to exclude a list of specific items from Solr search results

I’m pretty sure that happens to you to look for items that match specific criteria except  few specific ones. We all have friends that don’t  know what they want, but they know what they don’t want. (I love you baby).

In my case, the client wanted a list of case studies specific to an  industry except those that the visitor already saw.  The first thought is to get results from Solr and then filter those already seen. But what about metadata that helps us implement paging, or just get  first 10 items ? Do we need another query ? Tee answer is to sent exclusion param with our query .

Continue reading

Switch Solr indexes on Rebuild

The content rendered on the Website should not be affected by index rebuild. A solution to that is to setup Solr in a way that it will rebuild an index in a separate core so that the rebuilding does not affect the search index that is currently used. Once the rebuilding and the optimization of the index completes, Sitecore switches the two cores, and the rebuilt and optimized index is used.

I will describe the implementation steps with Sitecore 8.2 and Solr 5.3.1. I don’t expect this to be different with newer version.

Continue reading

Sitecore 8.2 Rendering Issues

We experienced issues with shared layout on few of our pages. Presentation assembling seemed not following Presentation Detail Information Flow.

Based on Sitecore documentation this is a flow



  • SharedLayout option uses __Rendering field
  • FinalLayout option uses __Final Rendering field
  • Going from right to left, if a field has a layout delta, it goes to the field to its left to gather more presentation information.

After the investigation we noticed that on Save Button click in Experience Editor, the full share layout is saved and not the delta in __rendering fields. ( in case when a page is inheriting renderings from standards values).

Sitecore provided us with a patch. You can request one – the reference number is 144214

Is your xDB Cloud Consumption plan right for you ?

When I join my current project first thing I did as architect is an audit.  Make sure that architecture is optimized for current traffic and all best practices has been followed.  The client website use Sitecore xDB Cloud with xDB Plus subscription. It allows you up to 250 000 contacts at anytime and up to 2 500 000 interactions per month.


How it’s measured: Total identified contact stored at any time.


How it’s measured: Net new interaction created in a given period of time.

I check our current consumption to find out that we can switch to xDB base subscription and pay 30% of what are paying right now.

In some cases you better pay overage price before switch to the next subscription plan.

2017-10-24 11_42_15-xDB - Sales Enablement - March 2015 V2.pptx [Protected View] - PowerPoint

In case you want to generate your own reports or load data directly from mongo, you can access to your xDB database using and mongo viewer application.
Open your connectionstrings.config file and find the “analytics” connection string:
You have replicaset on XdbCloud so use the host1 and port1 to connect.
Set up values in the following way:

con 2

con 2

But the best approche is to use  sitecore xDB Cloud API


  • licenseId – your Sitecore license ID
  • deploymentId – the unique identification of the deployment
  • year – the consumption year
  • month – the consumption month


To ensure that your customers only access their own xDB sets, you must use a valid authentication token whenever you make a call to the xDB Cloud API. You can generate these tokens by using a valid Sitecore license file to call the SSO Encode Sitecore License endpoint. You must include the generated token as a HTTP header in all other requests called X-ScS-Nexus-Auth.

Visit this page -> xDB Cloud Consumption

Create dynamic menu with page sections

Since Sitecore Habitat has been released I was looking for a Helix based solution which can be use for Greenfield project. Once again – Habitat is only an example of project implementing Helix architecture.  I looked at Helixbase and I tried to  implement one of bootstrap free template sites to evaluate it as a candidate.


I thought it would be nice to add automatically to the menu new section item each time that editor is adding a new one and create an anchor to that section.


@model RenderingModel
 var currentItem = Sitecore.Context.Item;
 RenderingReference[] myRenderings = currentItem.Visualization.GetRenderings(Sitecore.Context.Device, true);
 var layoutField = new LayoutField(currentItem);
 LayoutDefinition layoutDef = LayoutDefinition.Parse(layoutField.Value);
 DeviceDefinition deviceDef = layoutDef.GetDevice(Sitecore.Context.Device.ID.ToString());
 string sectionId = string.Empty;

<!-- Collect the nav links, forms, and other content for toggling -->

<!-- /.navbar-collapse -->

Dynamic Multi Layer Image using Sitecore Custom Handler

In a few Sitecore projects that I was working on, we needed an image based on unlimited combination of sub layers.

For example, for one of our clients, on every product page, we had an image with a map of the United States and Canada with highlighted regions where their products were available (see image below). To render this map and generate the image on the fly, we needed a mechanism. We couldn’t afford to have combinations for each 50 states, 10 provinces and 3 territories.

regional availability

Map of North America with Highlighted Regions

In order to display this image I had to identify the regions to be highlighted as a parameter.

<img src="/~/map/all,ca_quebec,ca_atlantic,ca_ontario,ca_western,us_west,us_north_west,us_south_west,us_central,us_north_east,South%20East.jpg" alt="">

Another example is a shower configuration tool. For the customers/end-users, our vision was to create an immersive, engaging and personalized user experience with the shower/tub shower configuration tool (see pictures below). Users can thus build their dream shower by using all available parts and preview it in real time while building their shopping list. Once again, think about all the variants involved to be combined (bases, tiles on the wall, and shower doors).

Here is a solution that I came with in order to ease the code and save time :

Register a new custom handler

1.       Add a new custom handler configuration into node

      <handler trigger="~/map/" handler="maax_map.ashx"/>

2.  Add a new custom handler configuration into handlers node

   <add verb="*" path="maax_map.ashx" type="Maax.Classes.ImageHandler, MaaxWebsite" name="Maax.ImageHandler" />

3.Add custom halnder into node

 <add verb="*" path="maax_map.ashx" type="Maax.Classes.ImageHandler, MaaxWebsite" />

4. Code your own handler

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Collections;
using System.IO;
using System.Web.SessionState;
using System.Drawing;
using System.Drawing.Imaging;

using Sitecore.Data.Items;
using Sitecore.Data.Fields;

namespace Maax.Classes
    public class ImageHandler : IHttpHandler, IRequiresSessionState
        private const string sessionMAP = "MAP";
        private string XLen = "110";
        private string YLen = "110";

        /// <summary>
        /// Get All Regions
        /// </summary>
        public List<Item> AllRegions
                string query = "/sitecore/content/Meta-Data/Regional Contacts/Regions/*";
                return MaaxProductRepository.CurrentDatabase.SelectItems(query).ToList();

        #region IHttpHandler Members

        public bool IsReusable
            get { return true; }
        /// <summary>
        /// Respond to all request of /~/map/  This params is set in web.config file
        /// </summary>
        /// <param name="context"></param>
        public void ProcessRequest(HttpContext context)
            //Hashtable used to store images created on the fly in session to be reuse later
            Hashtable ht;

            if (context.Request.FilePath != null)
                //extract of the key from url t
                string key = context.Request.FilePath.Substring(7, (context.Request.FilePath.Length - 11));

                if (context.Session[sessionMAP] != null)
                    //check if hashtable allready exist in session
                    ht = (Hashtable)context.Session[sessionMAP];
                    if (!ht.ContainsKey(key))
                        byte[] bitmapData = CreateImage(key);
                        ht.Add(key, bitmapData);
                else//if not we have to create it
                    ht = new Hashtable();
                    byte[] bitmapData = CreateImage(key);
                    ht.Add(key, bitmapData);
                    context.Session[sessionMAP] = ht;


                Byte[] arrImg = (byte[])ht[key];
                if (arrImg != null)
                    context.Response.ContentType = "image/jpeg";
        /// <summary>
        /// Create map image based on regions keyes
        /// </summary>
        /// <param name="key"></param>
        /// <returns>JPEG image in binairies array</returns>
        private byte[] CreateImage(string key)

                string[] regions = key.Split(',');
                string background = regions[0];
                //verifying dimention of background image

                Item itm = AllRegions.First(s => s["Code"] == background);
                ImageField backgroundImageField = itm.Fields["ImageOverlay"];
                int width = int.Parse(backgroundImageField.Width);
                int hight = int.Parse(backgroundImageField.Height);

                using (Bitmap bit = new Bitmap(width, hight))
                    Graphics g = Graphics.FromImage(bit);
                    // fill with background

                    foreach (string region in regions)
                        //extraction png images from region item
                        Item found = AllRegions.First(s => s["Code"] == region);
                        ImageField imageField = found.Fields["ImageOverlay"];
                        MediaItem mediaItem = imageField.MediaItem;
                        if (mediaItem != null)
                            Stream fStream = mediaItem.GetMediaStream();
                            if (fStream != null)
                                //drawing region image on background
                                Image img = Image.FromStream(fStream);
                                g.DrawImage(img, 0, 0, width, hight);


                    MemoryStream ms = new MemoryStream();
                    bit.Save(ms, ImageFormat.Jpeg);

                    byte[] bitmapData = ms.ToArray();
                    return bitmapData;
                return null;