Qdabra qRules

Re: Copy Filtered Repeating Table to Another Repeating Table

Hilary Stoupa — Tue, 11 Sep 2012 21:40:07 GMT

Your filter would actually look like this:

/rowsrc=my:group2[../my:Checkbox1='true' or ../my:Checkbox2='true']

The case of the "or" matters. You can always get InfoPath to figure out the syntax for you in an expression box - that's how I learned XPath. :-)

Re: Copy Filtered Repeating Table to Another Repeating Table

JakeE — Tue, 11 Sep 2012 21:35:00 GMT

I might just be over complicating things. It might just be easier to add a 'select' checkbox to the repeating table so I only have one field to test before using the CopyTable command for my final destination.

Thanks for pointing me in the right direction Hilary!

Re: Copy Filtered Repeating Table to Another Repeating Table

JakeE — Tue, 11 Sep 2012 21:29:57 GMT

Additionally, is is possible to have multiple filters in the rowsrc parameter?

For example:

/rowsrc=my:group2[../my:Checkbox1='true'] OR [../my:Checkbox2='true']

Re: Copy Filtered Repeating Table to Another Repeating Table

Hilary Stoupa — Tue, 11 Sep 2012 21:26:11 GMT

Well, if I understand you correctly, you may need to use a concat statement. So your command may be something like this:

concat("CopyTable /dsnamesrc=MySharePointList /tablesrc= /dfs:myFields/dfs:dataFields /rowsrc=d:SharePointListItem_RW[d:Title='", FieldWithValue, "'] /tabledest=/my:myFields/my:group3 /rowdest=my:group4 /empty=yes")

So, let's pretend FieldWithValue is in another data source and the value is Test. The above concat would send a command that actually has the value of:

CopyTable /dsnamesrc=MySharePointList /tablesrc= /dfs:myFields/dfs:dataFields /rowsrc=d:SharePointListItem_RW[d:Title='Test'] /tabledest=/my:myFields/my:group3 /rowdest=my:group4 /empty=yes

Does that make sense?

Re: Copy Filtered Repeating Table to Another Repeating Table

JakeE — Tue, 11 Sep 2012 21:21:15 GMT

I am using CopyTable.

Can the filter on the rowsrc parameter compare two fields? If so, I think that will be my solution.

Re: Copy Filtered Repeating Table to Another Repeating Table

Hilary Stoupa — Tue, 11 Sep 2012 21:11:12 GMT

Hi - are you using CopyTable?

You can use a filter on the rowsrc parameter - like:

/rowsrc=my:group2[../my:Checkbox='true']

Copy Filtered Repeating Table to Another Repeating Table

JakeE — Tue, 11 Sep 2012 20:37:39 GMT

I have a SP List and I've copied the data to a repeating table in my main data source. I then filter the data based on checkbox selection and I'd like to copy only the filtered values to another repeating table. How can this be accomplished?