Gift Capacity on custom tile changed from Money to String. Getting error when loading the tile.

Meg Puffer · June 2023

Error: The section could not be loaded. L10: $100,000+ was not recognized as a valid money value.

I changed the datatype for GIFTCAPACITY from Money to String in the ViewDataForm. What else needs to be changed?

<ViewDataFormTemplateSpec
xmlns="bb_appfx_viewdataformtemplate"
xmlns:common="bb_appfx_commontypes"
ID="d089218d-85dc-49f2-a378-077248f64fc0"
Name="Constituent Summary Research Tile View Form"
Description="A data form for viewing constituent summary research org tile records"
Author="MP"
DataFormInstanceID="1836c59e-6ea5-4f3f-9bf5-7e23621a3f79"
RecordType="Constituent"
common:SecurityUIFolder="Constituent\\Custom"
>
<SummaryTile>
<Categories>
<Category Name="Individual" TileName="Research" DefaultVisible="true" DefaultSequence="18" />
<Category Name="Organization" TileName="Research" DefaultVisible="true" DefaultSequence="18" />
</Categories>
</SummaryTile>

<SPDataForm SPName="USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYRESEARCHORGTILE">
<common:CreateProcedureSQL>
<![CDATA[
create procedure [dbo].[USP_DATAFORMTEMPLATE_VIEW_CONSTITUENTSUMMARYRESEARCHORGTILE]

(
@ID uniqueidentifier,
@DATALOADED bit = 0 output,
@ROWS xml = null output
)
as
/***************************************************************
MP Jun 21, 2023 Changed capacity to use KCI Capacity Level attribute
MP Feb 24, 2017 Added Request ID
MP Dec 30, 2016 Modified CAPACITY.VALUE
MP Dec 29, 2016 Added DEV Wealthscape Capacity attribute

left outer join [dbo].[V_QUERY_ATTRIBUTE6704B66BFAAD4051BDEE7C58CB7BD15D] as [CAPACITY] on [V_QUERY_MODELINGANDPROPENSITY_SIMPLE].[ID] = [CAPACITY].[ID] --dev
****************************************************************/
set nocount on;

-- be sure to set this, in case the select returns no rows
select @DATALOADED = 1 from dbo.CONSTITUENT where ID = @ID;

-- populate the output parameters, which correspond to fields on the form. Note that
-- we set @DATALOADED = 1 to indicate that the load was successful. Otherwise, the system
-- will display a "no data loaded" message.

set @ROWS =
(
select DISTINCT
C.ID as ROWID,
[dbo].[UFN_SFU_ALIASBYHIERARCHY](C.ID) as ALIAS,
case isdate(BIRTHDATE)
when 1 then convert(varchar(10),convert(date,BIRTHDATE,101),101)
else ' '
end as BIRTHDATE,
case C.ISORGANIZATION when 0 then
CONCAT(isnull(C.GENDER,''),
' / ',
case CONVERT(VARCHAR,C.AGE)
when '0' then ' '
else CONVERT(VARCHAR,C.AGE)
end)
when 1 then ' '
else ' '
end as GENDERAGE,

CONCAT (PMNAME.NAME, ' ', (select top 1 REQUESTNO --MP Feb 24, 2017
from PROSPECTRESEARCHREQUESTCONSTITUENT PRRC
where C.ID = PRRC.CONSTITUENTID
and [STATUS] in (N'Pending', N'In progress', N'Assigned'))) AS PM,
case
convert(VARCHAR,isnull([LIFETIME].[VALUE],''))
when '0.00' then ' '
ELSE convert(VARCHAR,isnull([LIFETIME].[VALUE],''))
end as [LIFETIME],

CAPACITY.VALUE as [GIFTCAPACITY],

C.ISORGANIZATION as TYPE
from CONSTITUENT C left outer join [dbo].[V_QUERY_MODELINGANDPROPENSITY_SIMPLE] on [C].[ID] = [V_QUERY_MODELINGANDPROPENSITY_SIMPLE].[ID]
--left outer join [dbo].[V_QUERY_ATTRIBUTE8798885145184EB78D0FBBDBDC20EB6A] as [CAPACITY] on [V_QUERY_MODELINGANDPROPENSITY_SIMPLE].[ID] = [CAPACITY].[ID]
left outer join [dbo].[V_QUERY_ATTRIBUTE189EA30BA04E44CF91C2532A5EF2E077] as [CAPACITY] on [V_QUERY_MODELINGANDPROPENSITY_SIMPLE].[ID] = [CAPACITY].[parentID] --MP Jun 21, 2023

left outer join [dbo].[V_QUERY_SMARTFIELD76DED34BE0404547884512F1393A3FBE] as [LIFETIME] on [C].[ID] = [LIFETIME].[ID]
left outer join PROSPECT P on C.ID = P.ID
left outer join ALIAS A on C.ID = A.CONSTITUENTID
left outer join ALIASTYPECODE ATC on A.ALIASTYPECODEID = ATC.ID
outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(P.PROSPECTMANAGERFUNDRAISERID) PMNAME

where C.ID = @ID
and P.PROSPECTMANAGERENDDATE is null
for xml raw('ITEM'),type,elements,root('ROWS'),BINARY BASE64);
return 0;
]]>
</common:CreateProcedureSQL>
</SPDataForm>

<FormMetaData xmlns="bb_appfx_commontypes">
<FormFields>
<FormField FieldID="ROWS" DataType="XML" Hidden="true" AvailableToClient="false">
<Collection IDField="ROWID">
<Fields>
<FormField FieldID="ROWID" DataType="Guid" />
<FormField FieldID="ALIAS" DataType="String" />
<FormField FieldID="BIRTHDATE" DataType="String" />
<FormField FieldID="GENDERAGE" DataType="String" />
<FormField FieldID="PM" DataType="String" />
<FormField FieldID="LIFETIME" DataType="Money" />
<FormField FieldID="GIFTCAPACITY" DataType="String" />
<FormField FieldID="TYPE" DataType="String" />
</Fields>
</Collection>
</FormField>
</FormFields>

</ViewDataFormTemplateSpec>