The SugarCRM Community is now "read-only" to prepare for the SugarClub launch on August 3. Please visit
Announcing SugarClub - Are you in? for more information.
I have a column name is 'old_value' and it format is nvarchar in database how to show it in listview with format currency instead of a string.
The correct way would be to change the variable from a VARCHAR to decimal(26,6). This has many benefits. Sugar on the from end populates filters based on datatype. If you wanted to have a filterable value in that field, here would be the results:
Text field (VARCHAR)
Filter options: starts with, exactly matches
Currency field (decimal(26,6))
Filter options: is equal to, is greater than, is less than, etc.
As you can see, if you want it to show as a currency, make it a currency. Easiest way? Create a new field. You CAN change the variable datatype in the database and all that jazz, but the end result you are looking for can be done in a fraction of the time and effort by just creating a new field. You can even copy the results over with a super simple SQL query
UPDATE <module> SET new_variable = old_value;
or if there is a custom relational table....
UPDATE <module>, <module_cstm> SET new_variable = old_value WHERE <module>.id = <module_cstm>.id_c;
Retrieving data ...