Doctrine 2 - How to add limit in multiple addSelect












3















Problem : got Error when i run my query



{
"status": false,
"error": {
"classname": "Doctrine\ORM\Query\QueryException",
"message": "[Syntax Error] line 0, col 783: Error: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got 'LIMIT'"
}
}


How can i add limit in addSelect in below query.



 $qb = $this->em->createQueryBuilder();
$qb->select("identity(igsm.group) as group_id,
qp.id AS q_paper_id,
qp.name AS q_name,
qp.description AS q_description,
qp.marks,
identity(qp.questionPaperStatus) AS qpStatus,
qp.timeInMinutes as time_in_minutes,
sa.marks as marks_obtained,
sa.id AS assessment_id");
$qb->addSelect("(SELECT IfElse(count(qps.id) > 0 , TRUE, FALSE) FROM EntityQuestionPaper qps "
. "WHERE qps.createdBy = :userId AND qps.id = qp.id) as flag");
$qb->addSelect("(SELECT count(qpe.id) from EntityQuestionPaperEvaluation qpe "
. "where qpe.questionPaper = qp.id AND qpe.user = :userId) as student_evaluation_cnt");
$qb->addSelect("(SELECT LOWER(ats.assignee) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
. "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
. "ORDER BY ats.id DESC LIMIT 1) AS assignee");
$qb->addSelect("(SELECT identity(ast.assessmentTimelineStatus) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
. "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
. "ORDER BY ats.id DESC LIMIT 1) AS assessment_timeline_id");
$qb->addSelect("(SELECT UPPER(ConcatWs(' ', ats.action,ats.item)) as assesment_submissions from EntityAssessmentTimelineStatus ats, "
. "EntityAssessmentStudentTimeline ast WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
. "ORDER BY ats.id DESC LIMIT 1) AS action");
$qb->from('EntityQuestionPaperGroupStudentMap', 'qpgsm');
$qb->innerJoin('EntityInstituteGroupStudentMap', 'igsm', 'WITH', 'igsm.id=qpgsm.instituteGroupStudentMap');
$qb->innerJoin('EntityQuestionPaper', 'qp', 'WITH', 'qp.id=qpgsm.questionPaper AND qp.questionPaperStatus > 4');
$qb->leftJoin('EntityAssesmentSubmissions', 'sa', 'WITH', 'sa.assesmentId = qp.id AND sa.userId = igsm.user');
$qb->leftJoin('EntityPackageQuestionPaperHistory', 'pqph', 'WITH', 'pqph.questionPaperId = qp.id');
$qb->where('igsm.user = :userId')->setParameter(':userId', $userId);
$qb->andWhere("igsm.group IN (:GroupIds)")->setParameter(':GroupIds', explode(",", $groupId));
$qb->orderBy('qpgsm.id', 'DESC');
$qb->setMaxResults(1);
$result = $qb->getQuery()->getResult();
return $result;


Can i put subquery individualy though Subquery is dependent on main query.
How can i add limit in my sub query.



Thanks.










share|improve this question



























    3















    Problem : got Error when i run my query



    {
    "status": false,
    "error": {
    "classname": "Doctrine\ORM\Query\QueryException",
    "message": "[Syntax Error] line 0, col 783: Error: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got 'LIMIT'"
    }
    }


    How can i add limit in addSelect in below query.



     $qb = $this->em->createQueryBuilder();
    $qb->select("identity(igsm.group) as group_id,
    qp.id AS q_paper_id,
    qp.name AS q_name,
    qp.description AS q_description,
    qp.marks,
    identity(qp.questionPaperStatus) AS qpStatus,
    qp.timeInMinutes as time_in_minutes,
    sa.marks as marks_obtained,
    sa.id AS assessment_id");
    $qb->addSelect("(SELECT IfElse(count(qps.id) > 0 , TRUE, FALSE) FROM EntityQuestionPaper qps "
    . "WHERE qps.createdBy = :userId AND qps.id = qp.id) as flag");
    $qb->addSelect("(SELECT count(qpe.id) from EntityQuestionPaperEvaluation qpe "
    . "where qpe.questionPaper = qp.id AND qpe.user = :userId) as student_evaluation_cnt");
    $qb->addSelect("(SELECT LOWER(ats.assignee) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
    . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
    . "ORDER BY ats.id DESC LIMIT 1) AS assignee");
    $qb->addSelect("(SELECT identity(ast.assessmentTimelineStatus) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
    . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
    . "ORDER BY ats.id DESC LIMIT 1) AS assessment_timeline_id");
    $qb->addSelect("(SELECT UPPER(ConcatWs(' ', ats.action,ats.item)) as assesment_submissions from EntityAssessmentTimelineStatus ats, "
    . "EntityAssessmentStudentTimeline ast WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
    . "ORDER BY ats.id DESC LIMIT 1) AS action");
    $qb->from('EntityQuestionPaperGroupStudentMap', 'qpgsm');
    $qb->innerJoin('EntityInstituteGroupStudentMap', 'igsm', 'WITH', 'igsm.id=qpgsm.instituteGroupStudentMap');
    $qb->innerJoin('EntityQuestionPaper', 'qp', 'WITH', 'qp.id=qpgsm.questionPaper AND qp.questionPaperStatus > 4');
    $qb->leftJoin('EntityAssesmentSubmissions', 'sa', 'WITH', 'sa.assesmentId = qp.id AND sa.userId = igsm.user');
    $qb->leftJoin('EntityPackageQuestionPaperHistory', 'pqph', 'WITH', 'pqph.questionPaperId = qp.id');
    $qb->where('igsm.user = :userId')->setParameter(':userId', $userId);
    $qb->andWhere("igsm.group IN (:GroupIds)")->setParameter(':GroupIds', explode(",", $groupId));
    $qb->orderBy('qpgsm.id', 'DESC');
    $qb->setMaxResults(1);
    $result = $qb->getQuery()->getResult();
    return $result;


    Can i put subquery individualy though Subquery is dependent on main query.
    How can i add limit in my sub query.



    Thanks.










    share|improve this question

























      3












      3








      3








      Problem : got Error when i run my query



      {
      "status": false,
      "error": {
      "classname": "Doctrine\ORM\Query\QueryException",
      "message": "[Syntax Error] line 0, col 783: Error: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got 'LIMIT'"
      }
      }


      How can i add limit in addSelect in below query.



       $qb = $this->em->createQueryBuilder();
      $qb->select("identity(igsm.group) as group_id,
      qp.id AS q_paper_id,
      qp.name AS q_name,
      qp.description AS q_description,
      qp.marks,
      identity(qp.questionPaperStatus) AS qpStatus,
      qp.timeInMinutes as time_in_minutes,
      sa.marks as marks_obtained,
      sa.id AS assessment_id");
      $qb->addSelect("(SELECT IfElse(count(qps.id) > 0 , TRUE, FALSE) FROM EntityQuestionPaper qps "
      . "WHERE qps.createdBy = :userId AND qps.id = qp.id) as flag");
      $qb->addSelect("(SELECT count(qpe.id) from EntityQuestionPaperEvaluation qpe "
      . "where qpe.questionPaper = qp.id AND qpe.user = :userId) as student_evaluation_cnt");
      $qb->addSelect("(SELECT LOWER(ats.assignee) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
      . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
      . "ORDER BY ats.id DESC LIMIT 1) AS assignee");
      $qb->addSelect("(SELECT identity(ast.assessmentTimelineStatus) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
      . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
      . "ORDER BY ats.id DESC LIMIT 1) AS assessment_timeline_id");
      $qb->addSelect("(SELECT UPPER(ConcatWs(' ', ats.action,ats.item)) as assesment_submissions from EntityAssessmentTimelineStatus ats, "
      . "EntityAssessmentStudentTimeline ast WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
      . "ORDER BY ats.id DESC LIMIT 1) AS action");
      $qb->from('EntityQuestionPaperGroupStudentMap', 'qpgsm');
      $qb->innerJoin('EntityInstituteGroupStudentMap', 'igsm', 'WITH', 'igsm.id=qpgsm.instituteGroupStudentMap');
      $qb->innerJoin('EntityQuestionPaper', 'qp', 'WITH', 'qp.id=qpgsm.questionPaper AND qp.questionPaperStatus > 4');
      $qb->leftJoin('EntityAssesmentSubmissions', 'sa', 'WITH', 'sa.assesmentId = qp.id AND sa.userId = igsm.user');
      $qb->leftJoin('EntityPackageQuestionPaperHistory', 'pqph', 'WITH', 'pqph.questionPaperId = qp.id');
      $qb->where('igsm.user = :userId')->setParameter(':userId', $userId);
      $qb->andWhere("igsm.group IN (:GroupIds)")->setParameter(':GroupIds', explode(",", $groupId));
      $qb->orderBy('qpgsm.id', 'DESC');
      $qb->setMaxResults(1);
      $result = $qb->getQuery()->getResult();
      return $result;


      Can i put subquery individualy though Subquery is dependent on main query.
      How can i add limit in my sub query.



      Thanks.










      share|improve this question














      Problem : got Error when i run my query



      {
      "status": false,
      "error": {
      "classname": "Doctrine\ORM\Query\QueryException",
      "message": "[Syntax Error] line 0, col 783: Error: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got 'LIMIT'"
      }
      }


      How can i add limit in addSelect in below query.



       $qb = $this->em->createQueryBuilder();
      $qb->select("identity(igsm.group) as group_id,
      qp.id AS q_paper_id,
      qp.name AS q_name,
      qp.description AS q_description,
      qp.marks,
      identity(qp.questionPaperStatus) AS qpStatus,
      qp.timeInMinutes as time_in_minutes,
      sa.marks as marks_obtained,
      sa.id AS assessment_id");
      $qb->addSelect("(SELECT IfElse(count(qps.id) > 0 , TRUE, FALSE) FROM EntityQuestionPaper qps "
      . "WHERE qps.createdBy = :userId AND qps.id = qp.id) as flag");
      $qb->addSelect("(SELECT count(qpe.id) from EntityQuestionPaperEvaluation qpe "
      . "where qpe.questionPaper = qp.id AND qpe.user = :userId) as student_evaluation_cnt");
      $qb->addSelect("(SELECT LOWER(ats.assignee) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
      . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
      . "ORDER BY ats.id DESC LIMIT 1) AS assignee");
      $qb->addSelect("(SELECT identity(ast.assessmentTimelineStatus) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
      . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
      . "ORDER BY ats.id DESC LIMIT 1) AS assessment_timeline_id");
      $qb->addSelect("(SELECT UPPER(ConcatWs(' ', ats.action,ats.item)) as assesment_submissions from EntityAssessmentTimelineStatus ats, "
      . "EntityAssessmentStudentTimeline ast WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
      . "ORDER BY ats.id DESC LIMIT 1) AS action");
      $qb->from('EntityQuestionPaperGroupStudentMap', 'qpgsm');
      $qb->innerJoin('EntityInstituteGroupStudentMap', 'igsm', 'WITH', 'igsm.id=qpgsm.instituteGroupStudentMap');
      $qb->innerJoin('EntityQuestionPaper', 'qp', 'WITH', 'qp.id=qpgsm.questionPaper AND qp.questionPaperStatus > 4');
      $qb->leftJoin('EntityAssesmentSubmissions', 'sa', 'WITH', 'sa.assesmentId = qp.id AND sa.userId = igsm.user');
      $qb->leftJoin('EntityPackageQuestionPaperHistory', 'pqph', 'WITH', 'pqph.questionPaperId = qp.id');
      $qb->where('igsm.user = :userId')->setParameter(':userId', $userId);
      $qb->andWhere("igsm.group IN (:GroupIds)")->setParameter(':GroupIds', explode(",", $groupId));
      $qb->orderBy('qpgsm.id', 'DESC');
      $qb->setMaxResults(1);
      $result = $qb->getQuery()->getResult();
      return $result;


      Can i put subquery individualy though Subquery is dependent on main query.
      How can i add limit in my sub query.



      Thanks.







      php mysql doctrine-orm codeigniter-3






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Jan 1 at 9:21









      N.SN.S

      41110




      41110
























          1 Answer
          1






          active

          oldest

          votes


















          0














          There is an issue about this in github.



          The same question has been asked:




          • Subquery with LIMIT in Doctrine

          • Doctrine 2 limit IN subquery


          A possible quick hack solution could be to:




          • Prepend the desired select column with the "order by" column in the select statement

          • use MIN or MAX to aggregate the results to just get the 1st one(to have the same result as LIMIT 1)


          This subselect:



          $qb->addSelect("(SELECT LOWER(ats.assignee) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
          . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
          . "ORDER BY ats.id DESC LIMIT 1) AS assignee");


          would be written as:



          $qb->addSelect("(SELECT MAX(concat(ats.id, ' ', LOWER(ats.assignee))) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
          . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
          . "ORDER BY ats.id DESC) AS assignee");


          When you get the "assignee" value, you can split to the 1st single whitespace value and get the value of "LOWER(ats.assignee)".



          $result = explode(' ',$assignee, 2);


          Use MAX when the ORDER BY is DESC and MIN when ASC.



          This works because MAX or MIN aggregate function select only the highest or lowest value, which can be either a number or a string.



          References



          MAX/MIN mysql documentation



          explode to 1st whitespace character






          share|improve this answer























            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53994305%2fdoctrine-2-how-to-add-limit-in-multiple-addselect%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0














            There is an issue about this in github.



            The same question has been asked:




            • Subquery with LIMIT in Doctrine

            • Doctrine 2 limit IN subquery


            A possible quick hack solution could be to:




            • Prepend the desired select column with the "order by" column in the select statement

            • use MIN or MAX to aggregate the results to just get the 1st one(to have the same result as LIMIT 1)


            This subselect:



            $qb->addSelect("(SELECT LOWER(ats.assignee) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
            . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
            . "ORDER BY ats.id DESC LIMIT 1) AS assignee");


            would be written as:



            $qb->addSelect("(SELECT MAX(concat(ats.id, ' ', LOWER(ats.assignee))) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
            . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
            . "ORDER BY ats.id DESC) AS assignee");


            When you get the "assignee" value, you can split to the 1st single whitespace value and get the value of "LOWER(ats.assignee)".



            $result = explode(' ',$assignee, 2);


            Use MAX when the ORDER BY is DESC and MIN when ASC.



            This works because MAX or MIN aggregate function select only the highest or lowest value, which can be either a number or a string.



            References



            MAX/MIN mysql documentation



            explode to 1st whitespace character






            share|improve this answer




























              0














              There is an issue about this in github.



              The same question has been asked:




              • Subquery with LIMIT in Doctrine

              • Doctrine 2 limit IN subquery


              A possible quick hack solution could be to:




              • Prepend the desired select column with the "order by" column in the select statement

              • use MIN or MAX to aggregate the results to just get the 1st one(to have the same result as LIMIT 1)


              This subselect:



              $qb->addSelect("(SELECT LOWER(ats.assignee) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
              . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
              . "ORDER BY ats.id DESC LIMIT 1) AS assignee");


              would be written as:



              $qb->addSelect("(SELECT MAX(concat(ats.id, ' ', LOWER(ats.assignee))) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
              . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
              . "ORDER BY ats.id DESC) AS assignee");


              When you get the "assignee" value, you can split to the 1st single whitespace value and get the value of "LOWER(ats.assignee)".



              $result = explode(' ',$assignee, 2);


              Use MAX when the ORDER BY is DESC and MIN when ASC.



              This works because MAX or MIN aggregate function select only the highest or lowest value, which can be either a number or a string.



              References



              MAX/MIN mysql documentation



              explode to 1st whitespace character






              share|improve this answer


























                0












                0








                0







                There is an issue about this in github.



                The same question has been asked:




                • Subquery with LIMIT in Doctrine

                • Doctrine 2 limit IN subquery


                A possible quick hack solution could be to:




                • Prepend the desired select column with the "order by" column in the select statement

                • use MIN or MAX to aggregate the results to just get the 1st one(to have the same result as LIMIT 1)


                This subselect:



                $qb->addSelect("(SELECT LOWER(ats.assignee) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
                . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
                . "ORDER BY ats.id DESC LIMIT 1) AS assignee");


                would be written as:



                $qb->addSelect("(SELECT MAX(concat(ats.id, ' ', LOWER(ats.assignee))) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
                . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
                . "ORDER BY ats.id DESC) AS assignee");


                When you get the "assignee" value, you can split to the 1st single whitespace value and get the value of "LOWER(ats.assignee)".



                $result = explode(' ',$assignee, 2);


                Use MAX when the ORDER BY is DESC and MIN when ASC.



                This works because MAX or MIN aggregate function select only the highest or lowest value, which can be either a number or a string.



                References



                MAX/MIN mysql documentation



                explode to 1st whitespace character






                share|improve this answer













                There is an issue about this in github.



                The same question has been asked:




                • Subquery with LIMIT in Doctrine

                • Doctrine 2 limit IN subquery


                A possible quick hack solution could be to:




                • Prepend the desired select column with the "order by" column in the select statement

                • use MIN or MAX to aggregate the results to just get the 1st one(to have the same result as LIMIT 1)


                This subselect:



                $qb->addSelect("(SELECT LOWER(ats.assignee) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
                . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
                . "ORDER BY ats.id DESC LIMIT 1) AS assignee");


                would be written as:



                $qb->addSelect("(SELECT MAX(concat(ats.id, ' ', LOWER(ats.assignee))) from EntityAssessmentTimelineStatus ats, EntityAssessmentStudentTimeline ast "
                . "WHERE ast.assessmentTimelineStatus = ats.id AND ast.user = igsm.user AND ast.assessment = qp.id "
                . "ORDER BY ats.id DESC) AS assignee");


                When you get the "assignee" value, you can split to the 1st single whitespace value and get the value of "LOWER(ats.assignee)".



                $result = explode(' ',$assignee, 2);


                Use MAX when the ORDER BY is DESC and MIN when ASC.



                This works because MAX or MIN aggregate function select only the highest or lowest value, which can be either a number or a string.



                References



                MAX/MIN mysql documentation



                explode to 1st whitespace character







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Jan 12 at 22:25









                Jannes BotisJannes Botis

                6,91921127




                6,91921127
































                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53994305%2fdoctrine-2-how-to-add-limit-in-multiple-addselect%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Can a sorcerer learn a 5th-level spell early by creating spell slots using the Font of Magic feature?

                    ts Property 'filter' does not exist on type '{}'

                    mat-slide-toggle shouldn't change it's state when I click cancel in confirmation window