JoyceALynch 060001T86U Visits (9349)
So you finally got Data Integrator (DI) to bring in the exact records you needed. You had a small celebration - nothing big. Maybe a few balloons and party streamers. But then you realize: "Oh no... All these records are in 'Draft' state, but I need them in an 'Active' state!"
Your heart starts to thump as you envision having to go through these newly imported records one-by-one to activate them. You decide to put off the inevitable by getting another cup of coffee. On your way, you meet TRIRIGA Joe, on his way back from a TRIRIGA Application Development seminar. He tells you what I am going to tell you here: "You don't need to do that!"
So... How can you get the records you just imported into TRIRIGA using Data Integrator out of a 'Draft' state and into an 'Active' state quickly and easily?
While there are multiple ways you can do this, the easiest way to do this might be by using an editable query.
First, you want to start by creating an editable query that shows the records of the type you want that are in a triDraft state. The out-of-box 'triSpace - triDraft - Editable' query shows an example. You will want to do a few things with the query you crea
Next: Run your query. After running your query, you will may want to do the following:
And finally: Select the records you want to activate on the page and click 'Activate!' If all the records you want to activate are on a single page and you want all the records on that page activated, click the button to select all records on that page and click 'Activate.' If there are multiple records on the page that you want to activate but you don't want all of them activated, select only the records on that page you want activated and click 'Activate.' If your records are spread across multiple pages, go to each page that is present and repeat the process.
And you are done. Before you even finish drinking that fresh cup of coffee you picked up!
JeffLong 270005B0Q4 Visits (10322)
Note: This tip can be used with reports from the System Reports tab in My Reports or Report Manager.
You can follow the steps below to troubleshoot Tririga reports and see if the SQL returns data:
If the report SQL does not return data, then that explains why the report is not returning data, there is no data for the report to display. Add data and test the report again, the report should return data if the SQL does.
If the SQL returns data but the report does not display data, this is likely a report problem. To troubleshoot this, refer to information available online or contact support.