Re: [libreoffice-users] Conditions

On Sun, 2012-03-18 at 19:53 +0000, Mark Stanton wrote:
> For my mailmerge I want to set up a conditional paragraph conditional 
> on more than one thing.
>
> I've got a database field "Country", and if this is blank or contains 
> "Scotland" I want the paragraph hidden.
>
> I *think* the condition ought to be
>
>     NOT Country OR Country EQ 'Scotland'
>
> but it doesn't work.  I thought blanks at the end of the country 
> field might cause a problem so I tried
>
>     NOT Country OR 'Scotland' EQ Country
>
> but that didn't work either.
>
> The help states that the fields ought to be written as 
>
>     <database>.<table>.<field>
>
> but that doesn't make any difference either and the single condition 
> "NOT Country" does work, although it's insufficient for my needs.
>
> Have I got my logic entirely wrong, or can the condition expression 
> not have more than one part?
>
> Mark Stanton
> One small step for mankind...

     Might be in the logic. You wrote "if this is blank or contains
"Scotland" I want the paragraph hidden."
     I would write this as  
If 
(<db>.<table>."Country" IS NULL) OR (<db>.<table>."Country"='Scotland')
then the paragraph is hidden.
 Then again in LO queries, this is written as
(<db>.<table>."Country" IS EMPTY) OR (<db>.<table>."Country"='Scotland')
     See if either of these work.

--Dan


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted