Newbie Questions

Re: Filtering: What am I doing wrong? Unique selection needed.

Hilary Stoupa — Thu, 05 Nov 2015 15:35:30 GMT

Right - we use not(expression) because we are checking that a specific node DOES NOT EXIST.

!= compares values.

Thanks for adding this info, it will help ease confusion for others. :)

Re: Filtering: What am I doing wrong? Unique selection needed.

Gatchaman — Thu, 05 Nov 2015 14:07:52 GMT

Just wanted to update this thread in case anyone is looking for a solution to this. Seems there is a bug in infopath for this filter. If you put in 'equals' it will work. It will only show what was already selected. But if you put in 'not equal' it will not work, it will still show items in the dropdown that were already selected. To fix it, copy out the xPath. Now replace:

. != xdXDocu...

with

not (. = xdXDocu... )

Once I did that it worked! Thank you Hillary, would not have tested this approach without your posts!

Re: Filtering: What am I doing wrong? Unique selection needed.

Hilary Stoupa — Mon, 21 Sep 2015 19:58:31 GMT

Found one more approach:

not(d:Title = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Select)

I've also attached a sample based on this thread.

Re: Filtering: What am I doing wrong? Unique selection needed.

Hilary Stoupa — Mon, 21 Sep 2015 19:49:28 GMT

Cool. I'll put a sample up later today that uses an XML data source for the dropdown so you can see how the general idea works in a sample.

Re: Filtering: What am I doing wrong? Unique selection needed.

Gatchaman — Mon, 21 Sep 2015 19:28:53 GMT

Still shows all of the items. For now I've put a workflow in place that sets a 'Selected' field in the data list and I'm filtering off that. I'll have to play with this more tomorrow, again thanks for your help.

Re: Filtering: What am I doing wrong? Unique selection needed.

Hilary Stoupa — Mon, 21 Sep 2015 19:13:43 GMT

Try this? not(d:Title = current()/preceding-sibling::my:SharePointListItem_RW/my:Select)

Re: Filtering: What am I doing wrong? Unique selection needed.

Gatchaman — Mon, 21 Sep 2015 19:08:27 GMT

/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:Select

Re: Filtering: What am I doing wrong? Unique selection needed.

Hilary Stoupa — Mon, 21 Sep 2015 18:52:31 GMT

Okay, I had this wrong - http://www.infopathdev.com/blogs/matt/archive/2006/05/23/Filter-a-Repeating-Drop_2D00_Down-List-on-Previous-and-Future-Selections.aspx got me squared away. What is the full XPath to the field bound to the dropdown? You can right click the field in the Fields task pane and select Copy XPath.

Re: Filtering: What am I doing wrong? Unique selection needed.

Gatchaman — Mon, 21 Sep 2015 18:52:26 GMT

Yes. I have

Name (going to the data list, dataFields: d:SharePointListItem_RW:Name) NotEquals Name (going to data connection to the current list, dataFields: d:SharePointListItem_RW:Name)

I edited my response above to show a little more my process in doing this. Thanks for you help in looking into this!

Re: Filtering: What am I doing wrong? Unique selection needed.

Hilary Stoupa — Mon, 21 Sep 2015 18:42:45 GMT

Okay. Is "InfoPath Main" the data source for your dropdown?

Re: Filtering: What am I doing wrong? Unique selection needed.

Gatchaman — Mon, 21 Sep 2015 18:38:34 GMT

I can't, its on a corporate internal network not connected to the net. :(

I tried it on a test list as well with the same issue, only takes a minute to set it up. Maybe I can back up and you could look at my process to see if I have something wrong this way?

List 1: Data
- add dummy data, Joe, Lisa, Frank, Ted

List 2: Infopath list
- Add datasource to list 1 Data, columns Title selected
- Add datasource list 2, columns Title selected
- Add dropdown. Selection filter to Data. Name is not equal to (data source 2, select Title)
- Add a record of Joe

If I do that and run it, I get nothing instead of expecting to see Lisa, Frank, Ted.

If I set it to equal I see only Joe. If I set it to Not Equal I see everyone, including Joe who should be filtered out.

Re: Filtering: What am I doing wrong? Unique selection needed.

Hilary Stoupa — Mon, 21 Sep 2015 18:34:32 GMT

Can I see a copy of your form? Under the Options tab you can attach a file.

Re: Filtering: What am I doing wrong? Unique selection needed.

Gatchaman — Mon, 21 Sep 2015 18:23:33 GMT

I had a typo in my expression - I cant do a copy/paste as I'm using a separate computer - anyway.

I used:

not(xdXDocument:GetDOM("Infopath Main")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:Title = current()])

This is returning all of the values like the Name = Name does. Can this be switched to Name NotEquals Name?

Re: Filtering: What am I doing wrong? Unique selection needed.

Hilary Stoupa — Mon, 21 Sep 2015 17:29:38 GMT

Can you try replacing that expression with this one? not(xdXDocument:GetDOM("Infopath Main")/dfs:myFields/dfsdfs:dataFields/d:SharePointListItem_RW[d:Title = current()])

Re: Filtering: What am I doing wrong? Unique selection needed.

Gatchaman — Mon, 21 Sep 2015 17:18:00 GMT

Here is what it shows.

. = xdXDocument:GetDOM(Infopath Main")/dfs:myFields/dfsdfs:dataFields/d:SharePointListItem_RW/d:Title