How can I check if a field has one among a set of values in the switch task of a workflow? For example, whether the field cstNameTX has either “a” or “b” or “c”? I tried the Switch task with the expression similar to the following, but it doesn’t work: cstNameTX == (“a” || “b” || “c”). Should I try the following expression: cstNameTX == “a” || cstNameTX==”b”, etc.? Is there a system function for this?
You can nest the switches instead of trying to have multiple entries in the expression…
[Admin: To see other related posts, use the Switch tag.]
I’m currently working on an application upgrade. When I generated a comparison report, I found a weird conflict. The “Live Link” option belongs to smart sections, but in the report, this option is available for a classification field. Should we ignore this conflict? Because there is no “Live Link” option in the Data Modeler for a classification field.
I would like to know if there is a way to compare two lists of triContactRole records and find the records that are not in both lists. The case is as follows: (1) One list of triContactRole records is associated to the triCapitalProject object. (2) The other list of records is associated to the triPurchaseOrder object. (3) So I would like to copy the triContactRole records from capital project to purchase order, but only those that do not already exist in purchase order. Is there any way to do that?
One way might be to have a workflow where a Query task grabs all of the resulting contact role records associated to the capital project record. Then have an Iterator (Iter) task that goes through each of those records. Within the Iter, you can have another Query task grabbing the contact role records of the purchase order record using the Iter record as a filter. Then have a Switch task that says if the result count of the second Query task = 0, then create the contact role record for the purchase order record.
[Admin: To see other related posts, use the Iterator tag.]
In a Gantt section, the section is not honoring the associated report sort order.
The issue was caused by the dynamic ordering that was implemented by the project tasks’ internal tree set. The BO query comparison was performed by using the string form of the columns. Moving forward, we resolved an issue where the default Gantt sort ordering, and the sort ordering immediately after importing an MPP project file, did not correctly order by the sequence ID based on the Gantt section query configuration.
[Admin: This post is related to the 06.14.17 post about task date issues when importing MS Project (MPP) files. To see other related posts, use the Gantt tag.]
I’m making a query and need to check one field in a form against another field in the same form to see if they are equal. I’ve seen examples where you can compare from the current object to $$Parent::RecordInformation::triDivision$$. But the field I want to compare is on the same record. I’m hoping to not have to make a new field and workflow. How do I do this?
[Admin: To see other related posts, use the Comparison tag.]
We’re unable to run an object migration (OM) comparison on the TRIRIGA 3.5.1 platform, when we select the background option. When we try to run a compare after loading the OM package on the 3.5.1 platform, it repeats the same rows in the object migration log file.
It appears to keep re-running the compare multiple times (about 1 hour per run), and it does not work or present results. Specifically, the problem happens when the background comparison result is run, and the OM package contains UX Metadata (used in the UX Framework).
I want to do a custom sort of my status field in the work task for an OSLC query. I planned to implement this by adding an extended formula field, to calculate an index based on the status ID value, by which the sort order would represent what I want. But when I started this, I came across a problem: How do you compare the status with a value in the “if” condition of an extended formula?