A simple condition with a variable looks like this:
[Where("< $State")] public int State;
You can either define the variable in the default system partner using the prefix 'eBiss.DbAdapter.'; in this case:
or in the job step:
If you use variables with conditions or with string types, you should set DontChangeCondition to true, e.g.:
[Where("$Name", DontChangeCondition = true)] public string Name;
In case of setting DontChangeCondition, the expression will not be changed, e.g. not be quoted.
In the job step you can define the variable e.g. as: