Code

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

Hilary Stoupa — Mon, 09 Nov 2015 22:40:33 GMT

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]

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

orbanez — Mon, 09 Nov 2015 16:30:49 GMT

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.

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

Hilary Stoupa — Mon, 09 Nov 2015 16:15:28 GMT

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

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

orbanez — Mon, 09 Nov 2015 14:08:45 GMT

Can anyone help me with this?

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

orbanez — Fri, 06 Nov 2015 14:00:17 GMT

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.