Skip to main content

Questions tagged [query]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
13 votes
1 answer
568 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(...
Julián Hernández's user avatar
9 votes
2 answers
251 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 ...
qchen01's user avatar
  • 1,060
8 votes
1 answer
177 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 ...
Matt Hill's user avatar
  • 677
7 votes
1 answer
331 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 ...
Chris Summers's user avatar
7 votes
1 answer
367 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(...
comecme's user avatar
  • 173
6 votes
2 answers
302 views

How to 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.
Alex's user avatar
  • 165
6 votes
1 answer
185 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 ...
maurocam's user avatar
  • 233
6 votes
1 answer
363 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 ...
shamaleyte's user avatar
5 votes
1 answer
214 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 metadata field of comma-separated keyword values, the code I've built split's by comma ...
Kris Trygg's user avatar
5 votes
1 answer
203 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 "...
johnwinter's user avatar
  • 14.3k
4 votes
1 answer
77 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 ...
user3760419's user avatar
  • 1,079
4 votes
1 answer
78 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 ...
dylman79's user avatar
4 votes
0 answers
79 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 ...
Nicholas Wetmore's user avatar
4 votes
0 answers
89 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 ...
Inmaculada Palacios's user avatar
3 votes
0 answers
58 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(...
Guskermitt's user avatar
  • 1,297
3 votes
0 answers
339 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 ...
swati sundar's user avatar
2 votes
1 answer
41 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 ...
qchen01's user avatar
  • 1,060
2 votes
2 answers
104 views

NumberFormatException in Content Service

We have a Java website running on the latest hotfix version of CIL (8.5.0-16778). The CMS we are using is SDL Web 8.5 with the micro-service CD environment. Our site makes multiple calls to the ...
Nicholas Wetmore's user avatar
2 votes
1 answer
249 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 ...
Ravi Gadag's user avatar
1 vote
2 answers
311 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": "...
Percy's user avatar
  • 113
1 vote
1 answer
71 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. ...
Nageswara Sarma Aravelli's user avatar
1 vote
1 answer
114 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 ...
Neelesh Raghuvanshi's user avatar
1 vote
1 answer
117 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, ...
qchen01's user avatar
  • 1,060
1 vote
0 answers
127 views

How to exclude results in graphql query

I want to find a page through its keywords and/or metadata. I have this query that works correctly and returns all the pages with the keyword 9999 and aValue. { items(filter: { namespaceIds: [1],...
David Serrano's user avatar
1 vote
0 answers
35 views

How to query component with a multi-value component link field inside

I need to query for components that all have the same component linked inside a multi-value component link field. I can query simple string fields without problem using CustomMetaKeyCriteria/...
David Garcia's user avatar
0 votes
1 answer
102 views

How Could I search in Solr query inside a schema field a Date Type of CMS?

There Are any way to search with a certain Field as an example: http://blog.trivident.com/releasing-the-tiger-how-to-profit-from-solr-in-your-tridion-cm/ (RepositoryId:tcm:0-3-1 OR RepositoryId:tcm:0-...
Sergi TG's user avatar
0 votes
2 answers
113 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 ...
Payam's user avatar
  • 263