A customer would like to know which IBM Connections Communities have a Sharepoint widget added. The following SQL statement should give the UUID and the name of these Communities:
|
1 |
select COMMUNITY_UUID,NAME from SNCOMM.COMMUNITY where COMMUNITY_UUID IN(select EXT_RESOURCE_ID from SNCOMM.LC_EXTENSIONS where dbms_lob.instr(EXT_VALUE_EXTENDED,utl_raw.cast_to_raw ('SharePointFiles'), 1,1)>0); |
The customer also wanted to send a mail to all creators