Discussions
Searching for all Tasks related to a transaction
I need to search for tasks that are related to a specific transaction (could be SO, Invoice, Estimate, etc).
Looks like 'transaction' isn't a supported filter column for a task. (WHY NOT?)
I checked to see if there was an 'activity' or 'task' join for a transaction and there isn't.
My next approach would be to search for all the tasks that share the same customer as my transaction, then loop through them storing the ones that have a matching transaction ID in a separate array.
Does this seem like the best approach? I haven't done much with the searching, is there possibly another option?
Steve Klett | Senior Developer
NetValue Technology