cancel
Showing results for 
Search instead for 
Did you mean: 

RFx Query Current phase database column

0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (1)

Answers (1)

0 Kudos

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