Hi there,
Is there a way through the database (via SP or some other method) to regenerate the query in the CRITERIA field in the table T_LIST? I had to bulk-change a ton of list criteria and would like to regenerate the content of this field too.
Thank you!
Kevin.
Hi Kevin,
There is the procedure RP_GENERATE_LIST but it does need a list no (it doesn't accept null).
I have a nightly job set up to generate around 20 lists so maybe you could do the same and then run it when needed, specifying an EXEC line for each one.
Cheers,
Kevin
Thanks Kevin! I did look through that stored procedure, and it regenerates the list contents by running the query stored in the T_LIST table, but doesn't seem to rebuild that query from the list criteria. I ended up writing a function to rebuild the query, following the rules and formatting that List Builder uses.