IV90394: Number field doesn’t preserve value when navigating

If you enter a value into a number field that has no unit of measure (UOM), then without clicking anywhere else or tabbing away, but rather, clicking on a different record tab, when you then return to the original tab, the value that you entered into the number field has been cleared…

UX: How do you populate and save the data source UOM values?

I’ve defined my UX app like this:

• Data Source Type: UOM
• Business Object: UOM_values (UOM_values)
• Module: System
• UOM Type Name: Currency
• Legacy Form: UOM_values (UOM_values)
• Fields: _UOM_Value (Data Type: String)

My HTML code is like this:

<triplat-ds name=”currencyType” data=”{{_currencyType}}”></triplat-ds>
<triplat-select-input
value=”{{general.currencyType}}”
select-src=”{{_currencyType}}”
floating-label label=”Units *”
value-name=”_UOM_Value”>
</triplat-select-input>

My JavaScript is like this:

_onSaveTap: function() { this.$.generalDs.updateRecord().then(function() { this.$.toast.show(); }.bind(this)); }

Is there anything else required in order to populate and save the values? I want to display all options like a list and be able to save the selected currency. I can already click and display them like a list, but the first value doesn’t show up. If I do an inspect element, I can see my value fine.

If I understand your question, there are two parts to it:

• 1) Populate UOM values similar to a list using triplat-select-input: This component was not designed to display UOM values. However, you should still be able to populate it from a UOM data source. For further filtering, you can use the filtered-data property and triplat-query-filter on the client.
• 2) Save UOM value via a UX application: We do not provide the ability to persist or change a UOM value via the application yet. At present, we only support displaying a UOM value through the triplat-uom component.

Why does the DataConnect task throw a stack trace error?

I have a DataConnect (DC) task (triOption) that worked before, but has stopped working and throws a stack trace. The main DC task runs. But this is a sub DC task. The BO is published. I was advised to check if the necessary UOMs (units of measure) are in the staging table.

So my dumb question is: Does it mean every NU (number) that contains a UOM needs a corresponding UOM column? For example, TRISUBTOTALNU, TRISUBTOTALNU_UOM, and TRIRATENU would need TRIRATENU_UOM?

There seems to be a problem with your metadata, and probably not your DC staging table metadata, but maybe with the triOption’s fields metadata. I tried to reproduce this issue and was unable to reproduce it with various numbers and UOM fields. As for your questions…

Is there a way to display the UOM abbreviation instead of its name?

In the definition of a Unit of Measure, where you fill out the UOM name, the abbreviation, mask, symbol, etc., is there a way to display the abbreviation or the symbol instead of the name? Like instead of US Dollars, use the symbol $ or the abbreviation USD? What are those fields for and when are they used?

At runtime, the “Currency Symbol” will be used to represent the currency value. In the drop-down, where you can select a new UOM, the “UOM” field value is used. I hope this answers your question.

What is the Display Mask format to display two decimal spaces?

What is the format for the Display Mask to display a format with the same number of decimal spaces in TRIRIGA? For example, the customer wants a standard 2 spaces after the decimal: 4.26 meters or 4.30 meters for uniformity. I cannot seem to get the zero to show.

Another issue is the delimiter is a space instead of a comma: 2,000.00 to show as 2 000,00? Changing the base language in the profile will automatically change the period to the comma, but I cannot delimit the number by a space, even by changing the UOM format.

IV82049: Exporting to Excel displays different decimal places

When exporting a TRIRIGA report to Excel format, only 3 decimal places are being displayed when there are clearly 4 in the report.

We needed a change in the TRIRIGA platform to pass additional information into the transform to Excel, and to adjust the built-in display mask based on the decimal precision in the Data Modeler. Moving forward, Excel exports will now honor the custom decimal precisions for decimal numbers set in Data Modeler. However, if the currency UOM for the number is Japanese Yen, it will display without decimals regardless.

How do you get the UOM value of a field?

I need to get the UOM value of a field to use it in a formula. This value determines what formula to trigger in another field. I noticed that there is a system formula allowing us to get the UOM type: “getUomType (recordId, fieldName)”. But I didn’t find another formula like this to get the UOM value. Has anyone been confronted with this case?

How do you show a TRIRIGA field as a negative number?

How do I show a TRIRIGA field as a negative number? For example, how do I show the dollar amount of $1,000 as ($1,000) with parentheses?

You can check the IBM TRIRIGA Application Building user guide [PDF] in our IBM Knowledge Center. In Chapter 3: Field Data Types > Units of Measure section > Number Formats, there are examples of using display masks. See Table 18.

IV79858: Values in square-inches when the UOM is square-feet

While loading space area information via CAD Integrator, the user noticed that the values that were getting put into the TRIRIGA space record were actually calculated in square-inches, even though the UOM was square-feet. I was able to replicate the problem by first creating a building that had the UOM set to square-inches, creating a floor record, and using the client drawing to create and load the space data. When the building UOM was changed to square-feet and activated, the data converted properly and the UOM on both floor and space records showed the proper values. A subsequent update and refresh from the CAD drawing resulted in the affected space getting the area in square-inches instead of square-feet.

As a temporary fix: (1) Click CI menu > Detach > Detach Drawing. In the popup form, click No. This option will just detach the floor and keep the linked information of boundaries. (2) Click CI menu > Attach > Drawing. Select the floor to attach and click OK. (3) Run Sync Full. This will update the area correctly in square-feet. As a result, we updated Sync Areas and Sync Full to account for a change in the area units of the top-level record (typically, the floor/building record), and to update the areas correctly.

Having an issue with TRIRIGA BIRT reports and number fields

I am working on a Crystal-to-BIRT report conversion with TRIRIGA and I am facing one problem. I have one number field with UOM (field is rate) in TRIRIGA. In BIRT, the data type is Java Object. When this field has a value in the database (like 1, 2, etc.), the report is printing correct in the output. But if this value is 0, it’s showing no value in the BIRT output, just a blank field. Any suggestions?