I’m going to let the screen shot do all the talking. Where do you find what’s below?
There is not a DMT for the calculated expression that you can assign to a Dynamic Attribute Class (AUOM). I’ve traced and found the BO, but still no idea where the data is ending up in the DB.
You are wanting to know where the formula is stored?
Yes
ICE.QueryField
We have a BAQ on this as I can’t always remember formula - the calculation is in the Formula field.
select
[QueryField].[QueryID] as [QueryField_QueryID],
[QueryField].[FieldName] as [QueryField_FieldName],
[QueryField].[FieldLabel] as [QueryField_FieldLabel],
[QueryField].[FieldFormat] as [QueryField_FieldFormat],
[QueryField].[DataType] as [QueryField_DataType],
[QueryField].[IsCalculated] as [QueryField_IsCalculated],
[QueryField].[Formula] as [QueryField_Formula]
from Ice.QueryField as QueryField
where (QueryField.IsCalculated = true)
This is for AUOM, not a query.
If no one knows the answer, any suggestions on where to look? I am guessing it is probably a system table (ICE)?
To my knowledge, the formula is stored in the Formula field of the Ice.QueryField table as @Patrick said.
@jkane Maybe you can use the sp below and find part of the equation assuming it is text. I have used it to find where data is stashed a few times, so hopefully it work.
SearchAll.sql (2.0 KB)
Sorry, I don’t have AUOM so I can’t search for it.
Formula field in [Erp].[DynAttrClassField] table. And FullExpression field in the same table.
Yes, that is the DynAttrClass table and the field help says that column is obsoleted.
This is because it is not in ZData, so you can only access it using external BAQ
Thanks!
