We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [query]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
4
votes
0answers
24 views

SmartTarget Promotion Query Randomly Throws Exception

We have SmartTarget implemented on a page which has multiple regions. To facilitate this we have multiple SmartTarget query tags sitting on the .jsp page to perform the queries and fill in the page ...
1
vote
2answers
78 views

Given a TCM ID, how do I get that Component?

I have used the TaxonomyFactory to get keywords: var taxonomyUri = "tcm:304-4135-512"; var model = _taxonomyFactory.GetTaxonomyKeywords(taxonomyUri); This gives me a response like: { "name": "...
0
votes
2answers
65 views

Retrieve page or pages that contain certain component on the component presentation list

I need to retrieve the page or pages that are published and the component presentation of the page (or pages) contain a certain component. If a component exists on multiple pages, I would like to know ...
1
vote
1answer
59 views

Issues while querying Number type metadata fileds through JSP content broker query API

I have a legacy implementation where we have some components got number type metadata filed. Downstream applications uses JSP content broker query API and queries for components with number filters. ...
4
votes
0answers
75 views

Broker: find a Page using a specific Component and Component Template

I have a use case where I need to find the Page URL from a Page using a certain Component Presentation (given componentId and templateId). I am trying to find the Page using Criteria but I can't find ...
1
vote
1answer
97 views

How to read linked Components TCM URI's from custom meta of a Component

I have linked Components in my Component's custom metadata, I want to read tcm uri of them on Content Delivery (WebForms Applciation not DD4T). Here is how Custom_Meta Table in Broker looks like ...
3
votes
0answers
53 views

TaxonomyKeywordKeyCriteria ignores publication Id

I'm using TaxonomyKeywordKeyCriteria to find Components that have a related Keyword. I only have the Keyword key and not the TCM URI. My code: Criteria criteria = new TaxonomyKeywordKeyCriteria(...
5
votes
1answer
181 views

Using multiple custom meta data keyword Criteria in a single query as LIKE operators

I need to accomplish the following, and I can't find any working method for it. We have articles with a custom meta data field of comma separated keyword values, the code I've built split's by comma ...
6
votes
1answer
135 views

Tridion Query Criteria AND + OR

I have a query that I want to build with combination of AND and OR criteria. The obvious example is PublicationCriteria is always AND user specified criteria can be AND or OR I have written the ...
2
votes
1answer
29 views

Query news component at WEB 8

We have a page to load & show all published News component dynamically. The component number is pretty big, more than 100. When we start query, it can support pagination. But it can only return ...
1
vote
1answer
99 views

In DXA site query a list of Components using the Content Query Schema

I want to search a list of Components in my DXA site, by two criterias, which mapped to two Keywords. For example, I have one shop item, which has two main property: Category: Toys, Electronic, ...
6
votes
1answer
323 views

Fredhopper Indexer's qserver instance consuming too much CPU

Preview page is loading within 1.7 mins, FH query took 6.084 secs and QServer consumes more than %95 CPU. This as a blocker problem, results in slowing down the whole system. Is there any way of ...
4
votes
1answer
72 views

Pushing custom Page metadata during publishing

I have a Page inherited from top level Publication, which I should not localize, but at the same time I would like to (somehow) add metadata info to the Page during Page publishing (at that point I ...
2
votes
1answer
218 views

How to Get All Components Except particular TCM ID by Using Criteria API

I am trying to get all components based on the schema, I have to ignore one particular tcm ID from the query. as i already have the component object in code. i am unable to do it. This is my code ...
4
votes
1answer
207 views

Find pages using query criteria by last publish date

I have query like this: Criteria criteria = new ItemTypeCriteria(64); var pages = new Query(criteria ); I also need to add criteria to get pages which were published after specific date.
3
votes
0answers
317 views

How can i retrieve components using broker query with sort parameter over optional metafield

I have a requirement to sort on optional custom date for components. I have 25 components matching criteria and 1 component with published date (metadata field) empty, but its returns only 24 ...
13
votes
1answer
478 views

Broker Query with sort criteria over optional field

I'm obtaining a list of 5 components from the broker using a simple Query: Query myQuery = new Query(); Criteria myCriteria = null; PublicationCriteria pubRelCriteria = new PublicationCriteria(...
7
votes
1answer
326 views

Query.ExecuteEntityQuery throws NullReferenceException, ExecuteQuery returns null

I'm trying to run a very simple Query at the broker database. This example should get all pages from the broker. ItemTypeCriteria criteria = new ItemTypeCriteria(64); // Page Query query = new Query(...
7
votes
1answer
162 views

Multiple NotInCriteria producing incorrect results

Might be doing something stupid but basically I am not getting the results I would expect when using multiple NotInCriteria in a query. I only ever seem to have the one of the criteria excluded. The ...
5
votes
1answer
192 views

Querying for content with a specific taxonomy, based on a varying taxonomy

I'm trying to build a query to give me components based on a set of critiera, I think i can explain it better by referencing the following image: My query looks like this: "Year" IS 2014 OR 2013 "...
4
votes
1answer
76 views

Adding multiple SortParameters - .Net API

Tridion 2011 SP1 HR2 I am having trouble getting multiple sort orders added via the .Net api. We have multiple custom meta fields as below: Order Items (Added in this order) FieldName ...
9
votes
2answers
228 views

Is there anyway to let Query Support pagination?

We want to search a list of published News component based on Content Delivery API. The components number is huge. So we want to use pagination. Do you know whether the Content Delivery's search API ...
7
votes
1answer
295 views

SchemaTitleCriteria yield no results in SDL Tridion Broker Query

I have a simple SDL Tridion 2011 SP1 Broker Query to retrieve a list of Component URIs. All of my Components are embedded on Pages, and not using Dynamic Component Templates. The following code ...