Welcome to the Syniti Ideas Portal!

Do you have feedback regarding the current product, or new ideas for improvement?

Tell us how we can make the Syniti Knowledge Platform more useful to you.

Automatically add table aliases to "shell" rules

When Migrate generates update rules, it would be VERY useful for it to automatically alias the table, and add that alias to the columns. See the current shell rule that gets generated: What I’m proposing is to replace the full table with “s.” and aliasing the column as “s” It may not seem like much, but in Postgres when there is no visual view designer, it becomes very cumbersome when you have to type out the table names for every column. And I end up repetitively aliasing and swapping in “s.” hundreds of times throughout the rules and reports. *Similarly, any source report would get “s.” and target report would get “t.” - And one last thing… can we add “WHERE s.zactive = true” to all update rules? I believe that’s standard methodology?

jay.hornback@syniti.com 13 days ago

1