Forum Discussion

FabioG's avatar
FabioG
New Contributor III
5 days ago

Using Assembly's XFBRs

Hi all, I'm in trouble in using an XFBR from an Assembly, inside a Data Adapter. I've just discovered that it's possible to use the XFBR function as part of a SQL Command, like this: SELECT * FROM...
Extensibility
FabioG's avatar
FabioG
New Contributor III
3 days ago

Thanks DanielWillis for your answer,

made some more test on my Data Adapter, executing it through the "Test Data Adapter" button. I changed the query, just to see how translation behaves:

AND a.Cube LIKE 'XFBR(WS, All2Like, Param=TEST)'
AND a.Cube LIKE 'XFBR(Workspace.MyActualWorkspaceName.MyActualAssemblyName, All2Like, Param=TEST)'
AND a.Cube LIKE 'XFBR(Workspace.Current.MyActualAssemblyName, All2Like, Param=TEST)'
AND a.Cube LIKE 'XFBR(XFBR_GetParamValue, ParamValue, Param=TEST)'  => This is the "old style" Business Rule

Once translated it's like this:

AND a.Cube LIKE 'TEST'
AND a.Cube LIKE '#ERROR: XFBR[Workspace.MyActualWorkspaceName.MyActualAssemblyName, All2Like, Param=TEST]'
AND a.Cube LIKE '#ERROR: XFBR[Workspace.Current.MyActualAssemblyName, All2Like, Param=TEST]'
AND a.Cube LIKE 'TEST'

I'm currently on 8.4.0, I'll manage to repeat those tests on 8.5

 

Best Regards

FabioG