Questions tagged [sitecore-query]

For questions related to the syntax of and issues with Sitecore Query notation

Filter by
Sorted by
Tagged with
5
votes
2answers
3k views

Why we should not use fast queries in Sitecore

As per blogs and best practices of Sitecore, its advised that fast queries should be avoided. The reason for that is fast queries will directly access the DB and fetch the results which causes ...
8
votes
2answers
9k views

Get all Children in the order defined in Sitecore

I have following structure in sitecore > Country > India > Srilanka > Bangladesh The following query returns all the child items but in alphabetical order string ...
6
votes
4answers
1k views

Sitecore Query fails - “::” expected at position 92

The below query fails and throws exception. /sitecore/content/Abcdef/Sites/WXYZ/MNO/Application Contexts/Connect On Demand/Sections/Self Service/* returns "::" expected at position 92. where as I am ...
1
vote
1answer
483 views

Sitecore hosting on AWS with Blue/Green deployment for zero downtime

We are currently having Sitecore 8.2 update 6 runs on AWS. We are planning to implement Blue/Green deployment for zero downtime and disaster recovery. The plan is to have 2 set environments as Blue ...
1
vote
1answer
906 views

How to query multiple datasources & multiple templates in sitecore query

The content tree is as follows: sitecore |_content |_Site1 |_Home |_Articles |_Category |_article1 |_article2 |_Site2 |_Home |_Rewards |...
7
votes
2answers
626 views

Is there a way to reference another database in Multilist with Search

I created a user content generated database in Sitecore where I will store my users and their comments. I plan to have a subscriptions item bucket that will be stored in the web database (published ...
5
votes
1answer
494 views

Sitecore Query - Restrict to context Language (in RSS feeds)?

I am using Sitecore's RSS feed, which has a field for Items. You can set this field to a Sitecore query to find items within your website to show within your RSS feed. I have it configured like so: ...
2
votes
1answer
561 views

Where to find Visit Duration and Latest Date Visited in Code Behind

I am creating a process that reads in the Sitecore analytics contact collection and gets information needed for a report. It is read and inserted in SQL Server. Not sure how to get some of the fields ...
4
votes
1answer
1k views

How to Join MongoDb Collections Using Sitecore Mongo Db Report Data Source

Am using sitecore 8.0, below code gets the analytics from the mongo db. I have two collections "ineractions" and "ContactId", I want to join both the collections using common field "contact" from ...
0
votes
1answer
751 views

Multi-root treelist with queries

I'm trying to use the Multi-root treelist that Kam Figy made and that Zachary Kniebel extended. I used this guide to add the Field-type to the Core database. All is well, until I put query: anywhere ...