Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    Fehler in objectgroupcondition und persongroupcondition

    Scheduled Pinned Locked Moved Entwicklung
    1 Posts 1 Posters 183 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • ? Offline
      A Former User
      last edited by A Former User

      version 1.12 open

      idoit\src\idoit\Component\Browser\Condition

      es wird im wherepart ein Spaltenalias id verwendet, der durch count(*) nicht zu Verfügung steht, habe es in isys_obj__id
      geändert, dann funktioniert das Auflisten der Objekte, ob das inhaltlich korrekt ist kann ich nur vermuten?! probiere i-doit heute zum ersten mal ... aber es scheint irgendwie logisch 😉

      persongroupcondition.php Zeile 26

          $countSql = 'SELECT COUNT(*) 
              FROM isys_person_2_group 
              INNER JOIN isys_obj ON isys_obj__id = isys_person_2_group__isys_obj__id__person
              INNER JOIN isys_obj_type ON isys_obj_type__id = isys_obj__isys_obj_type__id
              WHERE isys_person_2_group__isys_obj__id__group = isys_obj__id 
              AND isys_obj__status = ' . $this->dao->convert_sql_int(C__RECORD_STATUS__NORMAL) .
              $this->getFilterQueryConditions();
      

      objectgroupcondition.php Zeile 25

          $countSql = 'SELECT COUNT(*) 
              FROM isys_cats_group_list
              INNER JOIN isys_connection ON isys_connection__id = isys_cats_group_list__isys_connection__id
      		INNER JOIN isys_obj ON isys_connection__isys_obj__id = isys_obj__id
              INNER JOIN isys_obj_type ON isys_obj_type__id = isys_obj__isys_obj_type__id
              WHERE isys_obj__status = ' . $this->dao->convert_sql_int(C__RECORD_STATUS__NORMAL) . '
              AND isys_cats_group_list__isys_obj__id = isys_obj__id ' .
              $this->getFilterQueryConditions();
      
      1 Reply Last reply Reply Quote 0
      • First post
        Last post