Hi,
Many thanks for the examples provided. The syntax now appears OK, but no emails are returned. I have included below the output from the queries made via clenotes when using the two examples discussed together with a query using the --from function. As can be seen the Formula query returns no data whereas the From query finds emails.
I can confirm that the local replica used has been indexed.
Note, I have echoed out the command line parameters in the clenotes.sh to ensure things are being passed correctly.
Regards,
Nick
[nick@oc4707345106 CLENotes-5.0.0]$ ./clenotes.sh --local --database-name=/home/nick/lotus/notes/data/mail01/GBY9A74H.NSF --password=****** search '--formula="DeliveredDate > @Date(2012;12;12)"'
--local
--database-name=/home/nick/lotus/notes/data/mail01/GBY9A74H.NSF
--password=******
search
--formula="DeliveredDate > @Date(2012;12;12)"
Command Line Email Client for IBM Notes v5.0.0
Copyright (C) 2002, 2013 by IBM Corporation.
Licensed under the Apache License v2.0.
Search returned 0 mails.
[nick@oc4707345106 CLENotes-5.0.0]$ ./clenotes.sh --local --database-name=/home/nick/lotus/notes/data/mail01/GBY9A74H.NSF --password=****** search --formula='@Contains(From; "UNIX")'
--local
--database-name=/home/nick/lotus/notes/data/mail01/GBY9A74H.NSF
--password=******
search
--formula=@Contains(From; "UNIX")
Command Line Email Client for IBM Notes v5.0.0
Copyright (C) 2002, 2013 by IBM Corporation.
Licensed under the Apache License v2.0.
Search returned 0 mails.
[nick@oc4707345106 CLENotes-5.0.0]$ ./clenotes.sh --local --database-name=/home/nick/lotus/notes/data/mail01/GBY9A74H.NSF --password=****** search --from='UNIX'
--local
--database-name=/home/nick/lotus/notes/data/mail01/GBY9A74H.NSF
--password=******
search
--from=UNIX
Command Line Email Client for IBM Notes v5.0.0
Copyright (C) 2002, 2013 by IBM Corporation.
Licensed under the Apache License v2.0.
Search returned 15 mails.
[0] 22/08/2011 11:31:22 GDT
From:
[1] 16/10/2012 16:16:51 GDT
From:
[2] 17/10/2012 10:51:04 GDT
From:
[3] 31/10/2012 18:58:04 GMT
From:
[4] 09/08/2013 12:43:52 GDT
From:
[5] 09/08/2013 11:37:38 GDT
From:
[6] 04/11/2013 16:00:51 GMT
From:
[7] 30/10/2013 11:30:19 GMT
From:
[8] 29/10/2013 13:29:17 GMT
From:
[9] 04/10/2013 19:47:24 GDT
From:
[10] 29/10/2013 14:11:57 GMT
From:
[11] 31/10/2013 16:45:28 GMT
From:
[12] 09/08/2013 19:57:50 GDT
From:
[13] 11/12/2013 11:01:30 GMT
From:
[14] 27/11/2013 17:41:27 GMT
From: