Hi all,
I've posted versions of this question before, but I'm getting closer to a solution so I figured I should ask again.
First of all, can anyone tell me if I can call a parameterized view from a criteria set? and failing that, can I create an in-line user-defined function in a criteria set?
What I hope to do is build a view or temporary table which calculates interest weight for a given set of future performances. Then the criteria will select only those constituents where performance X has the highest weight in that constituent's row.
This is basically the table that I'm imagining the final select will be made from by the list or extraction criteria. Each of the weight columns represents the sum of weight for all keywords common between the constituent and the given performance.
I also recognize that I may be making this dramatically more difficult than I need to. If you read this and wish to enlighten me on how this could be made much easier, please do let me know.
Thanks everyone!