2pack SQL statements cross client borders

Description

When I create a packout line of type "SQL Statement" I can use an SQL UPDATE command to change my data. My axample is this:

This code does not only inactivate the DocTypes in the active client but in all clients. A WHERE clause could help but at the time when I create the 2pack file I can not know which Client ID the user has when he uses PackIn.

One solution could be to automatically add an appropriate WHERE clause. I think this is nit easy to implement for all possible SQL texts. My idea is to allow context variables like this:

wdyt?

Environment

None

Assignee

Thomas Bayen

Reporter

Thomas Bayen

Tested By

None

Components

Priority

Major
Configure