Edit Database table checkpoint SQL

[Logiv]

Hello,

I am using the Database table checkpoints and I cannot find how to edit or view the Custom SQL query.

So let's say I did the test:  Select * from Table1 

but forgot to add "where EmployeeID = id", the only way I found to add it after the checkpoint was created is to create another checkpoint, and re-doing the SQL connection string.

I would prefer to edit the existing query. Is it possible?

Thanks

[Logiv · Accepted solution]

Figured it out! In the Project explorer - Stores - DbTables, double-click the custom query and then you can press EDIT on the top right.

Sorry, didn't know how to delete my inital post!

[sonya_m]

@Logiv Thank you for sharing the solution!

Let's leave the post be. It can turn out really helpful if somebody else faces this obstacle.