1 Reply Latest reply on Nov 4, 2010 11:21 AM by Helios-GunesEROL

    Clever queries in standard application forms

    810548
      Hi,
      I am trying to create a clever query for a folder. According to the standard documentation-

      place screen in query mode
      enter :a in the field you want to enter the clever query for
      execute query

      This should then open a pop-up window with the where clause of the folder query and there, you can edit the SQL directly.

      Except when I execute the query the where pop-up window does not appear and receive following error message-
      FRM-40367: Invalid criteria in field ITEM_NUMBER in example record.

      This same message appears for other fields and I have tried on other forms also.

      Does anyone know if the clever query functionality is still active and if so how is this functionality activated? On Applications Release 11.5.10

      Thanks