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.