How to query only documents with an existing localization for a certain locale?

hdodov12 months ago

4 1

const localizedPostIds = (
	await payload.db.collections["blog-posts"]
		.find({
			[`content.${req.locale}`]: {
				$exists: true,
				$ne: "",
			},
		})
		.select({
			_id: true,
		})
).map((e) => e.id);

const posts = (
	await payload.find({
		collection: "blog-posts",
		locale: req.locale,
		where: {
			_id: {
				in: localizedPostIds,
			},
		},
	})
).docs;

• Selected Answer
  

  DanRibbens

  12 months ago

  I am fairly certain that the query builder does let you pass the locale through and that you should be able to just do one query. Also I do not think that querying uses the fallback locale at all. We don't have extra logic that would add or for the fallback for the properties being queried.

  It is my expectation that this should work:

  const posts = (
  	await payload.find({
  		collection: "blog-posts",
  		locale: req.locale,
  		where: {
  			'content.es': {
  				exists: true,
  			},
  		},
  	})
  ).docs;
  

  To format that into a rest query using query params you're looking at /api/blog-posts?where[content.es][exists]=true&locale=es
  That should return your posts where content is populated in the es locale AND the returned data will use your fallbackLocales as you've defined them in your localization. If you don't want the results to have fallback you can always add &fallbackLocale=null.

  Does that work?

  1 reply
• 

  hdodov12 months ago

  Yep, that works! I was able to reduce the two queries to a single one. Thank you!