Query on union of tables

Moralis General
#1

Hello,

I am working on the event sync database and cloud functions.

My solidity code has 2 events that has exact same columns.

example:

EventUp

EventDown

would it be possible to merge/union them on cloud functions. (not joining) so my query would run both of the tables combined (instead of getting two different queries, merging them with js and sorting again)

Thanks

#2

Hello,
Don’t know if it is an easy solution for that, I’m thinking that you could run a job or use afterSave hook in order to put all events in one table.

#3

thanks will check on that