jpadilla
23rd August 2002, 17:54
How can I do that session tccom0501m000 only display the employees that match with a condition, e.g works in a specific work center..
I'm usuing IVc4.
klesch
23rd August 2002, 18:05
Try using query.extension variable. Put your condition in there. It will be added to WHERE clause of the standard program. Do this in the before.program section.
Example:
before.program:
query.extension = "tccom001.ctrg = ""FOO"""
jpadilla
23rd August 2002, 18:42
Thank you Klesh,
just another question.... can a OR condition be used in this command ??
klesch
23rd August 2002, 19:57
Do you mean something like this? Yes, it is possible.
query.extension = "(tccom001.ctrg = ""FOO"") or (tccom001.ctrg = ""BAR"")"
jpadilla
23rd August 2002, 21:12
Thank you Klesh,
You have the rigth answer.
Regards
JP