DB Adapter - Where Conditions

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: