I'm having a problem in creating a formatted search in UDF attached in BP Master Data
If i put this query on the manager:
SELECT A.[U_lupDesc] AS [BP Name]
FROM [dbo].[@SMC_BPTYPE] A
JOIN OCRG B
ON A.U_lupParent = B.GroupCode
WHERE B.GroupName = $[$16.0.1]
Im getting an "Internal Error" upon clicking the formatted search in BP Master Data
[dbo].[@SMC_BPTYPE] - created UDT
$[$16.0.1] - Group(item) in BP Master Data
Is this correct $[$16.0.1]? I was able to get this as $[$item.pane.variable].
Thnx in advance..