Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login
    1. Home
    2. sv
    3. Topics
    S
    Offline
    • Profile
    • Following 0
    • Followers 0
    • Topics 2
    • Posts 5
    • Groups 0

    Topics

    • S

      JSON RPC API Quickpurge

      Watching Ignoring Scheduled Pinned Locked Moved Entwicklung
      3
      0 Votes
      3 Posts
      21 Views
      W
      @sv Wo hättest du das herausgelesen, dass das nicht erlaubt wäre? Unter quickpurge finde ich da keine Einschränkung (außer, dass es enabled sein muss). Ich wollte das auch nutzen ...
    • S

      Reportmanager Bezeichnung vs. Inventarnummer

      Watching Ignoring Scheduled Pinned Locked Moved Betrieb
      2
      0 Votes
      2 Posts
      95 Views
      S
      Ich konnte die Abfrage über den SQL Explorer bauen. Über das Baukastenprinzip habe ich es nicht lösen können. Falls jemand vor dem gleichen Problem steht, hier meine Lösung. Bestimmt ist die Abfrage noch optimierbar. SELECT obj_main.isys_obj__id AS '__id__', j2.isys_obj_type__title AS 'LC__REPORT__FORM__OBJECT_TYPE###0_1', obj_main.isys_obj__title AS 'LC__UNIVERSAL__TITLE###0_1', j3.isys_catg_accounting_list__inventory_no AS 'LC__CMDB__CATG__ACCOUNTING_INVENTORY_NO###0_38' FROM isys_obj AS obj_main INNER JOIN isys_cmdb_status AS obj_main_status ON obj_main_status.isys_cmdb_status__id = obj_main.isys_obj__isys_cmdb_status__id LEFT JOIN isys_obj_type AS j2 ON j2.isys_obj_type__id = obj_main.isys_obj__isys_obj_type__id LEFT JOIN isys_catg_accounting_list AS j3 ON j3.isys_catg_accounting_list__isys_obj__id = obj_main.isys_obj__id WHERE TRUE AND ( (j2.isys_obj_type__id != '60' ) AND (j2.isys_obj_type__id != '63' ) ) AND ( (j2.isys_obj_type__id = '10' ) OR (j2.isys_obj_type__id = '11' ) OR (j2.isys_obj_type__id = '22' ) OR (j2.isys_obj_type__id = '32' ) OR (j2.isys_obj_type__id = '38' ) OR (j2.isys_obj_type__id = '96' ) OR (j2.isys_obj_type__id = '97' ) OR (j2.isys_obj_type__id = '100' ) OR (j2.isys_obj_type__id = '101' ) OR (j2.isys_obj_type__id = '103' ) ) AND ( (j3.isys_catg_accounting_list__inventory_no IS NULL OR j3.isys_catg_accounting_list__inventory_no = '' ) OR (obj_main.isys_obj__title != j3.isys_catg_accounting_list__inventory_no) ) AND ( obj_main.isys_obj__status != '6' ) ORDER BY obj_main.isys_obj__title DESC```