1 Reply Latest reply: Jul 30, 2013 8:20 AM by riedelme RSS

    Apply "WHERE CONDITION" in "MASTER/DETAIL FORM" in "ORACLE APEX

    uzairmalik

      Hi to all respected Gurus of this community.

       

      I have a problem and I hope that there must be solution in this community and I am not aware of that till now.

       

      I have a master/detail form in Oracle Application Express. Now, I want to apply a where condition in master-form to filter the data as per requirement but I cannot do so.
      There is an option of "Modify Query" in "Query Definition". According to the instructions I am selecting the desired column (HR_Category) in left and providing text string 'M-9' in the right column to filter the data where HR_Category is M-9, and when I press apply changes, it gives me an error that

       

      "1 error has occurred

         The condition you are adding has caused the query to be invalid."

       

      Please help how to proceed to apply a where condition.

       


      Regards

      Muhammad Uzair Awan

      Oracle APEX Programmer

      Pakistan

        • 1. Re: Apply "WHERE CONDITION" in "MASTER/DETAIL FORM" in "ORACLE APEX
          riedelme

          uzairmalik wrote:

           

          Hi to all respected Gurus of this community.

           

          I have a problem and I hope that there must be solution in this community and I am not aware of that till now.

           

          I have a master/detail form in Oracle Application Express. Now, I want to apply a where condition in master-form to filter the data as per requirement but I cannot do so.
          There is an option of "Modify Query" in "Query Definition". According to the instructions I am selecting the desired column (HR_Category) in left and providing text string 'M-9' in the right column to filter the data where HR_Category is M-9, and when I press apply changes, it gives me an error that

           

          "1 error has occurred

             The condition you are adding has caused the query to be invalid."

           

          Please help how to proceed to apply a where condition.

           


          Regards

          Muhammad Uzair Awan

          Oracle APEX Programmer

          Pakistan

          Probably a syntax error.  Check the syntax of the new clause very carefully.

           

          Can you post the query indicating which predicate is the new one?  If you need to change the column and table names for confidentiality