Adding options into custom querying in OperationBindings?

[user316]

Hello,

In an OperationBinding in a datasource file, we have the <whereClause>, <orderClause>, <groupClause>, etc.

However, we would like to insert options into the SQL statements as well, such as (in bold below):

SELECT Type AS Type,
DisplayValue AS DisplayValue,
Value_FK AS Value_FK,
Lookup_Attr AS Lookup_Attr
FROM v_TKR_FS_StageStats_Corners
WHERE Lookup_Attr IN ('89516')
AND Lookup_Attr IS NOT NULL
ORDER BY Type, DisplayValue ASC
OPTION (LOOP JOIN, FAST 1)


Where could we put these options inside the custom <OperationBinding>?

[Isomorphic]

You could go with <orderClause>$defaultOrderClause OPTION ...