AnsweredAssumed Answered

execute sql compare value lists

Question asked by user9259 on Aug 29, 2015
Latest reply on Aug 31, 2015 by user9259

2 Tables Recipes & Fruit. There is a relationship between Recipes & Fruit. Each recipe has a number of fruits.

 

1) The user will selct different fruits via a script in List View which will be assembled into a global variable $$fruits

2) There is a calculation field in recipes  List(frecipes::fruits)

 

So I would like to return a list of Primary Keys from Recipes that have the selcted $$fruits.

 

So Recipe 1 may contain

Apples,

Grapes,

Lemons,

Oranges

 

$$fruits may contain

Apples

Lemons

 

So $$fruits meets criteria. I would like to have a sql statement that assmbles the Recipe ID's across the total set of records. I was able to accomplish this with custom functions; but I didn't like the performance. Thanks so much for all the help!!!

Outcomes