4 Replies Latest reply: Jul 9, 2012 3:16 AM by Avula Ganeshkumar RSS

    Data retrieval  based on priority... Help Me..Check the screen shot attached.

      can any one help me , how to retrieve the data by priority vise in the expression.

       

      Example: i hav the data

       

      location,Area , customername, Capacity...four columns...

       

       

      location
      area
      customercapacity
      chennai

      500
      chennaisipcot
      800
      chennaisipcotAvula400

       

       

       

      if my selection is chennai,sipcot,avula then the result set is 500,800 and 400.check the screen shot for refernce.

      Attachments: