Data Connections

Re: Data filter

ben.oates — Fri, 04 Apr 2008 09:37:36 GMT

Thanks Clay... that's brilliant.

If anyone else has this problem, the best tutorial I found is here:

http://blogs.msdn.com/timpash/archive/2005/10/26/Using-Current-Function.aspx

Re: Data filter

Clay Fox — Thu, 03 Apr 2008 16:03:36 GMT

Hey Ben.

I am not sure I compeletly understand what you are looking for.

You can use a filter to show all HWversion where HWType = a field or constant.

I think you are trying to display it. If this is in a repeating tabel or section you may be looking for the current() function to refer to the current record and not the very first record. Seach on current to find out more on this.

Data filter

ben.oates — Thu, 03 Apr 2008 15:43:16 GMT

Hi all,

I'm struggling a bit with a data filter for displaying items in a drop-down list.

I have a repeating field called "Hardware" as you can see in the middle of the following XPath:

/my:myFields/my:Hardware/my:HType

HType and HVersion are non-repeating elements in my:Hardware.

I have a data connection to a Sharepoint list and I want the drop down list for HVersion to only show version numbers where @Name (on the list) is equal to HType. I did this:

../@Name = xdXDocument:get-DOM()/my:myFields/my:Hardware/my:HType

What this gives me is a filtered list of all the version numbers for the HType children of every Hardware. I just want the HType child in the same Hardware entry as the HVersion I'm currently looking at. Can anyone help me to adhust my code? Is it possible? I have tried ../my:HType and just my:HType but these do not work.

Thanks all.