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






$$fruits may contain




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!!!