01-28-2010 01:47 PM
Yes. Use SQL result set w/Description (if unique) on the condition.
If the calculated field (record) is an OOTB SalesLogix one and you need to copy it, keep the existing PK - otherwise gen a new one if it's a custom one.
01-28-2010 04:16 PM
I'm not sure I understand your answer. I have a datagrid showing query results from a custom table. I want to show two text fields in one column (like Contact.Name or Contact.NameLF). I created a calculated field and it works fine. But if I bundle the customization to install on another DB, I need to add the extra step of creating the calculated field on the target system, and name it exactly the same way or the query will fail. Is there a way around that?
01-29-2010 01:18 AM
Yes there is a way round it; as RJ said you can add the Calculated Field into the Project/Bundle using a "SQL Result Set" or you could use "Insert Record". "SQL Result Set" and "Insert Record" are both actions on the Project used to create the bundle. The record(s) that you want are in the CALCULATEDFIELDDATA table, and remember to select "Generate New IDs on Install".
01-29-2010 06:46 AM