Announcement

As of April 17, 2018, this site is now in read-only mode. To start new Blackbaud Developer’s discussions, you will find Developer Discussions in the Blackbaud CRM Community.

To post or respond to Blackbaud Community discussions, you will have to login using a www.blackbaud.com login. Learn how to login here. If you have questions or need assistance, please email community@blackbaud.com.

1.7k questions

3.2k answers

401 users

Categories

1.7k questions

3.2k answers

401 users

I have created a smart field spec and a sql stored procedure spec and loaded them into the catalog. Then I configured a new smart field. But when I process the smart field, the job completes without errors but 0 records are processed. However, if I run the smart field stored procedure and the sql stored procedure in sql management studio I get the expected number of records. The stored procedures work if I use null or a specific date for the @ASOF date.

What am I missing?

asked by mpuffer (177 points)

1 Answer

If you have defined:
<common:MetaTags InsertExecTempTableName=... />
the count will be the number of entries in the table defined there. Otherwise the count will be the result of running your procedure (see SqlCommand.ExecuteNonQuery).

If you are still having trouble you can post your spec and I may be able to determine the cause.

answered by danielcooke (3.5k points)
...