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

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

RFE: Can you allow users with “no access” to select related reports?


I submitted an RFE to IBM and would appreciate votes if this would help you, too!

Allow users with “no access” to select related reports in embedded query sections and to have access to reports shared with directly with them.

  • “No access” really means that users can still see data in embedded query sections in forms, they just can’t click through to the linked record. There are lots of potential benefits here as we could share reports with specific columns but not allow users to drill in and view data they shouldn’t.
  • “Read Only” access, which I’ve heard as an alternative still allows users to click through query results and view data we may not want them to view.

[Admin: The same question is also posted in the TRIRIGA Around the World Facebook group. To see other related posts, use the RFE tag.]

Continue reading

IV97719: Form action indefinitely spins when form is read-only


When a record is in a read-only state, any form action text links (not a button) on the form no longer run the workflow assigned to the OnClick event for the action. The “busy spinner” comes up and the action is never taken. The only recourse is to close the form window. If the record is editable, the form action text links run their workflows as expected.

The JavaScript in the form field action was losing focus. Moving forward, clicking a form field action when the record is in a read-only state will no longer cause the record to lose focus.

[Admin: To see other related posts, use the OnClick tag or OnChange tag.]

Continue reading

How do you decide that a record must be “Read Only” for a state?


I need some clarification about the state transitions in an object. How do we decide that a record must be in “Read Only” mode for a particular state?

  • (1) Check the “Read Only” property for all the transitions coming into that state.
  • (2) Check the “Read Only” property for all the transitions going out from that state.
  • (3) Both 1 and 2.

Let me know about this, or if there any other situations which can put a record in read-only mode for that state.

[Admin: To see other related posts, use the Read-Only tag.]

Continue reading

IV97614: Cannot revise project in Schedule tab with Gantt section


If you attempt to revise a project from the Schedule tab, where the Gantt chart is visible, your session is expired and you receive an invalid session error. The issue was observed in Internet Explorer and Chrome, but not in Firefox.

An analysis from a Fiddler trace shows that when revising the project in Chrome, this POST to GanttDataUpload.jsp seems to kill the session. In Firefox, for whatever reason, this POST doesn’t occur, and the state transition is successful. To confirm that this is the scenario you are experiencing, use the following technote to run a Fiddler trace and check for the same GanttDataUpload.jsp call: IBM TRIRIGA using Fiddler for tracing web browser traffic.

As a temporary fix, use Firefox. When the record is in a read-only state, no Save action should be called on the Gantt. Moving forward, we resolved the session-kill issue when the user performs a Revise action on a project in the Schedule tab.

[Admin: This post is related to the 08.18.15 post about using Fiddler to trace TRIRIGA web traffic. To see other related posts, use the Gantt tag or Fiddler tag.]

Continue reading

IV96845: Ability to bypass security and use unauthorized functions


Testers found that they had the ability to add reports to the My Reports page in TRIRGA, even though the links for New, Copy, Delete, Copy as Community Report, and Share Report were not present for the read-only users.

Moving forward, an privilege escalation issue in Report Manager has been resolved.

[Admin: To see other related posts, use the Vulnerability tag or CVE tag.]

Continue reading