Cannot Concantenate qRulesFilename into a string - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Cannot Concantenate qRulesFilename into a string

Last post 11-21-2012 08:38 AM by Hilary Stoupa. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 11-20-2012 08:53 PM

    Cannot Concantenate qRulesFilename into a string

    I am trying to build a string (text field) that contains all the QRulesFilename contents from the repeatig "FileAttachment". I have done this before with other repeating groups. Please see image for illustrations.

    I am using the following formula (again I have used the same construction before with no problem)...

    eval(eval(FileAttachment, 'concat(../../my:Enclosures_Messages/my:Attachments/my:Attachment/my:FileAttachment/@my:qRulesFilename,";")'), "..")

    Here is the "Edit XPath (advanced)" output:

    Edit XPath (advanced):
    xdMath:Eval(xdMath:Eval(../../my:Enclosures_Messages/my:Attachments/my:Attachment/my:FileAttachment, 'concat(../../my:Enclosures_Messages/my:Attachments/my:Attachment/my:FileAttachment/@my:qRulesFilename,";")'), "..")

    This is the Formula Error I'm getting:

     FORMULA ERROR:
    "../../my:Enclosures_Messages/my:Attachments/my:Enclosures_Messages/my:Attachments/my:Attachment/my:FileAttachment/@my:qRulesFilename" does not point to a valid location path of a field or group.

    I really need to collect and concantenate all of these filenames together (delimited with ";"). If there is something I am missing here or if there is some other way that this needs to be accomplished due to the fact that I am using QRules, please help.

    thanks!

     


    DMN
  • 11-21-2012 05:28 AM In reply to

    Re: Cannot Concantenate qRulesFilename into a string

    Hi,

    Instead of using a double eval, could you use the DelimitedList qRules command?

    Check out the User Guide to see if this command will help address the issue, and let us know if you have questions. Thanks!

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 11-21-2012 08:18 AM In reply to

    Re: Cannot Concantenate qRulesFilename into a string

    One of these days I am going to sit down and read that manual. There are probably other things that are in qRules that come in handy as well.

    Yes... that did it. I guess you guys built that because the EVAL would not work. No matter - it did what I needed. Thanks !!!!

     

     

    DMN
  • 11-21-2012 08:38 AM In reply to

    Re: Cannot Concantenate qRulesFilename into a string

    Actually, we added it because people often find the double eval syntax confusing.

    Looking at the formula you tried, my guess would be that this would work:

    xdMath:Eval(xdMath:Eval(../../my:Enclosures_Messages/my:Attachments/my:Attachment/my:FileAttachment, 'concat(@my:qRulesFilename,";")'), "..")

    With a relative path instead of a full path in the concat portion of the formula.

    Hilary Stoupa

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