Filter multiple selection list box, based on repeating table current rows... - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Filter multiple selection list box, based on repeating table current rows...

Last post 11-09-2015 02:40 PM by Hilary Stoupa. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 11-06-2015 06:00 AM

    Filter multiple selection list box, based on repeating table current rows...

    Hello, I have a repeating table that pulls in a sum from an external data source. To the right of the sum, I put two option button (on/off) and below, I put a multiple selection list box. I am trying to be able to give the user the ability to see some insight into the sum. For example, based on criteria, there are 10 employees being hired in NY at a particular level. Ok, great, but who are they? Pull in their names to the multiple selection list box. I have everything working but of course am struggling to LIMIT the results of the multiple selection list box to show ONLY the data for rows that are marked on with the option button. Please refer to the code below... /dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Requisition_x0020_Number[../d:_x0033__x002d_Dot_x0020_Hierarch = xdXDocument:get-DOM()/my:myFields/my:Group/my:RepeatingFields/my:Hierarchy and xdXDocument:get-DOM()/my:myFields/my:Group/my:RepeatingFields/my:InsightONOFFPOSTED = 1 and ../d:Band_x0020_ = xdXDocument:get-DOM()/my:myFields/my:Group/my:RepeatingFields/my:Band and ../d:Work_x0020_City = xdXDocument:get-DOM()/my:myFields/my:LocationDropdown] How do I add the current() code to ONLY show me the requisition numbers where component of my repeating table InsightONOFFPOSTED = 1, but only the rows where it equals 1. A user could have 5 rows with 5 different sums from the external data source, but only the requisition numbers will display for the rows they flip InsightONOFPOSTED on (1). Thank you so much! I can give more details, post images if needed.
  • 11-09-2015 06:08 AM In reply to

    Re: Filter multiple selection list box, based on repeating table current rows...

    Can anyone help me with this?
  • 11-09-2015 08:15 AM In reply to

    Re: Filter multiple selection list box, based on repeating table current rows...

     Where is the multiple selection list box in your form? In a repeating section bound to "my:RepeatingFields"? If so -

    dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Requisition_x0020_Number[../d:_x0033__x002d_Dot_x0020_Hierarch = current()/my:Hierarchy and current()/my:InsightONOFFPOSTED = 1 and ../d:Band_x0020_ = current()/my:Band and ../d:Work_x0020_City = xdXDocument:get-DOM()/my:myFields/my:LocationDropdown] How  

    Hilary Stoupa

  • 11-09-2015 08:30 AM In reply to

    Re: Filter multiple selection list box, based on repeating table current rows...

    No, the multiple selection list box is below the sum, outside of the repeating table. Please see the attached image. When the sum comes into the Approved By HR Posted section, the user can click the radio button at the right to "see" what the req numbers are of that sum. So, based on criteria it pulls in 10, hit the option to "see" who, those req numbers populate the multiple selection list box.
  • 11-09-2015 02:40 PM In reply to

    Re: Filter multiple selection list box, based on repeating table current rows...

     Hmmm. So - you want to compare based on which row has InsightONOFFPOSTED = 1? The XPath below would work, I think.

    dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Requisition_x0020_Number[../d:_x0033__x002d_Dot_x0020_Hierarch = xdXDocument:get-DOM()/my:myFields/my:Group/my:RepeatingFields[my:InsightONOFFPOSTED = 1]/my:Hierarchy and ../d:Band_x0020_ = xdXDocument:get-DOM()/my:myFields/my:Group/my:RepeatingFields[my:InsightONOFFPOSTED = 1]/my:Band and ../d:Work_x0020_City = xdXDocument:get-DOM()/my:myFields/my:LocationDropdown]  

    Hilary Stoupa

Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.