How do you get max or min value from query in extended formula?


I would like to use an extended formula to resolve my requirement. In the triBuilding form, I need to show the max and min values of triLevelNU of the triFloor which belong to the triBuilding record. So I’ve create a query based on triFloor with a simple association filter on triBuilding record. This query has only two fields: triNameTX and triLevelNU…

I’ve used my query to get all of the triLevelNU values of triFloor. But how can get the max value of this list? When we use the mode “Values”, do we get an array? Is it possible to get the max value from a query?

Continue reading

UX: What is the issue with this triplat-ds-search-input code?


I watched the TRIRIGA 3.5.2 video by Raphael on triplat-ds-search-input, but I could not entirely follow it. I’m new to TRIRIGA UX, and would like to play around with this feature. I tried to follow as closely as I could, but I seem to get the following issue…

As you can see, it gets stuck on loading results (expecting 2 records to show as there are 2 people records with name that has “Hui”). Currently, snippets of my codes can be seen here related to <triplat-ds-search-input>… I noticed that the [[appendFilters]] is actually an empty array. Is that how it’s supposed to be? Also, would there be any sample source codes uploaded for our reference?

Continue reading

UX: How do you get the correct list values in the code?


I’m trying to retrieve list values and I can’t seem to get them in my code. When creating a data source, I selected LIST as the type, and entered the module and the name of the list. Is there anything else required in order to expose the list values?… OK, so I do get the list values, but I have a few issues and questions:

  • 1. I put triProject as the module, and the list name is triProjectType. There are three triProjectType lists in the system and only one in the triProject module, but I receive the wrong list entries. Why?
  • 2. I can’t use the same lookup field style as query data sources. For example, this is the code, where capitalprojectType is the data source. I get the correct number of entries in the drop-down, but the values are empty.

<triplat-ds name=”capitalprojectType” data=”{{_capitalprojectType}}”>
</triplat-ds>

<triplat-select-input value=”{{cprojects.projectType}}” select-src=”{{_capitalprojectType}}” floating-label label=”Project Type *”>
</triplat-select-input>

Here are some answers:

  • 1. You may open a PMR to verify this behavior. It seems in your case that the data source is reading the wrong list.
  • 2. You need to specify the name of the property that you want to show. In your case the select-src array is a list and each object inside a list has a value property. So you need to add the (value-name=”value”) attribute to your triplat-select-input tag.

<triplat-select-input value=”{{cprojects.projectType}}” select-src=”{{_capitalprojectType}}” label=”Project Type *” value-name=”value”>
</triplat-select-input>

Continue reading

What are 20 questions regarding TRIRIGA security vulnerabilities?


IBM TRIRIGA platform development follows the strict rules set within the IBM Secure Engineering Framework (SEF). The full book on the SEF can be found at this link. Here are answers to 20 specific questions. If there are additional questions or concerns not outlined below, refer to the link above.

  1. Have denial of service (DOS) scenarios been considered or tested?
  2. Is sensitive personal information stored encrypted?
  3. Are only input files with valid multipurpose internet mail extensions (MIME) types accepted?
  4. Is input validation performed at the server to prevent URL redirection to an invalid site?
  5. Is input validation performed at the server on any numeric input by ensuring that it is within the expected range?
  6. When accessing a user-controlled array index, is input validation performed at the server to ensure that the ranges are within the target array?
  7. When buffer size calculations are dependent on user input, are buffer size ranges checked to be within expected values?
  8. When copying user input at the server, does the code manage buffer boundaries to avoid buffer overflows?
  9. Does the code manage input length at server to avoid buffer overflows?
  10. Is input data sanitized and validated at the server to protect from OS commanding attacks?…

Continue reading