How to update a calculated field in Siebel ?
Calculated fields do not support updates (even simple expressions like [Field]), unless specialized business components override SqlSetFieldValue.
But this answer can be proved wrong with some stupid workarounds…see the next one
How to make Calculated Fields editable ?
By default, calculated fields are read-only but we can make it editable.
Create a Calculated Field with a picklist and a pickmap or simply with a blank calculated value and expose it in the UI and you would it editable and not grayed out the way typical calculated fields behave. You can enter values into the field or pick a record and save the record the value would remain as it is run.
Now refresh the applet and the value would disappear.
So basically what is happening here is siebel is writing the value to the active instance of the buscomp and once refreshed it is cleaned up. Since a Calculated Field is not mapped to any database column Siebel would never even try to accomodate a field change on Calculated Field into a sql insert or update.
But with scripting we can set values in fields what we have defined in Pickmap and finally get updated value in our Calculated field.
What is the default field type of calculated fields ?
For a calculated field whose calculated value is not of type DTYPE_TEXT, the field type must be specified explicitly.
Can we assign column in caluclated fields ?
Calculated fields cannot be stored in columns.
Can we apply validation criteria on calculated fields ?
Validation criteria on calculated fields are ignored.
Can we execute queries on calculated fields ?
Queries on calculated fields are always supported.
When a query is performed on a calculated field, the action taken by your Siebel application (and thus the resulting performance) depends on which functions are used within the calculation. Functions that can be incorporated directly into the WHERE clause in the SQL statement are incorporated. Functions that cannot be directly incorporated, such as IIf() and Lookup(), result in testing each record in the business component to determine which records to display to the user, at a considerable performance cost.
Can we do sorting on calculated fields ?
Sorting on calculated fields is never supported.
Can we use caculated fields inside a caculated field ?
A calculated field may be based on the results of another calculated field in the same business component. There is no limitation on the number of levels of calculated fields based on other calculated fields.
Can we use a calculated field to show a hyperlink/url ?
You can put hyperlinks in calculated fields by using the <a href= …></a> HTML tag.
[su_divider style=”dotted”]