Hi all,
Curious if anyone else has run into this before and what the problem and solution(s) might be.
When trying to open a List Manager list, this particular list won't open and keeps getting stuck in "thinking" mode. Screenshot of the screen that I get stuck on below. The user who created this list is quite sure she used SQL criteria specifically for a free text field instead of graphical interface. Is this potentially the issue? Is this a known problem?
Additionally (and maybe related), is this "revert" button connected to the use of SQL criteria?
I'd put a Support ticket in.
But if you want to check the criteria and have SSMS access you can run the cpde at the bottom (with your List Number instead of XXX) to get the SQL from your problem list and checking to see if there seems to be something probematic.
I usually change the start of the script by adding in top 10 in case it's pulling a huge ammount
eg: I'll add TOP 10 in here
Select TOP 10 Distinct a.customer_no From V_CUSTOMER_WITH_PRIMARY_GROUP a (Nolock)
Select TOP 10 Distinct a.customer_no
From V_CUSTOMER_WITH_PRIMARY_GROUP a (Nolock)
Use impresario Select criteria from T_LIST where list_no = XXX