Question

Photo of Cody Tindall

0

Dynamic Data Blocks

1

I'm trying to setup dynamic data blocks so that our Finance Administrator can have a "dash board" that breaks down the infomation by tender type and accounts. This way its easier to validate that the information entered into Rock matches the amounts going to the bank. My biggest problem is when i'm writing the SQL queries I have to guess what the table name is and then guess again what the column name is... Is there a chart or somthing that i'm missing that I can reference for this information?

  • Photo of Jim Michael

    1

    I haven't seen a data dictionary for Rock (though there may be one on the Wiki, I haven't checked.) We typically fire up SQL Server Management Studio to just look at the database directly... which is easy if you're hosting Rock locally. If you're using a hosting provider, I'm not sure if they typically provide access to that tool or similar, but it should be easy to check if that's your situation. 

    • Cody Tindall

      Cody Tindall

      Thanks, we're not hosting locally and I've never used SSMS but ill give it a go. I'm still hoping for something a little less "out of the way" it can get tedious if I have to use it each time to verify a query.