[Leaplist] OpenOffice MailMerge Conditional Equations

[Jesse Goerz]

On Sun, 2008-09-14 at 01:42 -0400, Bruce Metcalf wrote:
> Phil Barnett wrote:
> > On Saturday 13 September 2008 01:40:41 am Bruce Metcalf wrote:
> 
> >>  >> The problem is that any equation other than == or <> fails to work.
> >>  >>
> >>  >> None of the OOo guides, manuals, wikis, or homebrew cheat sheets
> >>  >> have a list of recognized operators. I've seen ... suggestions that
> >>  >> OR, AND, and NOT work. Nothing definitive, and nothing at all on
> >>  >> operators like >, <, >=, <=, GT, LT, GE, or LE....
> >>
> >> I'll settle for someone telling me that these comparator functions
> >> definitely don't work in OOo.
> > 
> > Is there a conditional IF() function?
> 
> Well, there you go. That is exactly the problem. I don't know what 
> comparators exist and I can't find a definitive list!
> 
> I'm about ready to just divide the membership into three groups and 
> transfer them back and forth as the renew. <g>

Start any OOo app.  Hit F1.  Select the index tab and type 'operator'.
In base, there is a subheading of 'default filters' that details the
conditional operators.  == does not appear to be the equality operator;
just plan '='.  You could also try 'queries;formulating filter
conditions' as an index term.  There is an explanation of how the
comparators are transformed into SQL.

I've never used base, can you just use SQL and create queries to filter
based on the data field you are interested in?

hth,
Jesse


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.