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

    Fehler in objectgroupcondition und persongroupcondition

    Scheduled Pinned Locked Moved Entwicklung
    1 Posts 1 Posters 221 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

      Hello! It looks like you're interested in this conversation, but you don't have an account yet.

      Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

      With your input, this post could be even better 💗

      Register Login
      • First post
        Last post