General

Re: validation check of 2 concatenated fields in a repeating group/table

Greg Collins — Fri, 08 Jun 2007 19:21:02 GMT

That is a good solution which I hesitated to suggest because many do not have control of the schema to do that. But if you do, that's the easiest way. Then you only have a single field to check against--concat already complete.

Re: validation check of 2 concatenated fields in a repeating group/table

Mancha — Fri, 08 Jun 2007 09:52:48 GMT

Hi Greg,

thanks for your reply. I have to avoid code so I implemented following solution.

My solution is to add an additional field <unique> to concatenate the values of the <type> and <category>. The validation check of category is based on this field <unique>.

Re: validation check of 2 concatenated fields in a repeating group/table

Greg Collins — Wed, 06 Jun 2007 16:38:42 GMT

You might find that trying to do all this with expressions and XPath is more complicated than its worth. Move to code for something like this and it will be more straight forward and probably more performant.

validation check of 2 concatenated fields in a repeating group/table

Mancha — Wed, 06 Jun 2007 14:02:55 GMT

Hi all

I have following xml structure. <field1> and <field2> are text fields. User enters many types and categories. The validation has to check if a type combinated with category already exist.
In this sample A1 and B2 is double in the structure. How can I set the validation in <category>?

This is my validation:

concat(../my:type, .) = ../../preceding-sibling::my:repeatingGroup1[concat(my:group2/my:type, my::group2/my:category)]

It doesn't work.

Has anybody a solution for me?

type    category
-----------------------
A         1
B         2
A         1 --> validation- already exists
C         3
B         2 --> validation- already exists