Question

Photo of Ken Roach

0

How can my dynamic data block SQL make use of Data Views?

1

For example, if I have a data view, 'NOT Baptised' where there is no Baptism Date set, how can I reference this data view in the SQL statement used in a dynamic data block?

This is a simple example, and it would be easy to add the same where clause to the dynamic block SQL, but this data view is also built on the 'Adult Members and Attendees' data view, so it would be nice to be able to reference it without having to add in all the WHERE clauses in that basic data view.

  • Photo of Frank Grand

    0

    Hey Ken!

    I don't think this is a current feature.  I definitely see where this would be useful!  Would you mind submitting the idea to the Rock core team as an idea for the black book?  (rockrms.com/ideas)