Save Extension Field

[former_member398983]

Hi Experts

I have added an Extension Field to an RFX which I go count the number of RFx Responses and display it on screen. My problem is how do I save that same value on the database so I can read it from a Query. The script Target is on "Loaded".

supcolln = doc.getProposals();

number = supcolln.size();

doc.getExtensionField("EXT_Supplier_Count").set(number);

How do I get to save the set value to the database.

Thanks in advance

[Former Member · Accepted solution]

Hi,

You should just move your exact code from 'Loaded' to 'Validate' script.

PS: if the only purpose of this is the query result, you can do the calculation directly in the query without the need of an extension field.

Bogdan

[former_member398983 · Accepted solution]

Hi Bogdan

I think the idea of getting it directly from the query result is a perfect one. May you please assist of how the code on the result field be constructed.

Regards

[Former Member · Accepted solution]

? ... COUNT

( SELECT COUNT(*)

   FROM {rfx response table} frr

   WHERE frr.PARENT_OBJECT_ID = {parent alias}.OBJECTID )

this is the most simple form ... you should query as per your specific requirements.

Bogdan

[former_member398983 · Accepted solution]

Works like a charm. Thank you very much