General

Re: Repeating table inside repeating section and Qrules insert command.

shniggens — Tue, 25 Oct 2011 18:24:11 GMT

Hilary Stoupa:

Glad you got it figured out!

Shniggens - 1

Hilary - 437

; )

Re: Repeating table inside repeating section and Qrules insert command.

Hilary Stoupa — Tue, 25 Oct 2011 18:10:10 GMT

Yes, "and" not "or" - sorry about that. Glad you got it figured out!

Re: Repeating table inside repeating section and Qrules insert command.

shniggens — Tue, 25 Oct 2011 18:06:07 GMT

OK, that worked. I actually had to "and" them, but the results were the same as the " | ".

Re: Repeating table inside repeating section and Qrules insert command.

Hilary Stoupa — Tue, 25 Oct 2011 17:43:42 GMT

I think you could replace with multiple expressions separated with "or" - you'll want to test this, of course, and verify it works in client prior to trying in browser.

not(my:MasterLaborPerson = current()/preceding-sibling::my:RoomingTable/my:Occupant1)

not(my:MasterLaborPerson = current()/following-sibling::my:RoomingTable/my:Occupant1)

Re: Repeating table inside repeating section and Qrules insert command.

shniggens — Tue, 25 Oct 2011 17:25:05 GMT

not(my:MasterLaborPerson = (current()/following-sibling::my:RoomingTable | current()/preceding-sibling::my:RoomingTable)/my:Occupant1)

I basically replaced my fields with Jimmy's example. Is there an alternative to " | "?

Re: Repeating table inside repeating section and Qrules insert command.

Hilary Stoupa — Tue, 25 Oct 2011 17:20:16 GMT

What is your expression in the filter? It sounds like an issue with the "|" operator.

Re: Repeating table inside repeating section and Qrules insert command.

shniggens — Tue, 25 Oct 2011 17:14:15 GMT

Well it works great in the client, but when I try to publish it to SharePoint, I get this error -

'(current()/following-sibling::my:RoomingTable union current()/preceding-sibling::my:RoomingTable)/my:Occupant1' has an invalid token.

Any idea what might be causing that?

Re: Repeating table inside repeating section and Qrules insert command.

shniggens — Tue, 25 Oct 2011 15:20:24 GMT

Well tell that super-genius I said THANK YOU! This is brilliantly perfect. Thanks to both of you.

Re: Repeating table inside repeating section and Qrules insert command.

Hilary Stoupa — Tue, 25 Oct 2011 14:44:57 GMT

Oh yeah, Jimmy certainly did know how to do this (he's like a XPath super-genius). I'm attaching his sample form, check out the expressions he used for his filters on his drop downs!

Re: Repeating table inside repeating section and Qrules insert command.

Hilary Stoupa — Mon, 24 Oct 2011 23:40:26 GMT

There may be a clever XPath-y way to do this, but I'm not seeing it - I'm forwarding to Jimmy in case he knows how to do this.

Re: Repeating table inside repeating section and Qrules insert command.

shniggens — Mon, 24 Oct 2011 20:21:54 GMT

That would be much appreciated, Hilary. Thanks.

Re: Repeating table inside repeating section and Qrules insert command.

Hilary Stoupa — Mon, 24 Oct 2011 18:22:37 GMT

I think you'll have to manually create this expression - if I get a chance later today, I'll try to put together a sample.

Re: Repeating table inside repeating section and Qrules insert command.

shniggens — Mon, 24 Oct 2011 17:12:53 GMT

Yes, I guess I will have to filter on the HotelRepeatingSection, too. I already have the table filtered to not show previous values in the current table. But when I add a second instance of the table, the values are all there again.

So right now the table has -

not(my:MasterLaborPerson = current()/following-sibling::my:RoomingTable/my:Occupant1) and

not(my:MasterLaborPerson = current()/preceding-sibling::my:RoomingTable/my:Occupant1)

How do I include the HotelRepeatingSection into this?

Re: Repeating table inside repeating section and Qrules insert command.

Hilary Stoupa — Mon, 24 Oct 2011 17:03:52 GMT

You can probably do this using a filter with preceding-sibling again ... the filter would be on your drop down list entries, checking to see if the preceding sibling Rooming Table nodes have the value - but I'm not sure off-hand if you'd also need to check based on the Hotel group - you'll have to experiment a bit....

Re: Repeating table inside repeating section and Qrules insert command.

shniggens — Mon, 24 Oct 2011 16:58:19 GMT

Yes, Hilary, that's perfect!!! Thanks!!!!

One more question, as I like to milk everybit of information out of every thread I start ......

Do you know how I could filter a drop-down list box so that it does not contain data from the previously occurring repeating table? So in a RoomingTable that is in the second occurrance of the HotelRepeatingSection, I want to filter out everything that was already chosen in the first occurrance?