How do you export more than 1000 records with integration object?


We are currently on TRIRIGA 3.5.1.3. I have an integration object that uses a static query to export records to a flat file. It works great when I click on the Execute action on the integration object. It can export more than 27,000 records. However, I only want to export a subset of those records, so I am executing it from a custom task as described here.

If there are 1000 records or less to export, executing from a custom task runs as expected. But if there are 1001 records or more, the workflow throws a NullPointerException (NPE). How can I get it to export more than 1000 records?

[Admin: To see other related posts, use the Integration Object tag or Custom Task tag.]

Continue reading

Advertisements

How do you set the report filter for last (previous) month?


I want to create a report and set the filter for last month. When I want to add a condition, it opens the token list with values. Is there any chance I can update that token list? Or does anyone know how to set the filter for the last (previous) month?

Try $$THISMONTH$$-1. You can use operators with the relative time periods for query filters.

[Admin: To see other related posts, use the Query tag or Filter tag.]

Continue reading

How do you change CI Organization Mapping from Org Name to Org ID?


We have multiple organizations with the same name. We would like to change the CAD Integrator > Batch Associate > Organization Mapping to display the Organization ID instead of the Organization Name. How can I change the list from showing Organization Name to show Organization ID?

You will need to change both the Organization Mapping and the query to call only the Organization ID. After that, clear all caches in Admin Console and do a Full Sync in the CAD drawing. Following these steps, we changed the Organization Mapping from showing Name to showing ID and changing it back. It does not appear to have any negative impact, but there has been no detailed regression testing…

[Admin: To see other related posts, use the CAD tag or Integrator tag.]

Continue reading

UX: How do you query for multiple values of one column at one time?


So far I’ve been using triplat-query-filter… This works fine, but I want to search for multiple different names at once. Now I could use a triplat-query-or tag and just use another filter for firstName, but I want the amount of these to be variable, so this wouldn’t be a practical solution. Is there a simple way for me to do this?

Your problem is that there is no “in” operator available. I would suggest you to take a look on the triplat-ds-core, because it allows you to programmatically create the query filters… The triplat-ds-core substitutes the triplat-ds and offers a low-level API. It should not be placed as a child of triplat-query or triplat-ds.

To run the triplat-ds-core you need to call the method “generateRequest”. That method will return a promise that resolves to a result object that contains the queried records. Remember to replace the workersModelAndViewName in the context property. You should use the exposed name of the modelAndView used by your application.

[Admin: To see other related posts, use the Query tag or Filter tag.]

Continue reading

Why is the lease record stuck in “Processing” during activation?


We are running TRIRIGA 10.5.2 and 3.5.2.2. Some of our lease records are getting stuck in “Processing” status after we try to activate the record. Since it is processing, we have no buttons at the top to Revise, Save, etc. This only happens sometimes, and only to lease records that have payment schedules. From the looks of it, all the payment line items do get created. A couple questions:

  • (1) Is there a fix to this to keep it from happening again?
  • (2) Can these records that are stuck in processing be pushed to active or do they have to be re-entered?

I was actually able to apply a workflow fix provided by IBM so that this will not happen going forward. So far, it has been working as planned…

With regards to getting the leases “unstuck”, I created an editable query, imported the State Transition Actions (on the Advanced tab in the query form), and ran the report to select and process the “stuck” leases. This worked with no issues and I did not have to delete or retire the leases. They were functioning properly after getting them out of the “Processing” state.

[Admin: This post is related to the 01.12.16 post about records getting stuck. To see other related posts, use the Performance tag or Workflow tag.]

Continue reading

How do you set up a Group object to leverage query sections?


In the IBM TRIRIGA 3.5.3 and 10.5.3 release, the Group object was redesigned to leverage query sections, instead of a single large smart section. The query sections improve the performance and usability of the Members tab by paginating the results, and providing filtering capabilities. These application changes are a part of the IBM TRIRIGA 10.5.3 application upgrade object migration (OM) package, but can be applied to systems running older application versions.

To help anyone who would like to apply the Group enhancements to an environment not running 10.5.3, the 10.5.3_Group_Query_Enhancement.zip can be downloaded from the Attachments tab. This is an unsupported object migration (OM) package that includes the Group form, queries, and workflows that were created to enhance the application. This OM package can be imported into an environment running on the 3.5.3 platform release.

Note: This enhancement requires the 3.5.3 platform release for the “Add” and “Delete” functions to work within the query section. There are new custom tasks that are called by workflows that handle the adding and removing of group member records, when users or groups are selected. Before applying this OM to a production system, the OM package should be tested in a test or development environment first.

[Admin: This post is related to the 03.07.16 post about best practices for managing your security groups. To see other related posts, use the Security tag.]

Continue reading

IV97769: Filtering on a word in date column gives unexpected results


Filtering on a word in a date or date-time column produces unexpected results.

The platform treated any invalid string as “Today’s Date”. Moving forward, for query reports that have filters enabled, a check was added whenever a user attempts to use an invalid filter in a date or date-time field. If a non-date or non-date-time string is used in this filter, then a “No data to display” message is shown to the user in the body of the query results table, and zero results are returned.

[Admin: To see other related posts, use the Date tag or Filter tag.]

Continue reading