Qdabra qRules

Re: Cannot Concantenate qRulesFilename into a string

Hilary Stoupa — Wed, 21 Nov 2012 16:38:21 GMT

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.

Re: Cannot Concantenate qRulesFilename into a string

NICK1081 — Wed, 21 Nov 2012 16:18:38 GMT

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 !!!!

Re: Cannot Concantenate qRulesFilename into a string

ErnestoM — Wed, 21 Nov 2012 13:28:47 GMT

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!

Cannot Concantenate qRulesFilename into a string

NICK1081 — Wed, 21 Nov 2012 04:53:20 GMT

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!