How do you use report filters with date and time fields?


We have an issue from a user where he mentions that “Report filters for dates are not displaying properly”. This issue is happening when the user is using the triCreatedSY field in user filters. I added a date-time field to an existing report and chose the filter of “After”. When I run the report, the filter says “Contains” that also does not work. I entered the date of one of the items in the report and it did not return that item…

The system is providing the filter operator similar to the date fields, but it is not working no matter what date we give or what operator we use. We tried the same for other date fields which ends with “DT” but those work fine. I looked in the field properties of the triCreatedSY field and found the property “Sub Attribute Type = Created DateTime (Number)”. In the TRIRIGA user guide (PDF), I found the following information…

My understanding is if the user wants to use the triCreatedSY field, then we have to add a field “Created DateTime Number” on the BO. Based on the PDF, when I added a field on the BO, no information is getting populated in that field. It looks like there should be a way to map it. Is my understanding correct? Will it be a good solution to apply the changes as mentioned in the user guide? Or can we suggest an alternative to the user?

The triCreatedSY field is actually a timestamp field, so it acts like a string. You’ve started in the right direction by creating a new Created DateTime field, but it needs to be a Field Type = “System Read Only” and the Sub Attribute Type = “Created DateTime (Number)”. Note that previously created records will not have this field populated.

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

Continue reading

Advertisements

Why does the integration object fail with a smart section filter?


I’m using the TRIRIGA integration object (File method) to import data into the space BO. I created the Data Map properly, but my records are not importing because of the following error:

“Could not get recordId for smartSection[triCurrentSpaceClass] on row[1], column[6] with value[3]. Record was not saved.”

Even though I selected the Smart Section filter and mapped it to triNameTX, the integration object fails. Any thoughts?

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

Continue reading

How do you limit or filter the space class current results in CI?


I created a child classification in the Space Class Current classification. In TRIRIGA, I am able to filter the selection to just this child classification via the filter in Report Manager. However, for my CAD Integrator users, it seems to be pulling the entire Space Class Current classification. Is it possible to limit that list in CAD Integrator?

Okay, I figured it out. In CAD Mapping, there is a Report Filter that is referencing a query called “triSpaceClassCurrent – CI – Available Space Class”. In this query, I added filters to filter down the list.

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

Continue reading

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

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

How do you filter records by month on “Created Time” column?


How do you use a report “User” filter based on the “Created Time” column on a DataConnect table report? When you try to set a “User” filter in a TRIRIGA report by using the Filter operator “Contains” or “Equal”, it does not work. The field seems to be encoded in the timestamp, but it is displayed in text such as “10/05/2017”.

Is there a way to use the column so the end user filter on the value gets only the records created in September (“09/2017”)? Unfortunately, the general system information with the type “System Read Only” does not seem to be a date. So operators like “More Than/Equals” or “Less Than/Equals” are not available.

[Admin: To see other related posts, use the Filter tag or Date 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