We search for information in uc4 objects content (e.g., PROCESS, PREPROCESS, POSTPROCESS tabs) on a regular basis. Because of a change in content from varchar to CLOB, we must do the conversion in the query. This works but the performance suffers and we find it unusable in some contexts.
Has anyone found a way to perform content search in uc4/V12 objects with SQL with good performance?