Visual Builder

Get Involved. Join the Conversation.

Topic

    Stephen Bryant
    Unable to concatenate two fields in Business Object
    Topic posted September 21, 2019 by Stephen BryantBronze Trophy: 5,000+ Points, tagged Business Objects, Custom Code 
    38 Views, 8 Comments
    Title:
    Unable to concatenate two fields in Business Object
    Summary:
    Unable to concatenate two fields in Business Object
    Content:

    Hello,

    This is a strange issue.  I have a business object where I want to concatenate two fields using a formula.  Simple right?

    The formula is:

    fieldOne + "-----" + fieldTwo

    One field in the formula works fine but the moment I attempt to concatenate, the value does not show.

    This is not a problem in other business objects and I have compared a business object where it does work and there are no differences.

    Has anyone encountered this issue?

    Thanks,

    Steve

     

    Version:
    19.1.3

    Comment

     

    • David Konecny

      Never had a problem like that. I'd check for typos or what is type of these fields and try to use different combination of fields (from whole BO) until I narrow it down to a case which gives me insight into what's wrong and which field is causing the problem and why. Alternatively attach your app here and I will have a look.

      -David

      • Stephen Bryant

        David,

        Thanks for the response.  Attaching the application.  I've reduced the application to the two business objects in question.

        To illustrate the point, each business object has three fields, jeBatchID, jeHeaderID, drilldownURL. These are the last three columns in each business object.

        The drilldownURL is based on a formula: jeBatchID + jeHeaderID.  It works in the BO fvTreasurySymbols but not in fvBeTrxHdrs.

        My intention is to build a URL by concatenating the fields with a http string but the concatenation does not work in the fvBeTrxHdrs BO where I need it.

        All are text fields as well.

        Thanks for your help.

        Steve

      • Stephen Bryant

        David,

        I figured it out but I am unsure why it would work this way.  In the fxBetrxHdrs business object, there was a field called "Source".   Removing this field fixed the problem.

        Again, I am not sure why but it seems Source must be a reserved keyword for VBCS and that was corrupting the concatenation formula.

        Strange but deleting that column fixed it.

        Thanks again for all your help.

        Steve

        • David Konecny

          Wow, that does look the cause. I will file bug. Thanks for figuring this out.

          -David

          • Stephen Bryant

            David,

            No problem at all.  Do you know if there is a list of reserved words for VBCS?

            Source is definitely one of them!

            Thanks again for all your help.  I appreciate it.

            Steve

            • David Konecny

              No, Im not aware of any list of keywords. The UI automatically renames value when they are not allowed, for example typing "int" or "null" as new field label creates field name with "1" appended to it. And trying to change field name to "int" or "null" says there are reserved and not allowed names. So perhaps "source" is missing in the list. Once I hear from dev team I will update this thread.

              -David

              • Stephen Bryant

                Sounds good.  I ended up changing the name of the field and id from source to transactionSource and that fixed it.  Deleting the field also fixes it.

                 

                Steve