Prev
Next
Forums Mashup Designer

Trim doesn't seem to work

Sort:
You are not authorized to post a reply.
Author
Messages
John W 123
Basic Member
Posts: 5
Basic Member
11/16/2015 8:05 PM

     

    The objective of this mashup is to provide a user with full visibility to cash transactions to a specific cash account.   Visibility includes the cash book header and all associated line items.  Using Trans-Nbr and Cash-Code fields as keys.

    I am using the newer version of mashup designer that works with Smart Office 10.2.1.0.63.   I have a datapanel for CBTRANS and set a condition to trim the blanks from Trans-Nbr field that is used to link to the CBDISTRIB datapanel.    I use the event of the CBTRANS datapanel and control DataRowSelected to display line items from CBDISTRIB.    It only works for a Trans-Nbr that occupies the full field of 10 characters.  Anything less does not link to the CBDISTRIB file because there are leading blanks.   I can remove the leading blanks manually and it finds records, however, it really simply does a "contains" on the field since other Trans-Nbr fields are showing up that contain the Trans-Nbr string that I want.  

     

    What is going on here?  Do I have to do something radically different between the old and new designer to make this work?

     

    BTW, the older version of the mashup designer that works with 10.0.5.4.28, does not have the DataRowSelected control so I have to use FormKeySelected and it seems to work fine with NO conditions set for trim.  It is simple and works.   I tried to use these same settings in the new designer but it doesn't link to CBDISTRIB and I have the same problem with leading zeros!  I was hoping a condition on the CBTRANS with trim would work, but to no avail.

     

    Any thoughts here?

     

     

    Retired, no longer active.
    John W 123
    Basic Member
    Posts: 5
    Basic Member
    11/20/2015 5:59 PM
      I figured this out by looking at the examples provided with the Mashup Designer.  Go to Help...Common Controls...Data Manipulation for an example that shows how to manipulate data before it is sent to a control.
      Retired, no longer active.
      Patrick Dowd
      Advanced Member
      Posts: 25
      Advanced Member
      12/28/2015 3:39 PM

        I'm a little late to the game here but you do have the ability to trim event parameters.  Although there isn't a trim option within the event itself, you can manually do this within your xaml.  If you expose the xaml and locate the Parameter that you would like to trim (e.g. Parameter=TRANS-NBR), you simply single-click anywhere on that line and a Trim  check box will appear on the Properties tab on the right hand side.

        Alternatively, you can simply type Trim="true" at the end of the Event Parameter line in question.

        You are not authorized to post a reply.