This discussion is archived
3 Replies Latest reply: Jan 14, 2013 10:06 PM by 984618 RSS

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

984618 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points