At the moment, it does not seem possible to run a query where the criteria is solely based on a particular Solicit Code e.g. ‘Email Opt-In All’ and to also output the date and source of that Solicit Code.
From, my understanding so far, the only workaround (which isn’t really a reliable workaround) is to output the ‘Constituent Contact Consents’ which pulls out every ‘Email Opt-In All’ even if the constituent has subsequently opted-out.
So, could I please submit that this issue is addressed so that we can Query output a current Solicit Code's date, source and any other relevant information. It will also be helpful if this option was available in Exports. This solution will be invaluable for organizations who need to cross-reference consents from two different CRMs and therefore need a consent date to make that happen.