smartlist builder temp table

(0) Share

Report

Posted on by irishjamr2

615

Can temp tables be used as source data for smartlist builder? I'm trying to build a smartlist showing all open payables transactions that includes info we're storing in user-defined fields and extender. The first problem is that open payments don't include all of the additional data that we're storing on vouchers and credits. Normally I'd build a view with a UNION statement to get everything needed, but can't do that in this situation.

If I create a temp table is there a way to use it for the smartlist and refresh it when the smartlist is run?

*This post is locked for comments