Versions Compared

Old Version 2

changes.mady.by.user Anna Ciepłota

Saved on

compared with

New Version Current

changes.mady.by.user Piotr Koszela

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

Info

There are critical differences between different versions of the product. Keep in mindRemember, depending on the version you are using, you may need to modify the steps listed below. Steps The steps described below are applicable apply to version 8.0.X of BigPicture.

Please note that we do not recommend basing the automation of your business-critical processes in this way , simply because the structure of our plugin's database changes from release to release, and your automation probably will not work with the next version of the plugin (it will need to modify further modified).

Keep in mind:

  • Depending on the synchronization state of synchronization, data contained in the tables may not be up to date.

  • Size The size of the tables may cause script performance issues - the 'join' function is not an optimal way for handling to handle large quantities of data.

  • table names may vary depending on the version of the application (go to the Data Tables section of this article for more information)

The template:

Keep in mind , that you may need to make adjustments as needed. 

...

Info

The above will work when task keys in the table match the following format - 2@1@BPERF5-3398@@BPERF5-3398.

In this case, the resulting report file will return the key simply as - BPERF5-3398, and the report will be generated properlycorrectly.

Field Values

To use the template, modify the field names as needed to include more columns in the results. Keep in mind, if a given field doesn't have a value, it will be empty (this means , you could potentially end up with an empty a blank column)

...

The column on the left will always contain the task key.

...

Any additional columns will display the values of the fields you specify.

In the example above, if you execute the SQL with values:

...

You will get the following result. 

...

Data tables 

Keep in mind , data table names may vary. Make sure to adjust them accordingly.

Depending on the application's version of the application, you might encounter an old version of the table (that is no longer being updated) + a new table that contains current data. 

Info

Four tables have been used in the template:

  • AO_0456E7_RESOURCE_2

  • AO_0456E7_T_CORE_FIELD_DEF

  • AO_0456E7_T_CORE_TASK_2

  • AO_0456E7_T_CORE_FIELD_VAL_2

For versions 8.0.0 - 8.0.18 you should find the following two tables:

Code Block
AO_0456E7_T_CORE_TASK
AO_0456E7_T_CORE_FIELD_VAL

For versions 8.0.19+ the same data will be in tables with a suffix:

Code Block
AO_0456E7_T_CORE_TASK_2
AO_0456E7_T_CORE_FIELD_VAL_2

...


...

In case of any problems

If you are still having trouble following these steps, or your problem is more complicated, you are always welcome to contact our Support Team via the Service Desk. We are always more than happy to help.