Non-production environment flag - how to set in SQL

David Wanless
David Wanless
Tenth Anniversary Kudos 1 Name Dropper Participant
in Blackbaud CRM™ General Discussions

Hi all,

Does anyone know how to set the ‘Non-production environment’ flag in SQL?

I've been searching and can't find which table it's stored in.

Ciao,

David.

Tagged:

Comments

  • John Auwaerter
    John Auwaerter
    Fifth Anniversary Name Dropper Facilitator 1

    Hi David,
    If you are referring to the BBIS setting, I believe the following should do it:

    exec dbo.USP_INSERT_UPDATE_CRMBBENVIRONMENT @Id='ACC537E6-028D-4C72-9AC8-0E2BE19636AB',@Text=N'Production',@IsActive=0
    exec dbo.USP_INSERT_UPDATE_CRMBBENVIRONMENT @Id='1CBC46DA-71B2-40FF-BB11-26B1D9073515',@Text=N'Staging',@IsActive=1

  • Phil Higgs
    Phil Higgs
    Ninth Anniversary Kudos 1 Name Dropper Participant

    HI David We have a global change to set the non-prod Scheduled emails, and merchant accounts. You may need to change one search criteria, where we use Plan accounts. I'll send a link.

    Phil Higgs, Plan ANO

  • David Wanless
    David Wanless
    Tenth Anniversary Kudos 1 Name Dropper Participant

    Thanks, John and Phil. Yes, that's the table. Thanks very much for your help, and thanks, Phil for the Global Change code. That's enabled me to set some other things as well.

  • David Wanless
    David Wanless
    Tenth Anniversary Kudos 1 Name Dropper Participant

    Yash from Blackbaud Pacific was also very helpful in finding this table (CRMBBENVIRONMENT).

  • Gregory Dellas
    Gregory Dellas Blackbaud Employee
    Ninth Anniversary Kudos 1 Name Dropper Participant

    Hey Phil, are you able to share the documentation for this global change please. - Sounds like it might be handy for broader use :-)

Categories