What is the purpose and impact of the “Localizable” field property?


I’m seeing issues within report results, where if the user profile language is in US English, the results are of one type, but if the user profile language is in German, it is showing some other data. The record while checked is the same for both cases. While opening and checking the record, the ID and name of the record varies from what it showed as a result in the report. While investigating, what we observed is that these fields are marked as “Localizable” in Data Modeler. What is the use and impact of the “Localizable” field property? Any suggestions?

Here is a PDF link to the 3.5.3 Globalization (Localization) user guide. Also, perhaps this technote on localized database storage will help provide some insight.

[Admin: The same question is also posted in the main Application Platform forum. To see other related posts, use the Localization tag or Language tag.]

Continue reading

Advertisements

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

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

How do you add or remove access to the “Form” action of a report?


I’d like to grant or revoke the access to the “Form” button of a report according to the security group of users. But I haven’t find any options related to this button in the Security Manager.

If you can find the action in the business object when it is selected in Security Manager, then you can control it there. If you cannot find the action, you will not be able to manage it there. Some objects are system objects and cannot be modified. This may be one of them.

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

Continue reading

IV97692: Using “In” or “Not In” user filter without quotes gives error


In the Chrome browser, when not enclosing string values in single quotes in a query that uses an “In” or “Not In” user filter, the user gets an error message. The user cannot close the error message and has to close Chrome.

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

Continue reading

Getting an error when running report in TRIRIGA not BIRT designer


I exported the .rpt and the properties file from BIRT report designer, zipped it, and then saved it in the TRIRIGA Document Manager under the respective object (in this case, triProject). I then modified and updated my query report as “External”, and then in the “Options” tab, pointed to the ZIP file from BIRT. However, when I run the report to view the BIRT report, I get a MID error. Meanwhile, the BIRT report works fine when I run it in BIRT report designer.

[Admin: This post is related to the 03.29.17 post about getting an error when evaluating script in TRIRIGA but not BIRT designer, and the 05.11.16 post about running a BIRT report ZIP. To see other related posts, use the BIRT tag.]

Continue reading

Is there a way to export query results as attachment to email?


I have two questions:

  • (1) Is there any way to export the results of a query and send them as an attachment to a particular email ID?
  • (2) Is there any way to schedule to get the report results and automatically send them in Excel to an email ID?

[Admin: This post is related to the 03.15.16 post, 05.04.15 post, and 01.24.15 post about sending BIRT reports via email.]

Continue reading