UX: How do you create and save a record in UX via a workflow?


I’ve got most of this worked out. So I can trigger a workflow from a UX web page. But I am stuck on how to take data created in the UX application, feed it to the workflow, place that data into record fields, and then create a draft record. This is the UX code that is feeding data back to TRIRIGA. The data is valid. I am just stumped on how to feed it into a workflow. Any ideas?

var newRec = {
triHoursNU: vFixedTotal,
triControlNumberCN: triControlNumberCN,
triDateTX: mm + “/” + dd + “/” + yyyy, 
triIdTX: triIdTX,
triNameTX: fName + ” ” + lName
};
console.log(newRec);
this.$.timeLogQueryDs.createRecord(newRec, TriPlatDs.RefreshType.BOTH, 
“createLog”, “create” ) 
.then(function(){
this.$.toastBlue2.show(); 
}.bind(this));

 

When you create a record, let’s say you have a data source called “peopleDs”, you create an object and then pass it to the create method of the data source. The names should match the data source exposed field names. I also recommend looking at the documentation for your TRIRIGA instance at: /p/web/doc.

[Admin: The same question is also posted in the main UX Framework forum. To see other related posts, use the UX Framework tag or Perceptive tag.]

Continue reading

Advertisements

What are the Oracle Database settings for 10.5.2 and 3.5.2?


I wanted to see if anyone has set up the following settings in an Oracle Database for TRIRIGA 10.5.2 and 3.5.2:

  • 1. NLS_LENGTH_SEMANTICS: Should this be set to CHAR? In our current production environment, it’s set to BYTE, but the TRIRIGA support documentation says that this can lead to data loss, so they recommend using CHAR.
  • 2. NLS_CHARACTERSET: This is set to WE8ISO8859P1 in our current production environment, but the support document says that it must be UTF-8 or UTF-16.
  • 3. Block size: This is set to 8k, but the documentation recommends using 16k.

For (1) and (2), if you never want to store multibyte characters, then what you have is fine. But if you do, then you must use what the support documentation suggests.  Once you have your database created, it is difficult and time-consuming to change it, and it needs to be done outside of TRIRIGA. As for (3), I would encourage you to use 16k, since it will allow you better throughput and paging, unless you have a strong reason why you need to stay at 8k.

[Admin: This post is related to the 04.04.16 post about database character settings. NLS refers to National Language Support parameters in Oracle. To see other related posts, use the Multibyte tag, MBCS tag, or NLS tag.]

Continue reading

How do you use Dynamic Workflow settings in Call Workflow task?


I am looking for some explanations for the “Dynamic Workflow” property settings in the Call Workflow task. When should I use it?

The Dynamic Workflow property and fields allows you to pull the workflow name to execute from a task > field, instead of the workflow name being hard-coded in the workflow. The field must contain the workflow name to execute.

Excerpt from the “Application Building” (3.5.3, PDF) user guide:

Dynamic Workflow: The values of this field are used to dynamically define the name of the workflow that this task will launch. For the “Task with Workflow Name” drop-down list, select the task record that contains the workflow name. For the “Workflow Name Field”, select the field on the task record that contains the workflow name. This record field must contain the workflow name that you want to launch.

[Admin: To see other related posts, use the Workflow tag or Workflow Builder tag.]

Continue reading

Is there any tool which imports currency conversion rates?


We are looking for an integration solution which allows you to import currency conversion rates. It seems that this data is not based on a BO, so I think traditional integration tools such as DataConnect (DC), Data Integrator (DI), and Integration Object won’t work. Have you seen this kind of requirement? Are there any solutions other than using SQL script? I’ve tried the SQL below, and it seems to be working.

INSERT INTO BUDGET_CURRENCY_CONVERSION (CONVERSION_GROUP, FROM_CURRENCY_CODE, TO_CURRENCY_CODE, CONVERSION_RATE, START_DATE, END_DATE, INSTANCE_ID) VALUES (‘LIBA’, ‘Chinese Yuan’, ‘Euro’, 0.13, {ts ‘2017-01-01 01:00:00’}, {ts ‘2017-12-31 01:00:00’}, BUDGET_CURRENCY_ID_SEQ.nextval)

BusinessConnect (a.k.a. Connector for Business Applications or CBA) is the best method to use for this. Here’s the PDF. The putCurrencyConversionRates method is what you would want to use.

[Admin: To see other related posts, use the Currency tag.]

Continue reading

Is there a way to clear server caches without Admin Console?


Is there a way to clear server caches without logging into the Admin Console?

Beginning in IBM TRIRIGA Platform 3.5.1, TRIRIGA delivered an enhancement for this to be done via workflow. The pertinent release notes can be found from this wiki page. Here is an excerpt from the release notes on the topic:

A custom task class has been added for workflow which triggers a global cache clear across all servers. 

You can create a custom task and specify the following in the class field: com.tririga.platform.admin.cache.web.CacheProcessingCustomTask $RefreshAllCache

The custom task will perform a global cache clear on the server where the workflow runs as if it were triggered from that server’s Administrator Console. (Tri-211723)

[Admin: To see other related posts, use the Admin Console tag or Cache tag.]

Continue reading

Does anyone know about Trinity for data import and export?


We are in the process of upgrading our TRIRIGA installation from 3.4.1/10.2.x to 3.5.2/10.5.2 and have run into an issue with Trinity, something that Global Services set up for us to import and export data to external systems. Does anyone know anything about it? Or know where to find any product documentation?

I work in IBM TRIRIGA Support as an L2 Support Engineer. I can tell you that Trinity is not a supported product and you would need to reach out to IBM Global Business Services (GBS) for assistance with this. I recommend starting out with a call to the IBM General Inquiries number to get in touch with GBS. That phone number is: 800-IBM-4YOU (800-426-4968).

Continue reading

IV97252: Trying hatch patterns in graphics section floor plans


We would like to use hatch patterns instead of solid fills in our graphics. There is a TRIRIGA wiki page “Graphics Section Hatching” that outlines how this can be done, but it isn’t working.

We needed to perform a server-only change. We needed to verify the uploaded image files in the CI hatch pattern record, and see the pattern rendered in the graphics section. Moving forward, we resolved an issue where assigning hatch records to the record results in the graphics section reports did not actually render the hatch images as expected.

[Admin: This post is related to the 06.03.15 post about displaying hatch patterns in graphics sections. To see other related posts, use the Hatch tag.]

Continue reading