sp7_scope_table_picklists_{Coll_id} pref is not working for every db #7589
Description
Investigate why the collection pref is working only for certain collections / dbs
This should be the working behavior:
- Go to Collection Preferences
- Verify the sp7_scope_table_picklists pref is enabled
- Verify on a form that pick list for entire tables are using only the items available for the logged in collection (i.e on the CO form, create a prep, open the drop down for prep type and verify that the options are only from that collection)
- Go to Collection Preferences
- Disable the pref
- Verify on a form that pick list for entire tables are using all the items available across collection (i.e on the CO form, create a prep, open the drop down for prep type and verify that there are options from all collections)