{{indexmenu_n>50}}
===== DB Adapter - Where Conditions ===== 

A simple condition with a variable looks like this:

<code csharp>
        [Where("< $State")]
        public int State;
</code>
        
You can either define the variable in the default system partner using the prefix 'eBiss.DbAdapter.'; in this case:
  * eBiss.DbAdapter.State
or in the job step:
  * State
        
If you use variables with conditions or with string types, you should set DontChangeCondition to true, e.g.:
        
<code csharp>
  [Where("$Name", DontChangeCondition = true)]
  public string Name;
</code>

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:
  * like 'Mustermann%'
  * = 'Musterfrau'