Automate

Does anyone have a table map or listing of how the standard views in Automate Evolve are joined in the SQL developer within Evolve?

Thank You,

Hi Andrew,
Evolve views are created with Encryption and definition is not available directly.
Is there any specific view that you need information for?

Regards

Does anyone have a table map or listing of how the standard views in Automate Evolve are joined in the SQL developer within Evolve?

Thank You,

Hi Hammad,

I'm looking for the join criteria for the "Reporting SQL Views" (see image below).  I'm trying to create my own reports, but I can't find any documentation that provides the standard join criteria.

Thanks,
Andrew

Hi Andrew,
Evolve views are created with Encryption and definition is not available directly.
Is there any specific view that you need information for?

Regards

Does anyone have a table map or listing of how the standard views in Automate Evolve are joined in the SQL developer within Evolve?

Thank You,

Hi Andrew,
can you specify your use-case or brief what report you are trying to generate so that I can specify the join criteria between SQL views required, I believe we do not have anything like this published that can define criteria on all views.
Here is an example, RPT_SolutionView can be joined to RPT_TransactionRoiView based on SolutionId.
most of the views that can be joined should have similar column names.
---------------
Regards
Hammad Naeem

Hi Hammad,

I'm looking for the join criteria for the "Reporting SQL Views" (see image below).  I'm trying to create my own reports, but I can't find any documentation that provides the standard join criteria.

Thanks,
Andrew

Hi Andrew,
Evolve views are created with Encryption and definition is not available directly.
Is there any specific view that you need information for?

Regards

Does anyone have a table map or listing of how the standard views in Automate Evolve are joined in the SQL developer within Evolve?

Thank You,

Hi Hammad,
I'm looking to join a RPT for a parent form solution, a RPT for a child form solution, and RPT_ProcessReportingDetailsView to be able to see the status of a given request.  There are promoted fields on the parent and child forms and I'm able to join these easily.  How do I join the RPT_ProcessReportingDetailsView to a solution view?

Thanks,
Andrew

Hi Andrew,
can you specify your use-case or brief what report you are trying to generate so that I can specify the join criteria between SQL views required, I believe we do not have anything like this published that can define criteria on all views.
Here is an example, RPT_SolutionView can be joined to RPT_TransactionRoiView based on SolutionId.
most of the views that can be joined should have similar column names.
---------------
Regards
Hammad Naeem

Hi Hammad,

I'm looking for the join criteria for the "Reporting SQL Views" (see image below).  I'm trying to create my own reports, but I can't find any documentation that provides the standard join criteria.

Thanks,
Andrew

Hi Andrew,
Evolve views are created with Encryption and definition is not available directly.
Is there any specific view that you need information for?

Regards

Does anyone have a table map or listing of how the standard views in Automate Evolve are joined in the SQL developer within Evolve?

Thank You,