3 Replies Latest reply: Jan 15, 2013 12:06 AM by 984618 RSS

    How to set the where clause of a value set on the basis of a form field

    984618
      I am using a DFF(Descriptive FlexField), which needs to display the value of a certain column(say columnA) on the basis of the value of another column(say columnB).

      So i have created a value set which points to the table which has both these columns, and the DFF uses this value set. However, the problem is that I have not put any where clause in the value set, because of which i cannot handle the exact fetch returns more than one rows error.

      The query has to be as follows:
      select ColumnA from tbl where ColumnB = [ a form value ];

      What I want to know is how can i get the value of a certain field of a certain block of the form in the above query.

      Edited by: 981615 on Jan 14, 2013 12:48 AM

      Edited by: 981615 on Jan 14, 2013 12:48 AM