on 04-06-2011 7:26 AM
Hi Experts
I have been tasked to modify the u201CRFxs with Insufficient Biddersu201C Query to include the current phase of each RFx. I have made a copy of the query and modified it to include the CURRENT_PHASE database column from the FCI_RFX_DOC table but that only bring back a number reflecting the current phase not the text.
What I would like to find out is from which table and column can I find the RFx phases stages.
Your help will be greatly appreciated.
Kind regards,
Thabiso Kamanga
Edited by: Kamanga Thabiso on Apr 6, 2011 8:35 AM
Hello Thabiso,
You are almost there. You are gettingn a number as output because CURRENT_PHASE is an Enum, not a string.
Here is how you go about it.
1) Select the corresponding result field's column type as "Enumeration"
2) Select the Enum Type Name as "RFx Scheduled Phase Enum"
Let us know if this works for you.
Thanks
Devesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Devesh
thank you very much, i really appreciate the help. it worked
problem solved.
keep doing the excellent work!
thanks again...
kind regards,
Thabiso Kamanga
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.