Simple DataList Spec

Bruce Boling

Can someone tell me why this simple data list spec fails to reach catalog pull down window…

<SimpleDataListSpec
xmlns="bb_appfx_simpledatalist"
xmlns:c="bb_appfx_commontypes"
ID="ada1fa1a-e0ad-4f8a-bdcd-5d0882139142"
Name="Rev Recog Type Code"
Description="Rev Recog Type Code"
Author="General\\User"
TranslationFunctionID="00000000-0000-0000-0000-000000000000"
>

<SPSimpleList SPName="USR_USP_SIMPLEDATALIST_RevRecogTypeCode">
<c:CreateProcedureSQL >
<![CDATA[
create procedure dbo.USR_USP_SIMPLEDATALIST_RevRecogTypeCode
as
set nocount on;

select
DESCRIPTION as VALUE,
DESCRIPTION as LABEL
from dbo.revenuerecognitiontypecode
where id not in ('CCB1C00E-E388-4BE0-966F-DA61703DCDD9', --Exclude
'1A8874DD-E2EB-4B16-838F-1EF296B3794A') --Exclude
order by DESCRIPTION;

]]>
</c:CreateProcedureSQL>
</SPSimpleList>

</SimpleDataListSpec>

Syed Mohsin Ali Rizvi

@Bruce Boling If you can try without the Translation function tag. And also not sure if the behavior will be correct since it should have a uniqueidentifier and text value

Bruce Boling

@Syed Mohsin Ali Rizvi
Thanks for the quick reply. Not sure what the translation function is for, I saw examples where it was zeroed out, that is why I did it. I will remove and see if that helps.

Bruce Boling

@Syed Mohsin Ali Rizvi
Removing translation function statement did not work. Trying to do simple datalist to use on list builder spec as a drop-down list for filter. Nee to remove 2 codes from code table is why I'm doing this.

<OutputField Name="Recognition Type" Caption="Recognition Type" DataType="String" >
<LookupInfo>
<SimpleDataList SimpleDataListID="ada1fa1a-e0ad-4f8a-bdcd-5d0882139142"> </SimpleDataList>
</LookupInfo>
</OutputField>

Syed Mohsin Ali Rizvi

@Bruce Boling
select
ID as VALUE,
DESCRIPTION as LABEL
from dbo.revenuerecognitiontypecode
where id not in ('CCB1C00E-E388-4BE0-966F-DA61703DCDD9', --Exclude
'1A8874DD-E2EB-4B16-838F-1EF296B3794A') --Exclude
order by DESCRIPTION;

This should work

Bruce Boling

@Syed Mohsin Ali Rizvi
Did not work. I saw examples where both the value and label were set to description. Catalog screen senses something is wrong and keeps this DLL out of drop down. I shut visual studio down and restarted and build DLL again (sometimes works) but it did not. You're the only one trying to help I appreciate it very much. Never had this much trouble with a spec, must be missing a command or something. I don't really know if translation function is needed or not, not sure what it is used for. I can always give up and just hard code the tables values in the list builder spec but I thought this was slicker. Gonna keep trying.

Bruce Boling

@Syed Mohsin Ali Rizvi
I have an idea I will try this morning. Will let you know.

Bruce Boling

@Syed Mohsin Ali Rizvi
Finally got the DLL to show in catalog drop down. My error was I copied an existing unused spec, instead of creating a new one in project folder. Just does not work. Thanks for your suggestions.