SqlIdFilterHelperTBuildWhereClause Method (String)

Builds a where-clause based on a query template.

Namespace: Omada.OE.AppLogic.Helpers
Assembly: Omada.OE.AppLogic (in Omada.OE.AppLogic.dll) Version: 15.0.0.0

Syntax

public void BuildWhereClause(
	string queryTemplate
)

queryTemplate: Type: SystemString
Template query. Must contain: <temptable>join $temptable$ on Id = bar</temptable> and must contain: <idin>where/and foo.bar in ($delimids$)</idin> Example: exists (select 1 from tbldataobjectsecurity dos <temptable>join $temptable$ on $temptable$.Id = dos.usergroupid</temptable> where dos.dataobjectid = do.securityobjectid <idin>and dos.usergroupid in ($delimids$)</idin> and dos.readaccess = 1)

SqlIdFilterHelperAddLanguageSpecificTextSet("LSTB08043F2_0?cs=&lt;|vb=(Of |cpp=&lt;|fs=&lt;'|nu=(");TAddLanguageSpecificTextSet("LSTB08043F2_1?cs=&gt;|vb=)|cpp=&gt;|fs=&gt;|nu=)");AddLanguageSpecificTextSet("LSTB08043F2_2?cpp=::|nu=.");BuildWhereClause Method (String)