Automate

I need to know the recording mode of transaction scripts like what you see when you open the script in Automate and go to details.  I can only find it in RPT_TransactionRoiView.  This table lists every time a transaction script is ran, I just need the details of just the script.  Is there another table that contains the recording mode for a script?  

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK
------------------------------

Hi Anita

It's in the View RPT_TransactionRoiView - can you check your Evolve system?  I'm on 24.1, but I know it was in earlier versions.

FYI

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 08-15-2024 11:43
From: Anita Mefford
Subject: Evolve Report

I need to know the recording mode of transaction scripts like what you see when you open the script in Automate and go to details.  I can only find it in RPT_TransactionRoiView.  This table lists every time a transaction script is ran, I just need the details of just the script.  Is there another table that contains the recording mode for a script?  

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK
------------------------------

Correct, I do have it in RPT_TransactionRoiView but this table is for transactions so only the scripts that have been ran are showing up in this table.  The data has to be stored in another table with all the other script details but I haven't found it.  I would of expected it to be in RPT_SolutionView but it's not there.  

When I pull the data from RPT_TransactionRoiView.  I'm doing a Select Distinct RPT_TransactionRoiView.TxrTitle, it only returns 181 scripts.  We have 488 scripts.  I need the recording mode for all 488 scripts.

Version 20.3.2

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK

Original Message:
Sent: 08-15-2024 21:08
From: Sigrid Kok
Subject: Evolve Report

Hi Anita

It's in the View RPT_TransactionRoiView - can you check your Evolve system?  I'm on 24.1, but I know it was in earlier versions.

FYI

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 08-15-2024 11:43
From: Anita Mefford
Subject: Evolve Report

I need to know the recording mode of transaction scripts like what you see when you open the script in Automate and go to details.  I can only find it in RPT_TransactionRoiView.  This table lists every time a transaction script is ran, I just need the details of just the script.  Is there another table that contains the recording mode for a script?  

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK
------------------------------

Hi Anita

There are a couple of tables in the DB, not views, that have script info, but they have id's and codes in them. They include any kind of script solution, including reference data lists.

FR_FileInfo_ScriptFiles

FR_MetaInfo_ScriptFiles

You can join by ScriptId

There will be entries for every version.

Please note the tables may change, which would be shielded if you use the views.  But if the views don't have what you need, perhaps you can supplement them with info from tables.

Hope that gives you some ideas,

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 08-19-2024 09:07
From: Anita Mefford
Subject: Evolve Report

Correct, I do have it in RPT_TransactionRoiView but this table is for transactions so only the scripts that have been ran are showing up in this table.  The data has to be stored in another table with all the other script details but I haven't found it.  I would of expected it to be in RPT_SolutionView but it's not there.  

When I pull the data from RPT_TransactionRoiView.  I'm doing a Select Distinct RPT_TransactionRoiView.TxrTitle, it only returns 181 scripts.  We have 488 scripts.  I need the recording mode for all 488 scripts.

Version 20.3.2

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK

Original Message:
Sent: 08-15-2024 21:08
From: Sigrid Kok
Subject: Evolve Report

Hi Anita

It's in the View RPT_TransactionRoiView - can you check your Evolve system?  I'm on 24.1, but I know it was in earlier versions.

FYI

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 08-15-2024 11:43
From: Anita Mefford
Subject: Evolve Report

I need to know the recording mode of transaction scripts like what you see when you open the script in Automate and go to details.  I can only find it in RPT_TransactionRoiView.  This table lists every time a transaction script is ran, I just need the details of just the script.  Is there another table that contains the recording mode for a script?  

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK
------------------------------

I dont see the tables only the SQL Views.  Is there a setting in Evolve I need to change?

Hi Anita

There are a couple of tables in the DB, not views, that have script info, but they have id's and codes in them. They include any kind of script solution, including reference data lists.

FR_FileInfo_ScriptFiles

FR_MetaInfo_ScriptFiles

You can join by ScriptId

There will be entries for every version.

Please note the tables may change, which would be shielded if you use the views.  But if the views don't have what you need, perhaps you can supplement them with info from tables.

Hope that gives you some ideas,

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 08-19-2024 09:07
From: Anita Mefford
Subject: Evolve Report

Correct, I do have it in RPT_TransactionRoiView but this table is for transactions so only the scripts that have been ran are showing up in this table.  The data has to be stored in another table with all the other script details but I haven't found it.  I would of expected it to be in RPT_SolutionView but it's not there.  

When I pull the data from RPT_TransactionRoiView.  I'm doing a Select Distinct RPT_TransactionRoiView.TxrTitle, it only returns 181 scripts.  We have 488 scripts.  I need the recording mode for all 488 scripts.

Version 20.3.2

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK

Original Message:
Sent: 08-15-2024 21:08
From: Sigrid Kok
Subject: Evolve Report

Hi Anita

It's in the View RPT_TransactionRoiView - can you check your Evolve system?  I'm on 24.1, but I know it was in earlier versions.

FYI

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 08-15-2024 11:43
From: Anita Mefford
Subject: Evolve Report

I need to know the recording mode of transaction scripts like what you see when you open the script in Automate and go to details.  I can only find it in RPT_TransactionRoiView.  This table lists every time a transaction script is ran, I just need the details of just the script.  Is there another table that contains the recording mode for a script?  

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK
------------------------------

Hi Anita

The report builder in Evolve only shows views, as that is the recommendation for creating reports.

If you want to access tables, you will need read access to the Evolve database.  Please ask your DBA or IT team.

Best Regards,

Sigrid

I dont see the tables only the SQL Views.  Is there a setting in Evolve I need to change?

Hi Anita

There are a couple of tables in the DB, not views, that have script info, but they have id's and codes in them. They include any kind of script solution, including reference data lists.

FR_FileInfo_ScriptFiles

FR_MetaInfo_ScriptFiles

You can join by ScriptId

There will be entries for every version.

Please note the tables may change, which would be shielded if you use the views.  But if the views don't have what you need, perhaps you can supplement them with info from tables.

Hope that gives you some ideas,

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 08-19-2024 09:07
From: Anita Mefford
Subject: Evolve Report

Correct, I do have it in RPT_TransactionRoiView but this table is for transactions so only the scripts that have been ran are showing up in this table.  The data has to be stored in another table with all the other script details but I haven't found it.  I would of expected it to be in RPT_SolutionView but it's not there.  

When I pull the data from RPT_TransactionRoiView.  I'm doing a Select Distinct RPT_TransactionRoiView.TxrTitle, it only returns 181 scripts.  We have 488 scripts.  I need the recording mode for all 488 scripts.

Version 20.3.2

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK

Original Message:
Sent: 08-15-2024 21:08
From: Sigrid Kok
Subject: Evolve Report

Hi Anita

It's in the View RPT_TransactionRoiView - can you check your Evolve system?  I'm on 24.1, but I know it was in earlier versions.

FYI

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 08-15-2024 11:43
From: Anita Mefford
Subject: Evolve Report

I need to know the recording mode of transaction scripts like what you see when you open the script in Automate and go to details.  I can only find it in RPT_TransactionRoiView.  This table lists every time a transaction script is ran, I just need the details of just the script.  Is there another table that contains the recording mode for a script?  

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK
------------------------------

This is a SAAS product so would Precisely be the one to ask?

Hi Anita

The report builder in Evolve only shows views, as that is the recommendation for creating reports.

If you want to access tables, you will need read access to the Evolve database.  Please ask your DBA or IT team.

Best Regards,

Sigrid

I dont see the tables only the SQL Views.  Is there a setting in Evolve I need to change?

Hi Anita

There are a couple of tables in the DB, not views, that have script info, but they have id's and codes in them. They include any kind of script solution, including reference data lists.

FR_FileInfo_ScriptFiles

FR_MetaInfo_ScriptFiles

You can join by ScriptId

There will be entries for every version.

Please note the tables may change, which would be shielded if you use the views.  But if the views don't have what you need, perhaps you can supplement them with info from tables.

Hope that gives you some ideas,

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 08-19-2024 09:07
From: Anita Mefford
Subject: Evolve Report

Correct, I do have it in RPT_TransactionRoiView but this table is for transactions so only the scripts that have been ran are showing up in this table.  The data has to be stored in another table with all the other script details but I haven't found it.  I would of expected it to be in RPT_SolutionView but it's not there.  

When I pull the data from RPT_TransactionRoiView.  I'm doing a Select Distinct RPT_TransactionRoiView.TxrTitle, it only returns 181 scripts.  We have 488 scripts.  I need the recording mode for all 488 scripts.

Version 20.3.2

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK

Original Message:
Sent: 08-15-2024 21:08
From: Sigrid Kok
Subject: Evolve Report

Hi Anita

It's in the View RPT_TransactionRoiView - can you check your Evolve system?  I'm on 24.1, but I know it was in earlier versions.

FYI

Sigrid

------------------------------
Sigrid Kok
Precisely Software Inc.

Original Message:
Sent: 08-15-2024 11:43
From: Anita Mefford
Subject: Evolve Report

I need to know the recording mode of transaction scripts like what you see when you open the script in Automate and go to details.  I can only find it in RPT_TransactionRoiView.  This table lists every time a transaction script is ran, I just need the details of just the script.  Is there another table that contains the recording mode for a script?  

------------------------------
Anita Mefford
Sr. Developer
ConocoPhillips
Houston OK
------------------------------