# Globalize Plugin: SImple question about searching untraslated records

**URL:** <https://www.ruby-forum.com/t/globalize-plugin-simple-question-about-searching-untraslated-records/126570>\
**Category:** Rails\
**Created:** [January 19, 2008, 6:28pm UTC](https://www.ruby-forum.com/t/globalize-plugin-simple-question-about-searching-untraslated-records/126570 "2008-01-19T18:28:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gianluca\_t](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/d78d45/32.png) [@gianluca\_t](https://www.ruby-forum.com/u/gianluca_t)\
**Post date:** [January 19, 2008, 6:28pm UTC](https://www.ruby-forum.com/t/globalize-plugin-simple-question-about-searching-untraslated-records/126570/1 "2008-01-19T18:28:36Z")

</div>

Hi,

how can i find all record of untranslated field on a field under  
Globalize plugin ?

Example:

define a model:

class Translation \< ActiveRecord::Base  
translates :description  
end

working with 2 locales (en-US base and it-IT)

when i create a record for english base locale and after set italian  
locale reading the translation of model.description I retrieve the  
default value (that’s ok because Globalize uses coalesce to return the  
engish description if italian description is not present).

What can I do to know which translations is not already loadedin italian  
locale ? (sort of Model.find(:all, :conditions =\> "description is null  
or description = ‘’))

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![gianluca\_t](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/d78d45/32.png) [@gianluca\_t](https://www.ruby-forum.com/u/gianluca_t)\
**Post date:** [January 19, 2008, 7:46pm UTC](https://www.ruby-forum.com/t/globalize-plugin-simple-question-about-searching-untraslated-records/126570/2 "2008-01-19T19:46:12Z")

</div>

I’ve solved from myself.

Simply using this condition only when not in base language:

Translation.find(:all, :conditions =\> “t\_description.text is null”)

Hope this helps…

> translates :description  
> locale ? (sort of Model.find(:all, :conditions =\> "description is null  
> or description = ‘’))
> 
> Thanks in advance.
> 
> >

## – Gianluca T. TreNetMediaMaster S.r.l. The Internet Technology Company Telefono +39(049)776196 Fax +39(049)8087806 Visit us @: [http://www.trenet.it](http://www.trenet.it) - [http://www.mediamaster.it](http://www.mediamaster.it) e-mail me @: removed\_email\_address@domain.invalid

Le informazioni trasmesse sono destinate esclusivamente alla persona o  
alla società in indirizzo e sono da intendersi confidenziali e riservate.  
Ogni trasmissione, inoltro, diffusione o altro uso di queste  
informazioni a persone o società differenti dal destinatario é proibita.  
Se ricevete questa comunicazione per errore, contattate il mittente e  
cancellate le informazioni da ogni computer.