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

Advertisements

How do you query which label class is used on which fields?


Is there a way to query which label class is being used on which fields? I want to tweak the existing ones slightly, but I’m not sure what is going to be updated when I make the change.

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

Is there a way to get the proper date value for CBA?


Our workflow sends an outbound message by user action. For the Connector for Business Applications (CBA), the Connector user guide says:

For date values, the outbound query results include the raw values that are stored in the database and the formatted display values that are shown to the user. The displayValue node is added to the query results. The following example shows the default XML structure…

But for us, the outbound message has a different format… The <value> is presented in the same way as <displayValue> which is not acceptable because users may have a different date format. Is there a way to get the proper date value in <value> or use a single <displayValue> format for all users?

Continue reading

Why do queries that are expected to display data show nothing?


When running queries against records within the application, expected record results are not displayed. Why do queries that are expected to display data show nothing at all?

Within the application, we have a variety of different settings that can restrict a user’s access to record data. The user’s Security Group can restrict access to records at the module and BO level, but each use case is slightly different. 

Within every user-facing record, on the System tab, there are fields for System Organization, System Location and System Geography. These values operate in conjunction with similar fields on the Security Group and the User’s People record to allow and restrict access to records. 

The key is that as soon as the user is given a defined Organization, Location, and Geography, the fields on the System tab of their People record are populated. Once that happens, each record they create will be seeded with that information as well. So far, all is well and good, but those users who lack similar settings are now unable to see those newly created records, unless their System fields are the same as or located at a higher point in the hierarchy.

Another area to consider is the Security Group settings for Organization and Geography. If a user has no values set on their People record, the application can still restrict access by using the Security Group values. This can cause a problem as the Organization and Geography Security is defaulted to null in the as-shipped application. This essentially gives the security code no starting point for determining access and will not display records.

To recap, if the record data does not align with the data in the user’s People record, or the data in the user’s Security Group, the record will not be displayed. As mentioned, there are a couple of things to look for. As an Admin user, compare the user’s record data with the record that should be displayed, and correct any misaligned data. Also, in the Security Group, set the Organization and Geography to the root of each hierarchy by default. For additional details, please review the following TRIRIGA wiki article: Security Overview.

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