<meta typeId="subst-entity" versionId="0" actual="true">
  <fields>
      <value-field alias="_schema">tmp</value-field>
      <value-field alias="_table">subst_entities</value-field>
      <value-field alias="_id">id</value-field>
      <text-field alias="docNum" common="true">doc_num</text-field>
 
      <text-field alias="valueRu" common="true" lazy="true">value_ru</text-field>
      <text-field alias="valueEn" common="true" lazy="true">value_en</text-field>
      <text-field alias="valueDef" common="true" lazy="true">value_def</text-field>
 
      <substitute-text-field alias="substField" lazy="true">
          <condition language="js">context.getLocale()</condition>
          <if value="ru">valueRu</if>
          <if value="en">valueEn</if>
          <default>valueDef</default>
      </substitute-text-field>
  </fields>
</meta>

restrictions
public interface Restrictions {
  public Restriction eq(String field, @Nullable Object value);
  public Restriction same(String field, String otherField);
  public Restriction ge(String field, Object value);
  public Restriction gt(String field, Object value);
  public Restriction le(String field, Object value);
  public Restriction lt(String field, Object value);
  public Restriction ne(String field, Object value);
  public Restriction or(Restriction... restrictions);
  /** convenient method or for execute from js */
  public Restriction or(Restriction restriction1, Restriction restriction2);
  public Restriction and(Restriction... restrictions);
  public Restriction commaSeparated(Restriction... restrictions);
  public Restriction in(String field, Object... values);
  public Restriction in(String[] fields, IEntityQuery query);
  public Restriction isNull(String field);
  public Restriction isNotNull(String field);
  /** This method is analogue in and you have to use it instead in from js */
  public Restriction present(String field, Object... values);
  public Restriction present(String field, Set values);
  public Restriction present(String[] fields, IEntityQuery query);
  public Restriction id(Object value);
  public Restriction id(String alias, Object value);
  public Restriction versionId(Object value);
  public Restriction versionId(String alias, Object value);
  public Restriction typeId(Object value);
  public Restriction typeId(String alias, Object value);
  public Restriction actual(boolean value);
  public Restriction actual(String alias, boolean value);
  public Restriction deleted(boolean value);
  public Restriction deleted(String alias, boolean value);
  public Restriction not(Restriction restriction);
  public Restriction like(String field, String pattern);
  public Restriction like(String alias, String field, String pattern);
  public Restriction ilike(String field, String pattern);
  public Restriction ilike(String alias, String field, String pattern);
  public Restriction field(String alias);
  public Restriction field(String alias, String field);
  public Restriction field(String alias, Field field);
  public Restriction field(String alias, String field, String resultAlias);
  public Restriction hasAccess(IUser user);
  public Restriction hasAccess(String alias, IUser user);
  public Restriction hasBit(String alias, int value);
  /* xml-related restrictions */
  public Restriction hasTag(String alias, String field, String xpath);
  public Restriction hasTag(String field, String xpath);
}

storage.query("user").add(restrictions.like("surname", "А%")).list()

storage.query("user").join("roles", "r", "WEAK", restrictions.eq("r.name", "admin")).add(restrictions.or( restrictions.and([restrictions.eq("r._id", 1), restrictions.like("name", "%Анастасия%")]), restrictions.and([restrictions.isNull("r.name"), restrictions.like("name", "%Алексей%")]))).count();

storage.query("table1").use(["table2", restrictions.add("param", value)])

storage.query("table1").strict(["table2", restrictions.add("param", value)])

storage.query("user").strict(["roles"]).count()

storage.query("role").use(["users"]).add(restrictions.isNull("users._id")).list()

<?xml version="1.0" standalone="no"?>
  <metadata xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="metadata.xsd">
      <meta typeId="exam-protocol">
          <fields>
              <value-field alias="_id">id</value-field>
              <value-field alias="_table">exam_protocols</value-field>
              <value-field alias="_typeId">type_id</value-field>
              <value-field alias="_versionId">version_id</value-field>
   
              <long-field alias="protocolId" common="true">protocol_id</long-field>
              <date-time-field alias="protocolDate" common="true">protocol_date</date-time-field>
              <text-field alias="verifiableName" common="true">verifiable_name</text-field>
              <date-time-field alias="verifiableBirthDate" common="true">verifiable_birth_date</date-time-field>
              <text-field alias="auditOrgName" common="true">audit_org_name</text-field>
              <text-field alias="category" common="true">category</text-field>
              <date-time-field alias="auditDate" common="true">audit_ate</date-time-field>
              <text-field alias="auditorName" common="true">auditor_name</text-field>
              <text-field alias="auditorJob" common="true">auditor_job</text-field>
              <long-field alias="questionsCount" common="true">questions_count</long-field>
              <long-field alias="answersCount" common="true">answers_count</long-field>
              <long-field alias="errorsCount" common="true">errors_count</long-field>
              <boolean-field alias="auditResult" common="true">audit_result</boolean-field>
              <text-field alias="auditorBoss" common="true">auditor_boss</text-field>
          </fields>
      </meta>
  </metadata>

<document-field alias="attachments"typeId="file" cascade="store">
      <m2m joinTable="document_files" aliasColumn="document_field">
          <sources>
              <field alias="_id" column="document_id"/>
              <field alias="_versionId" column="document_version_id"/>
              <field alias="_typeId" column="document_type_id"/>
          </sources>
          <destinations>
              <field alias="_id" column="file_id"/>
              <field alias="_versionId" column="file_version_id"/>
              <field alias="_typeId" column="file_type_id"/>
          </destinations>
          <fields>
              <long-field alias="index" common="true">idx</long-field>
          </fields>
      </m2m>
</document-field>

<document-field alias="events" typeId="event">
      <mapped relationship="O2M" mappedBy="document"/>
</document-field>
<document-field alias="eventsSummary" typeId="events-summary">
      <m2o>
          <field sourceAlias="_id" destinationAlias="paramId"/>
          <field sourceAlias="_typeId" destinationAlias="paramTypeId"/>
      </m2o>
</document-field> 

if (document != null) {
  out.add(convert.document(storage.query(document.getTypeId())
      .use(["attachments"])
      .add(restrictions.id(document.getId()))
      .one()), 0);
}

// make new exam-protocol:
var param = storage.make("exam-protocol");
// setting fields:
param.setField("protocolId", ctx.get("protocolId"));
param.setField("protocolDate", ctx.get("protocolDate"));
param.setField("verifiableName", ctx.get("verifiableName"));
param.setField("verifiableBirthDate", ctx.get("verifiableBirthDate"));
param.setField("auditOrgName", ctx.get("auditOrgName"));
param.setField("category", ctx.get("category"));
param.setField("auditDate", ctx.get("auditDate"));
param.setField("auditorName", ctx.get("auditorName"));
param.setField("auditorJob", ctx.get("auditorJob"));
param.setField("questionsCount", ctx.get("questionsCount"));
param.setField("answersCount", ctx.get("answersCount"));
param.setField("errorsCount", ctx.get("errorsCount"));
param.setField("auditResult", ctx.get("auditResult"));
param.setField("auditorBoss", ctx.get("auditorBoss"));
// store attachments
$("updateAttachments")(param, ctx.get("attachments"));
// store document:
param = storage.store(param);
// continue execution:
self.goSelf("out", null, $("getRoleByName")("everyone"), param, {});

param = storage.query(param.getTypeId()).
    add(restrictions.id(param.getId())).
    use(["eventsSummary"]).
    one();
sender.sendEvent(param, {role: role}, event);
// return created document:
self.setAnswer(param);

// setting fields:
param.setField("protocolId", ctx.get("protocolId"));
param.setField("protocolDate", ctx.get("protocolDate"));
param.setField("verifiableName", ctx.get("verifiableName"));
param.setField("verifiableBirthDate", ctx.get("verifiableBirthDate"));
param.setField("auditOrgName", ctx.get("auditOrgName"));
param.setField("category", ctx.get("category"));
param.setField("auditDate", ctx.get("auditDate"));
param.setField("auditorName", ctx.get("auditorName"));
param.setField("auditorJob", ctx.get("auditorJob"));
param.setField("questionsCount", ctx.get("questionsCount"));
param.setField("answersCount", ctx.get("answersCount"));
param.setField("errorsCount", ctx.get("errorsCount"));
param.setField("auditResult", ctx.get("auditResult"));
param.setField("auditorBoss", ctx.get("auditorBoss"));
// store attachments
$("updateAttachments")(param, ctx.get("attachments"));
//store doc
param = storage.update(param);
//return doc
self.setAnswer(param);

// send notification to delete document from registry:
sender.sendEvent(param, {role: $("getRoleByName")("everyone")}, "out:" + event););
//return doc
self.setAnswer(param);

// send notification to delete document from registry:
sender.sendEvent(param, {role: $("getRoleByName")("everyone")}, "out:" + event);

param = storage.remove(param);
//return doc
self.setAnswer(param);

param.fetch(["eventsSummary"]);
sender.sendEvent(param, {role: $("getRoleByName")("everyone")}, event);
// return created document:
self.setAnswer(param);

en.getData().setField("_typeId", "exam-protocol");
en.getData().setField("_workflow", "exam-protocol-automated");

out.setField("_code", "alias");
out.setField("_description", "name");
storage.query("document-events").list();
storage.query("exam-protocol").use(["eventsSummary"]).list();

listeners.add(
    [{ role: $("getRoleByName")("everyone") }],
     eventRestrictions.and([
        eventRestrictions.eventIn(["new", "out:new", "review", "out:review"]),
        eventRestrictions.eq("_typeId", "exam-protocol")
    ]),
listener (en) {
    var event = en.getData().getFieldAsString("_event", "-");
    en.alert("event: " + event);
    importer.get("updateRegistry")(en, "protocolTable", "_param.", false);
});