UX: How do you create an editable query by using the UX framework?


What is a way to create an analogue of an editable report using UX framework?

You can accomplish this by doing the following:

  • 1. Create the query data source.
  • 2. In the code, create an iterator over the data (dom-repeat or iron-list).
  • 3. Either add a button for saving, or catch the on-change event in order to commit the data to the database by using the triplat-ds updateRecord method.

In newer platforms, you can look into triblock-table as well. I’ve never used it, but you can definitely create custom components inside the cells in order to make displaying data easier.

[Admin: To see other related posts, use the UX Framework tag or Perceptive tag.]

Continue reading

Advertisements

Why is a cost code path corrupted when applying a template?


We have an issue where sometimes after applying a cost code template to a project, the hierarchy path will not be complete. It will be missing all of the parent path and only shows the name. This issue is only visible in the app by viewing the System Path field inside the form or by using a SQL query, because the system path in the T_TRICOSTCODE table is correct, but the object path field in the IBS_SPEC table is the one that’s not complete. The issue does not have much consequence unless you are using the rollup fields, in which case the corrupt cost code path will cause a posted transaction to fail.

If there are customers who use cost codes heavily, you can try running the following SQL, and if you get any results back, then that means the issue is present at some level in your environment. It is not necessary that you use the Apply Template to create your cost codes, as I have heard of others having the issue where their cost codes are created via an integration. This SQL is for Oracle and may need a tweak for SQL Server. If any customers can run this, and see if they have the issue, it may help us identify how it happens.

select tripathsy, triprojectnamesy, OBJECT_PATH from t_tricostcode T1, IBS_SPEC T2 where T1.spec_id in (select spec_id from ibs_Spec where type_name = ‘triCostCode’ and object_path not like ‘%\Cost Code%’) AND T1.spec_id = T2.spec_id and tripathsy like ‘%\Cost Code%’

[Admin: To see other related posts, use the Cost Code tag or Templates 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 export more than 1000 records with integration object?


We are currently on TRIRIGA 3.5.1.3. I have an integration object that uses a static query to export records to a flat file. It works great when I click on the Execute action on the integration object. It can export more than 27,000 records. However, I only want to export a subset of those records, so I am executing it from a custom task as described here.

If there are 1000 records or less to export, executing from a custom task runs as expected. But if there are 1001 records or more, the workflow throws a NullPointerException (NPE). How can I get it to export more than 1000 records?

[Admin: To see other related posts, use the Integration Object tag or Custom Task 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

How do you change CI Organization Mapping from Org Name to Org ID?


We have multiple organizations with the same name. We would like to change the CAD Integrator > Batch Associate > Organization Mapping to display the Organization ID instead of the Organization Name. How can I change the list from showing Organization Name to show Organization ID?

You will need to change both the Organization Mapping and the query to call only the Organization ID. After that, clear all caches in Admin Console and do a Full Sync in the CAD drawing. Following these steps, we changed the Organization Mapping from showing Name to showing ID and changing it back. It does not appear to have any negative impact, but there has been no detailed regression testing…

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