Uni Selector Using Macro in the Display Name Format Field

Jay Crowe asked on September 22, 2021 17:34


I am using a macro within the Display Name Format field within the settings for the Uni Selector. It is giving me the output I require but this then breaks the Search functionality of the Uni Selector.

The error I get it to do with the SQL it is building to then search the data:

WITH AllData AS ( SELECT [Review], [ReviewId], [SkuId], ROW_NUMBER() OVER (ORDER BY [SkuId]) AS [CMS_RN] FROM TABLE WHERE ((Review IS NOT NULL AND ShowInReviewsWidget = 1) AND ((SiteObjects.SKUs.Where("SKUID= '"+SkuId+"'").FirstItem.SKUNumber|(user)EMAIL ADDRESS|(hash)5a0253c389ef22d400bffb8a7792686875014b109028f679678d896699d7066b LIKE N'%bar45%') OR (Review LIKE N'%bar45%'))) ) SELECT , (SELECT COUNT() FROM AllData) AS [CMS_TOT] FROM AllData WHERE CMS_RN BETWEEN 1 AND 10 ORDER BY CMS_RN

Does anyone know of a way I can still continue to use my macro but not include it in the search?

   Please, sign in to be able to submit a new answer.