my sql
SELECT DISTINCT
"SAMPLE"."SAMPLENO" AS "SampleNo",
"BASEDATA"."DESCRIPTION" AS "Stylist",
"BASEDATA"."DESCRIPTION_C" AS "CStylist",
"BASEDATA"."DESCRIPTION_S" AS "MStylist"
FROM
"SAMPLE" ,"BASEDATA"
WHERE "SAMPLE"."BASECODE20" = "BASEDATA"."BASECODE"(+) AND
"SAMPLE"."COM_ID" = "BASEDATA"."COM_ID"(+) AND "BASEDATA"."BASETYPEID" (+)= 20
my code
filterBucket.Relations.Add(new EntityRelation(BaseDataFields.BaseCode, SampleFields.BaseCode20, RelationType.OneToMany), JoinHint.Left);
relat = filterBucket.Relations[0] as IEntityRelation;
relat.AddEntityFieldPair(BaseDataFields.ComId, SampleFields.ComId);
relat.CustomFilter=new PredicateExpression(BaseDataFields.BaseTypeId==20);
llb gen the sql
WHERE "SAMPLE"."BASECODE20" = "BASEDATA"."BASECODE"(+) AND
"SAMPLE"."COM_ID" = "BASEDATA"."COM_ID"(+) AND (("BASEDATA"."BASETYPEID" = 20 ))
i find it miss (+) in the "BASEDATA"."BASETYPEID"
how can i add it?
