Data Connections

Re: filtering concatinated textbox generated from a repeating table

texastwo — Wed, 18 Aug 2010 14:56:33 GMT

Apparently, I need to take a different tack on the path to resolving this.

The @select ="2" approach is very robust. The problem is I can't filter the results and I receive everything in the column. That is why I introduced the @EID as a filtering agent. @EID was a decimal value, but I made it a string and forced a value into it like "161" using the same approach as offered by @select ="2" . No results. But I can see the value in SP list. (both @Select and @EID are in the same SP list.) Last attempt: expression="substring(xdMath:Eval(xdMath:Eval(../../dfs:SecData[@Select="2"][@EID="161"], 'concat(", ", @ID)'), ".."), 2)"

Do you have suggestions on using the double eval, or another method within the form to compare my secondary data column, @EID and only show results that match the comma delimited string created by @select="2" that match my:forms EID= @EID. I looked at the webservice for getlist, but I'm not farmiliar with VB coding, and trying to remain with just inopath and sharepoint as my basic tools.

Thanks for your time, and expertise!

Re: filtering concatinated textbox generated from a repeating table

Jimmy — Tue, 17 Aug 2010 15:50:07 GMT

It should be xdXDocument:get-DOM()/my:myFields/my:Constants/my:EID, without quotes around it.

Re: filtering concatinated textbox generated from a repeating table

texastwo — Tue, 17 Aug 2010 15:25:53 GMT

I guess I don't understanding the syntax! From the manifest file, when I'm dealing with secondary and main data sources, what is the syntax for main in the bracketed formula. [@EID = "/my:myFields/my:Summary/my:testfld"]

I created test field and copied it verbatium from the manifest, thats not working and the simple "my:testfld" appears to not work as well. I want to filter my secondary data, and only use the secondary data that matches my main testfld value?

Any thoughts?

Current expression from manifest... "substring(xdMath:Eval(xdMath:Eval(../../dfs:secdata[@EID = "/my:myFields/my:Summary/my:testfld"], 'concat(", ", @ID)'), ".."), 2)">

Re: filtering concatinated textbox generated from a repeating table

texastwo — Thu, 29 Jul 2010 18:47:46 GMT

expression="substring(xdMath:Eval(xdMath:Eval(../../dfs:Secdata[@select="2"][@EID =" xdXDocument:get-DOM()/my:myFields/my:Constants/my:EID" ], 'concat(", ", @ID)'), ".."), 2)"

Not having much success joining the second bracket. I've tried just about every combination.... even = my:EID

Re: filtering concatinated textbox generated from a repeating table

Jimmy — Mon, 12 Jul 2010 14:32:17 GMT

You seem to be making this more complicated than it needs to be. How about this?:

substring(xdMath:Eval(xdMath:Eval(../../dfs:Secdata [@IOR = "yes"][@FormID = my:FormID], 'concat(", ", @ID)'), ".."), 2)

You should use the Insert Field... dialog to select the my:FormID field from your main data source, because just typing my:FormID there won't work.

filtering concatinated textbox generated from a repeating table

texastwo — Mon, 05 Jul 2010 00:39:41 GMT

I “think” I'm dealing with apples and oranges here, or the old Texas saying may apply "it’s hard to make chicken salad out of chicken dodo".(A) http://www.infopathdev.com/forums/p/7124/30263.aspx#30263 makes reference to: xdMath:Eval(xdMath:Eval(../my:Group/my:RepeatingGroup, 'substring(concat(my:Value, ";"), 1, (my:Select = string(true())) * string-length(concat(my:Value, ";")))'), "..") this works well for repeating tables bound to "main".(B) http://www.infopathdev.com/forums/p/15704/56192.aspx#56192 makes reference to: substring(xdMath:Eval(xdMath:Eval(../../dfs:Inventory_Master_List[@IOR = "yes"], 'concat(", ", @ID)'), ".."), 2) and this works very well for secondary repeating tables.I’ve hit the wall on what I believe to be my short knowlege of the syntax for main and secondary repeating tables. "B" works very well for most of my needs however by design, everything in the List populates my concatenated textbox when the SharePoint list equals Yes in the @IOR column. I have found no way to filter the statement similar to "A".To accommodate and add a filtering agent, I have changed my methodology to force the user community to save the form after some minimal required information. When this form is submitted, it sets the @FormID field and adds it to a calendar. This allows me to gather the submitted form’s @FormID and apply it towards the filtering element of the "B" expression. The goal is something like: If my repeating table has Secdata @IOR equaling Yes, I add the @ID to my text box. But the only results I want to see in the textbox are the ones that have @IOR equaling Yes and if the @FormID= FormID. Or specifically, only the Secdata @IOR equaling Yes that was added to the sharepoint list from the respective form (@FormID).

substring(xdMath:Eval(xdMath:Eval(../../dfs:Secdata [@IOR = "yes"], 'concat(", ", @ID)'), ".."), 2) (../../dfs:Secdata[@FormID = my:FormID]) * string-length(concat(my:FormID, ";")))'), "..").