Fredhopper ResultSet value fetched as null In SmartTarget JAVA API

Question

I am trying to fetch the content from Fredhopper by using the SmartTarget 2014 Java API. After going through the documentation, I have followed two approaches as below :

        ClaimStore claims = AmbientDataContext.getCurrentClaimStore();
        if (claims != null) {

            Map<URI, Object> x = claims.getAll();
            for (Map.Entry<URI, Object> entry : x.entrySet()) {
                System.out.println("\"KEY\"  " + entry.getKey()
                        + " \"Value\"  " + entry.getValue());

            }
        }


        String triggers = AmbientDataHelper.getTriggers(claims);
        System.out.println(triggers);

//Approach 1

        QueryBuilder builder = new QueryBuilder();
        builder.setMaxItems(2);
        builder.addCriteria(new RegionCriteria("Homepage Promotions"));
        builder.addCriteria(new PublicationCriteria(new TcmUri("tcm:0-69-1")));
        builder.parseQueryString(triggers);
        ResultSet fredHopperResultset = builder.execute();
        System.out.println(fredHopperResultset);
        List<Promotion> promoList = fredHopperResultset.getPromotions();

        for (Iterator iterator = promoList.iterator(); iterator.hasNext();) {
            Promotion promotion = (Promotion) iterator.next();

            List<Item> itemList = promotion.getItems();
            for (Item loopItem : itemList) {
                System.out.println(loopItem.getPromotionID());
            }
        }

//Approach 2

        Query query = QueryFactory.createInstance();

        ResultSet rs = query.execute("fh_location=//catalog01/en_US/categories<{catalog01_tcm_0_69_1}&st_region=Homepage Promotions", "", "&sc_refererdomain=www.philips.com&st_publication=tcm:0-69-1");

        System.out.println(rs.getName());

        System.out.println(rs.getPromotions().size());

         Promotion promo = rs.getPromotions().get(0);
         for (Item item : promo.getItems()) {
             System.out.println(item.getId() + item.getPromotionID()); 
         }
        System.out.println(rs.getItemsTotalCount());

I am able to print the values of Triggers and Claims sucessfully. While with Approach 1, I am getting the value of Fredhopper Resultset as Null. On accessing the logs, "SortFieldFilter.java:38 50180 Removing the field 'publicationtitle' from the sort fields. Sorting on non-live attributes is not supported. Please include this field in the tree attributes in order to sort on it".

While in approach 2, I am not getting data as expected based on the trigger-types parameters passed. Kindly provide some pointers on where I am going wrong.

Thanks.

Answer 1

I recommend using the QueryBuilder as in approach #1.

If the resultset is actually null, there was an error executing the query. It could be a timeout or a problem connecting to Fredhopper in the first place.

In any case, to find the root of your issue you should check the SmartTarget log files (not just the Fredhopper log files). Any errors will always be logged, but if the problem is just with the results not being as expected you can increase the log level to DEBUG and it will show the query that is being executed. You can then compare that to the query executed in the preview window of the Business Manager when looking at the results you want.

Answer 2

Approach one and two do very different things. The latter contains keywords and the first does not.

Approach 1:

The rs variable (one of the result sets) will never get promotions cause there is no region our publication id set.

The first fredHopperResultSet is loaded when again there is no region or publication id set on the query, so do not expect any promotions either.

The second fredHopperResultSet could contain promotions which are retrieved with getPromotions(). This is because the region and publication id are set with builder.addCriteria(). Of course there should be some matching promotions set up in SmartTarget. For troubleshooting you can set up a promotion on the Homepage Promotions region in publication tcm:0-69-1 whith no triggers set. The promotion will then always return, a great way to test if the web application can actually retrieve any promotions.

By the way, fredHopperResultset is declared twice, the code in Approach 1 will not work.