IN operator (multifull conditions)

[Anonymous]

HI
which component supports IN OPERATOR in TOS?

Regards

[Anonymous]

Hello Shiva
Do you mean the In operator in sql? If so, both of tMysqlInput and tMysqlRow allow you to write it.
Best regards

shong

[Anonymous]

Hi Shong,

i need to put multifull(more than 2) conditions in tfilterrow,
q:How can i put more than 2 conditons in tfilterrow?
q:tfilterrow supports sql IN operator?if supports,how?
Regards

[Anonymous]

Hello

q:How can i put more than 2 conditons in tfilterrow?

You can use the advanced model, eg:
input_row.id>3&&input_row.name.equals("shong") //&& for and
or
input_row.id>3||input_row.name.equals("shong") // || for or

q:tfilterrow supports sql IN operator?if supports,how?

No, it is impossible.
Best regards

shong

[Anonymous]

hi thank u for ur information!
q:can u possible to provide inputcontrols in mapping,like parameters in reports?

q:Which components supports for creating a variables in TOS?(other than tmap)

q:how to create variables in tmap?

Regards

[Anonymous]

hi
how to change condtions dynamically?
regards

[Anonymous]

Hello

q:can u possible to provide inputcontrols in mapping,like parameters in reports?

Sorry, it's not clear for me.

q:Which components supports for creating a variables in TOS?(other than tmap)
q:how to create variables in tmap?

tJava, tJavaRow, eg: globalMap.put("key", value); globalMap.put("key",input_row.name);
tSetGlobalVar: you can define a global var.

how to change condtions dynamically?

Just an simple scenario,
tFileInputDelimited(query the condition: id)--row1--tFlowToIterate--tMysqlInput--tFilterRow(set the condition dynamically, input_row.id>(Integer)globalMap.get("row1.id"))
Best regards

shong