This API is used to create a condition object to be used with other pjs.data APIs, such as get, update and delete.
Parameters
- (String) Database column name.
- (String) Criteria operator, such as: =, >, >=, <, is null, is not null
- Value - The value to that will be injected in the condition
When using "is null", no value is needed
when using "is not null", no value is needed
| Code Block | ||
|---|---|---|
| ||
let c1 = pjs.data.createCondition("column1", "=", "abc");
let c2 = pjs.data.createCondition("column1", ">=", "aaa");
let c3 = pjs.data.createCondition("column1", "<=", "abc");
let c4 = pjs.data.createCondition("column1", "is not null");
let c5 = pjs.data.createCondition("column1", "is null");
let nowDate = new Date();
let beforeDate = new Date(nowDate .setFullYear(nowDate .getFullYear()-1));
let c6 = pjs.data.createCondition("coldate", "<=", beforeDate);
|
...