I’m trying to use ftLibraryDataSQLWhere to limit library data to a subset. Here’s what I’m doing
<cfscript>
stPropMetadata = structNew();
stPropMetadata.aSupplierContactIDs.ftLibraryDataSQLWhere="objectID IN (#quotedValueList(qSupplierContacts.objectID)#)";
stPropMetadata.aSupplierContactIDs.ftLabel="Dummylabel";
</cfscript>
<wiz:object objectID="#stWizard.PrimaryObjectID#" lfields="aContactIDs,aSupplierContactIDs" legend="Kontaktpersoner" stPropMetadata="#stPropMetadata#" />
The label property is used, so passing in stPropMetadata works, but ftLibraryDataSQLWhere is not picked up
For testing purposes you can also do:
stPropMetadata.aSupplierContactIDs.ftLibraryDataSQLWhere="1 = 2";
This should prevent any items in the library list - but the full set is still returned.