Hi, that's the correct way to do it. Are you using SQL or Postgres?  Do you want to share the create view script you are using? 

Best regards!

Hi, I am using SQL script. Please find my script below for creating view.

'UsrShow' is the object which i created in my app.

IF OBJECT_ID('UsrShow', 'V') IS NOT NULL BEGIN
    DROP VIEW UsrShow;
END
GO

CREATE VIEW UsrShow (
        Id,
        Name
    ) AS
SELECT
    NEWID() [Id],
    UsrShow.Name
FROM UsrShow

It shows below error

I donno what i am missing here.  Is there anything to set to the object when calling it in view ? Can you please let me know how to work out this.

Thanks!

Paviyathachayini Mahendran,

Hello!

You receive a PostgreSQL exception upon executing a query written for MS SQL. You need to rewrite your query to be used in PostgreSQL.

Hi,

Thank You for the quick response. When i tried a script in PostgreSql it gets installed successfully. But could you please let me how to use this script or stored procedure inside the creatio application  ? like pulling data in a report based on the Stored procedure execution results ..