Logic block currently creates temp tables and inserts into them. At the end of processing uses the data for db inserts and clears all temp tables. This current logic block is over 400 actions.
In order to reduce the number of action lines and make it more modular, I’d like to change these temp tables to shared temp tables and split logic for inserting into the tables into several logic blocks all in the same transaction boundary.
Questions:
Can we insert into shared temp tables from different logic blocks?
Is there a limit to how many logic blocks shared temp tables can be used in?
Can we insert into shared temp tables from different logic blocks? yes*
Is there a limit to how many logic blocks shared temp tables can be used in? not as far as I'm aware*
* - I recommend reviewing the below two Nextworld Help topics, particularly the comments about database boundaries as that is where the limitation ultimately exists. For example, a shared temp table in a logic block that initiates a logic block controlled workflow transition won’t be available to any post-transition logic blocks on that transition.
Thanks, I did read that but it didn’t answer my question. I have used shared temp tables before where one logic block inserted the other read. I want to insert into the tables from several logic blocks (no workflow involved) just simply splitting out logic to insert into these temp tables over several lb’s and then main calling logic block will read all temp tables and insert records into tables.
