SearchDefinitions:
 moduleName: tl-services
 summary: Trade License Services Inbox API
 version: 1.0.0
 definitions:
 - name: inboxtlsearch
   query:
    baseQuery: Select row_to_json(result) from
          (
          select DISTINCT(tl.applicationNumber) as applicationnumber,tl.applicationdate as createdtime from eg_tl_tradelicense as tl
          INNER JOIN eg_tl_tradelicensedetail tld ON tl.id = tld.tradelicenseid
          INNER JOIN eg_tl_owner owner ON tld.id = owner.tradelicensedetailid
          INNER JOIN eg_tl_address tladd ON tladd.tradelicensedetailid = tld.id
          INNER JOIN eg_wf_processinstance_v2 pi ON pi.businessid = tl.applicationNumber
          LEFT JOIN eg_wf_assignee_v2 assg ON pi.id = assg.processinstanceid
          $where
          AND pi.createdtime IN (select max(createdtime) from eg_wf_processinstance_v2 wf where wf.businessid = tl.applicationNumber GROUP BY wf.businessid)
          order by tl.applicationdate asc $pagination
          ) result
    groupBy:
    orderBy:
   searchParams:
    condition: AND
    params:
    - name: tl.tenantid
      isMandatory: true
      jsonPath: $.searchCriteria.tenantId
    - name: tl.licenseNumber
      isMandatory: false
      jsonPath: $.searchCriteria.licenseNumber
    - name: tl.oldlicensenumber
      isMandatory: false
      jsonPath: $.searchCriteria.oldlicensenumber
    - name: tladd.locality
      isMandatory: false
      jsonPath: $.searchCriteria.locality
    - name: assg.assignee
      isMandatory: false
      jsonPath: $.searchCriteria.assignee
    - name: pi.status
      isMandatory: false
      jsonPath: $.searchCriteria.status
    - name: tl.applicationNumber
      isMandatory: false
      jsonPath: $.searchCriteria.applicationNumber
    - name: owner.id
      isMandatory: false
      jsonPath: $.searchCriteria.userid
    - name: pi.businessservice
      isMandatory: false
      jsonPath: $.searchCriteria.businessservice
    pagination:
      noOfRecords: $.searchCriteria.noOfRecords
      offset: $.searchCriteria.offset

   output:
    jsonFormat: {"ResponseInfo": {},"Licenses": []}
    outJsonPath: $.Licenses
    responseInfoPath: $.ResponseInfo

 - name: inboxtlsearchcount
   query:
    baseQuery: SELECT row_to_json(TotalCount) from (SELECT COUNT(result) from
          (
          select DISTINCT(tl.applicationNumber) as applicationnumber,tl.applicationdate as createdtime from eg_tl_tradelicense as tl
          INNER JOIN eg_tl_tradelicensedetail tld ON tl.id = tld.tradelicenseid
          INNER JOIN eg_tl_owner owner ON tld.id = owner.tradelicensedetailid
          INNER JOIN eg_tl_address tladd ON tladd.tradelicensedetailid = tld.id
          INNER JOIN eg_wf_processinstance_v2 pi ON pi.businessid = tl.applicationNumber
          LEFT JOIN eg_wf_assignee_v2 assg ON pi.id = assg.processinstanceid
          $where
          AND pi.createdtime IN (select max(createdtime) from eg_wf_processinstance_v2 wf where wf.businessid = tl.applicationNumber GROUP BY wf.businessid)
          order by tl.applicationdate asc
          ) result) TotalCount
    groupBy:
    orderBy:
   searchParams:
    condition: AND
    params:
    - name: tl.tenantid
      isMandatory: true
      jsonPath: $.searchCriteria.tenantId
    - name: tl.licenseNumber
      isMandatory: false
      jsonPath: $.searchCriteria.licenseNumber
    - name: tl.oldlicensenumber
      isMandatory: false
      jsonPath: $.searchCriteria.oldlicensenumber
    - name: tladd.locality
      isMandatory: false
      jsonPath: $.searchCriteria.locality
    - name: assg.assignee
      isMandatory: false
      jsonPath: $.searchCriteria.assignee
    - name: pi.status
      isMandatory: false
      jsonPath: $.searchCriteria.status
    - name: tl.applicationNumber
      isMandatory: false
      jsonPath: $.searchCriteria.applicationNumber
    - name: owner.id
      isMandatory: false
      jsonPath: $.searchCriteria.userid
    - name: pi.businessservice
      isMandatory: false
      jsonPath: $.searchCriteria.businessservice
    pagination:
      noOfRecords: $.searchCriteria.noOfRecords
      offset: $.searchCriteria.offset

   output:
    jsonFormat: {"ResponseInfo": {},"TotalCount": {}}
    outJsonPath: $.TotalCount
    responseInfoPath: $.ResponseInfo

 - name: inboxtlsearchdesc
   query:
    baseQuery: Select row_to_json(result) from
          (
          select DISTINCT(tl.applicationNumber) as applicationnumber,tl.applicationdate as createdtime from eg_tl_tradelicense as tl
          INNER JOIN eg_tl_tradelicensedetail tld ON tl.id = tld.tradelicenseid
          INNER JOIN eg_tl_owner owner ON tld.id = owner.tradelicensedetailid
          INNER JOIN eg_tl_address tladd ON tladd.tradelicensedetailid = tld.id
          INNER JOIN eg_wf_processinstance_v2 pi ON pi.businessid = tl.applicationNumber
          LEFT JOIN eg_wf_assignee_v2 assg ON pi.id = assg.processinstanceid
          $where
          AND pi.createdtime IN (select max(createdtime) from eg_wf_processinstance_v2 wf where wf.businessid = tl.applicationNumber GROUP BY wf.businessid)
          order by tl.applicationdate desc $pagination
          ) result
    groupBy:
    orderBy:
   searchParams:
    condition: AND
    params:
    - name: tl.tenantid
      isMandatory: true
      jsonPath: $.searchCriteria.tenantId
    - name: tl.licenseNumber
      isMandatory: false
      jsonPath: $.searchCriteria.licenseNumber
    - name: tl.oldlicensenumber
      isMandatory: false
      jsonPath: $.searchCriteria.oldlicensenumber
    - name: tladd.locality
      isMandatory: false
      jsonPath: $.searchCriteria.locality
    - name: assg.assignee
      isMandatory: false
      jsonPath: $.searchCriteria.assignee
    - name: pi.status
      isMandatory: false
      jsonPath: $.searchCriteria.status
    - name: tl.applicationNumber
      isMandatory: false
      jsonPath: $.searchCriteria.applicationNumber
    - name: owner.id
      isMandatory: false
      jsonPath: $.searchCriteria.userid
    - name: pi.businessservice
      isMandatory: false
      jsonPath: $.searchCriteria.businessservice
    pagination:
      noOfRecords: $.searchCriteria.noOfRecords
      offset: $.searchCriteria.offset

   output:
    jsonFormat: {"ResponseInfo": {},"Licenses": []}
    outJsonPath: $.Licenses
    responseInfoPath: $.ResponseInfo