Circling back around to this randomly. I’ve studied some other examples, and I think I’d like to keep a UD table filled with 3 calendar years of dates (and a bunch of pre-calculated values: fiscal year, isWorkDay, isHoliday, etc). This table would be re-written any time Erp.ProdCalDay was updated. I think this will have value beyond this one report. I have a SQL statement that works with our on-prem, but need to convert to a BPM - and I’m having trouble getting started. This looks close… Insert UD Table Records from a BPM … but I can’t see how to adapt it to my needs.
jfajen
(Justin Fajen)
10
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Trigger BPM from external change to UD table or at scheduled interval | 1 | 520 | December 8, 2022 | |
| Using Code to Manipulate a Query to Fill a UD Table | 5 | 1690 | June 30, 2021 | |
| From BAQ to UD Table | 17 | 1928 | March 28, 2024 | |
| Write BAQ Results to a UD Table | 18 | 3280 | February 27, 2019 | |
| Updating historical UD Fields | 10 | 1149 | March 10, 2017 |