Community Contributions > SQL Workbench

Disabling Cubbies Stickers

(1/1)

Eric Berry:
What is the SQL commannd to remove all of the Cubbies stickers as awards?  I don't need to be notified about every single sticker that needs to be given out.

Rick Leffler:
Notice on the Award Message dialog there is a checkbox that says "For Cubbies, do not show this Award Message for all subequent awards today."  Using this checkbox you will only see ONE notification.

I know this is not exactly what you asked for, but I think it solves the problem.

Eric Berry:
That also seems to disable notification of the patches too, which I don't want to do.

Rick Leffler:
If you want to clear all of the award triggers for all of the individual Cubbies Stickers for all sections in all of the Cubbies books, you can run the following SQL:

update Gen_Section set Award_1=null, Award_2=null,
Award_1_Item_Number=null, Award_2_Item_Number=null
where Book_ID in (300,301,302,303,304)


Note: Running this SQL statement will NOT affect the award triggers for the Cubbies patches since the patches are part of the Section GROUP award records you see on the last page of the generic handbook screen.

Navigation

[0] Message Index