I didn't realise you could use Xpath functions. Work arounds for conditionals for xpath 1.0 here http://www.tkachenko.com/blog/archives/000156.html

in XPath number(true()) is 1, while number(false()) is 0 and when second argument of substring() function is greater than actual length of the string, empty string is returned. Hence substring($s1, number(not($condition))*string-length($s1)+1) returns $s1 if $condition is true and empty string otherwise. Concatenating two such expressions in mutually exclusive way gives us conditional strings expression.

Something like concat((substring('Desexed', (patient.entity.desexed!=false)*string-length('Desexed')+1)),(substring('Entire', (patient.entity.desexed!=true)*string-length('Entire')+1))) haven't tested it and doing this on the fly so not sure if this is what you did last time Tony. Cheers, Matt

On Wed, 08 Jul 2009 09:25:24 +1000, Tony De Keizer

wrote:

> Hi Guys, > > Thanks for having a look at this Matt. > > In regards the Word document merge fields we only support MERGEFIELD. The > reason is we utilise open office to do the merging of the word document and

> we utilise the MERGEFIELD tag to identify the field and we then get the > remaining text and evaluate it as an internal expression. If the IF is > inserted then we cannot identify the field and it will not get evaluated > and > replaced. > > The good thing is the expression can utilise any valid expression we are > able to use not just the field name. This means we can utilise all the > standard xpath language functions as well. Unfortunately xpath does not > have an If operator but I remember putting together a sneaky expression > that > got around this restriction. The problem is it was so sneaky I can't > remember it any more but I will search the archives and find it .. > > For 1.4 I have created a new function openvpms:getPatientDesexStatus(.) > which returns a string "Desexed" or "Entire" based on the desex flag. Will

> need to internationalise before releasing though. > > Cheers > Tony > > > > On 7/07/09 7:18 PM, "Mpcosta@Boroniavet. Au" : > >> Hi Sandra, >> I have been playing with conditional fields in Word (in order to get the >> FALSE and TRUE of the desexed status turn into text of your choosing)and >> have not been able >> to get them to work sadly. Using conditional fields is how we control >> what >> true/false results look like in openoffice. >> We dont use MS office at work which makes testing them tricky for me. >> >> I had recommended trying this with another user: >> 1. Type Ctl-F9 >> 2. Curly brackets will appear. Type IF in the curly brackets -> {IF } >> 3. Type Ctl-F9 again -> {IF {}} >> 4. Type "MERGEFIELD patient.entity.desexed" -> {IF {MERGEFIELD >> patient.entity.desexed}} >> 5. Type ="True" "Desexed" "Undesexed" after the curly bracket -> {IF >> {MERGEFIELD patient.entity.desexed}="True" "Desexed" "Undesexed"} >> 6. Right click on the field and choose Update Field >> >> I have also attached a document version which I have been advised did not

>> work as intended :( >> >> >> As for the fields themselves, I thought they were the same as Openoffice >> fields inserted as mergefields? A list of the merge field names is here >> http://www.openvpms.org/document-merging-with-open-office-writer >> >> I've attached a screen shot showing the dialog used to insert the above >> texts as merge fields in Word documents. I hope it appears for everyone. >> >> Cheers, >> Matt C >> >> >> >> On Tue, 7 Jul 2009 01:58:57 +0000 (UTC), sandra@bellvet.com.au wrote: >>> Hi, >>> >>> Can anyone provide me with the WORD (not open office) merge fields to >>> enable me to get the desexed status of a patient on certificates. >>> >>> Also, can anyone tell me if these fields have been updated. When we >>> started with OpenVPMS entire animals appeared as FALSE and desexed >> animals >>> appeared as TRUE which we thought was a bit confusing (we thought it >> should >>> be the other way around) that's why we removed the desexed status fields

>>> altogether. >>> >>> Sandra. >>> _______________________________________________ >>> OpenVPMS User Mailing List >>> users@lists.openvpms.org >>> To unsubscribe or change your subscription visit: >>> http://lists.openvpms.org/listinfo/users >>> Posts from this mailing list can be viewed online and replied to in the >>> OpenVPMS User's forum- http://tinyurl.com/openvfu >>> >> _______________________________________________ >> OpenVPMS User Mailing List >> users@lists.openvpms.org >> To unsubscribe or change your subscription visit: >> http://lists.openvpms.org/listinfo/users >> Posts from this mailing list can be viewed online and replied to in the >> OpenVPMS User's forum- http://tinyurl.com/openvfu > > > _______________________________________________ > OpenVPMS User Mailing List > users@lists.openvpms.org > To unsubscribe or change your subscription visit: > http://lists.openvpms.org/listinfo/users > Posts from this mailing list can be viewed online and replied to in the > OpenVPMS User's forum- http://tinyurl.com/openvfu >

_______________________________________________ OpenVPMS User Mailing List users@lists.openvpms.org To unsubscribe or change your subscription visit: http://lists.openvpms.org/listinfo/users Posts from this mailing list can be viewed online and replied to in the OpenVPMS User's forum- http://tinyurl.com/openvfu