Editor pull-down showing all records in table - I need a filter on a specific subscriberid.

Editor pull-down showing all records in table - I need a filter on a specific subscriberid.

brennan119brennan119 Posts: 5Questions: 3Answers: 0

I have the following server-side Editor setup which works fine, except the editor pull-down is showing ALL the questions in
tblQuestionBankQuestions.. this contains questions for many subscribers.

Is there an equivalent of ->where( 'subscriberID', $subscriberID) I could use to filter the list?

Thank you in advance of any help given

Editor::inst( $db, 'tblAvailableProductsAndServicesQbqs', array('qbqID','psID') )
    ->field(
      Field::inst( 'tblAvailableProductsAndServicesQbqs.psID' ),
      Field::inst( 'tblAvailableProductsAndServicesQbqs.qbqID' )
         ->options(Options::inst()
            ->table( 'tblQuestionBankQuestions')
            ->value( 'id' )
            ->label( 'question')
         )
         ->validator( 'Validate::dbValues' ),
      Field::inst( 'tblQuestionBankQuestions.question' ),      
      Field::inst('tblAvailableProductsAndServicesQbqs.quoteOrPsLevel')            
         ->validator( 'Validate::notEmpty', array(
            'message' => 'This is a required field.') )
    )
   ->where('tblAvailableProductsAndServicesQbqs.psID',$reqID)
   ->leftjoin( 'tblQuestionBankQuestions', 'tblQuestionBankQuestions.id', '=', 'tblAvailableProductsAndServicesQbqs.qbqID' )

Answers

  • colincolin Posts: 14,529Questions: 1Answers: 2,483

    I see you're using Editor, but our accounts aren't showing that you have a license - it just reports that your trial expired 2016. Is the license registered to another email address? Please can let us know so we can update our records and provide support.

    Thanks,

    Colin

Sign In or Register to comment.