ListGrid shows valueField not displayField

[jay.l.fisher]

I have a new data source with a number of different fields that look like this.

<field name="catalog" nativeName="DCACAT" tableName="DORDHDR" title="Catalog" type="text" menuItem="Order>"
optionDataSource="DCATLOG" valueField="DCACAT" displayField="DCADES"
foreignKey="DCATLOG.DCACAT"/>

When I use this data source in a ListGrid, they are all showing the valueField value, not translating that into the displayField value.

I've used this technique many times before, but I can't seem to spot what I'm doing wrong this time. Any tips on what to double-check?

Could using different name and nativeName attributes have an affect?

[Isomorphic]

Have you already checked the basics like - are there values in the "DCACAT" field of the optionDataSource which actually match the values in the "catalog" field, and have non-empty DCADES values?

Also, does it work if you don't use nativeName?

[jay.l.fisher]

Yes. I've double-checked the field names and data. It doesn't matter if I remove the nativeName and just set name to the actual SQL column name. Very strange. I have another data source with a different optionDataSource which works (with the same SC version) and I've compared the two and can't see any difference. I'm stumped.

There are 9 different fields in this data source that all have the same basic setup for optionDataSource, different fields and related tables, but all are essentially the same and none work.

[jay.l.fisher]

Here is the full ds.xml, and a couple of the related ds.xml files for two of the optionDataSources. I was confused about whether the valueField should be the name of the field in the optionDataSource or the name in the referring data source, but I now see that it should be the name in the optionDataSource so I've corrected them all. But I had already tried with some set one way and some the other and neither worked.

<DataSource ID="OrderLineSearch" dataFormat="iscServer"
	webServiceOperations="fetch" serverType="sql" dbName="as400" tableName="DORDLIN"
	serverConstructor="com.islandpacific.gui.server.customDataSource.IpDataSource">
	<fields>
		<!-- HEADER -->
		
		<field name="receivedOn" nativeName="DCORDT" tableName="DORDHDR"
			title="Received on" type="date" sqlStorageStrategy="number" length="8" menuItem="Order>Dates>"/>
					
		<field name="orderNumber" nativeName="DCONUM" tableName="DORDHDR"
			title="Order" type="text" width="70" menuItem="Order>" />
					
		<field name="billToName" title="Bill to Name" type="text" width="100"
			customSelectExpression="TRIM(DCUSMAS.DCUFNM)||' '||DCUSMAS.DCULNM"
			menuItem="Bill To>" canFilter="false" />
					
		<field name="billToAddress" title="Bill to Address" type="text" width="100"
			customSelectExpression="TRIM(COALESCE(DAAAD1, DCUAD1))||', '||TRIM(COALESCE(DAACTY, DCUCTY))||' '||TRIM(COALESCE(DCUSADD.FCNCUN, DCUSMAS.FCNCUN))||' '||TRIM(COALESCE(DCUSADD.DPCZIP, DCUSMAS.DPCZIP))"
			menuItem="Bill To>" canFilter="false" />			
						
		<field name="DOTTYP" tableName="DORDHDR" 
			title="Order Type" type="text" menuItem="Order>"
			optionDataSource="DORDTYP" valueField="DOTTYP" displayField="DOTDES"
			foreignKey="DORDTYP.DOTTYP" detail="true" />
			
		<field name="source" nativeName="DSOSRC" tableName="DORDHDR" 
			title="Source" type="text" menuItem="Order>"
			optionDataSource="DSOURCE" valueField="DSOSRC" displayField="DSODES"
			foreignKey="DSOURCE.DSOSRC" detail="true" />
			
		<field name="sourceCode" nativeName="DSOSRC" tableName="DORDHDR" 
			title="Source Code" type="text" menuItem="Order>" detail="true" />
			
		<field name="channel" nativeName="DCDDIV" tableName="DORDHDR" 
			title="Channel" type="text" menuItem="Order>"
			optionDataSource="DCATDIV" valueField="DCDDIV" displayField="DCDNAM"
			foreignKey="DCATDIV.DCDDIV" detail="true" />

		<field name="channelCode" nativeName="DCDDIV" tableName="DORDHDR" 
			title="Channel Code" type="text" menuItem="Order>" detail="true"/>
	
		<field name="catalog" nativeName="DCACAT" tableName="DORDHDR" 
			title="Catalog" type="text" menuItem="Order>"
			optionDataSource="DCATLOG" valueField="catalogId" displayField="catalogDescription"
			foreignKey="DCATLOG.catalogId" detail="true" />
											
		<field name="catalogCode" nativeName="DCACAT" tableName="DORDHDR" 
			title="Catalog Code" type="text" menuItem="Order>" detail="true"/>
						
			
		<field name="orderStatus" nativeName="DCOSTS" tableName="DORDHDR" 
			title="Order Status" type="text" width="100" menuItem="Order>">
			<valueMap>
				<value ID="0">Incomplete</value>
				<value ID="1">Unreleased</value>
				<value ID="2">CS Hold</value>
				<value ID="3">Auth Pending</value>
				<value ID="4">Auth Retry</value>
				<value ID="5">In Process</value>
				<value ID="8">Completed</value>
			</valueMap>
		</field>
		<field name="orderTotal" title="Order Total" type="currency"
			customSelectExpression="DCOMER+DCOHAN-DCODSA+DCOTAX+DCOGIF"
			menuItem="Order>" />
		
		<!-- ORDER DATES -->	
		<field name="enteredBy" nativeName="DCOUSR" tableName="DORDHDR" detail="true"
			title="Entered by" type="text" length="10" menuItem="Order>Dates>" />
 		<field name="enteredOn" nativeName="DCOEDT" tableName="DORDHDR" detail="true"
 			title="Entered on" type="date" sqlStorageStrategy="number" length="8" menuItem="Order>Dates>"/>
 		<field name="enteredAt" nativeName="DCOETM" tableName="DORDHDR" detail="true"
 			title="Entered at" type="time"
 			customSelectExpression="TIME(substr(digits(DCOETM),1,2)||':'||substr(digits(DCOETM),3,2)||':'||substr(digits(DCOETM),5,2))" 
			menuItem="Order>Dates>"/>
 		<field name="updatedBy" nativeName="DCOLUU" tableName="DORDHDR" detail="true"
 			title="Last Updated by" type="text" length="10" menuItem="Order>Dates>"/>
		<field name="updatedOn" nativeName="DCOLUD" tableName="DORDHDR" detail="true"
			title="Last Updated on" type="date" sqlStorageStrategy="number" length="8" menuItem="Order>Dates>"/>
		<field name="updatedAt" nativeName="DCOLUT" tableName="DORDHDR" detail="true"
			title="Last Update at" type="time"
			customSelectExpression="TIME(substr(digits(DCOLUT),1,2)||':'||substr(digits(DCOLUT),3,2)||':'||substr(digits(DCOLUT),5,2))" 
			menuItem="Order>Dates>"/>
		<field name="releasedOn" nativeName="DCORLD" tableName="DORDHDR" detail="true"
			title="Released on" type="date" sqlStorageStrategy="number" length="8" menuItem="Order>Dates>"/>
		<field name="releasedAt" nativeName="DCORLT" tableName="DORDHDR" detail="true"
			title="Released at" type="time" 
			customSelectExpression="TIME(substr(digits(DCORLT),1,2)||':'||substr(digits(DCORLT),3,2)||':'||substr(digits(DCORLT),5,2))" 
			menuItem="Order>Dates>"/>
		<field name="acceptedOn" nativeName="DCOPCD" tableName="DORDHDR" detail="true"
			title="Accepted on" type="date"  sqlStorageStrategy="number" length="8" menuItem="Order>Dates>"/>
		<field name="lastBONoticeOn" nativeName="DCOBNS" tableName="DORDHDR" detail="true"
			title="Last BO Notice on" type="date" sqlStorageStrategy="number" length="8" menuItem="Order>Dates>"/>
 
		<!-- BILLTO -->
			
		<field name="billToCustomerId" nativeName="DCUCUS" tableName="DORDHDR" detail="true"
			title="Bill to Customer" type="text" length="10" menuItem="Bill To>" />
			
		<field name="billToLastName" nativeName="DCULNM" tableName="DCUSMAS"
			title="Bill to Last Name" type="text" menuItem="Bill To>" detail="true" />
			
		<field name="billToFirstName" nativeName="DCUFNM" tableName="DCUSMAS"
			title="Bill to First Name" type="text" menuItem="Bill To>" detail="true" />
			
		<field name="companyName" nativeName="DCUDBA" tableName="DCUSMAS"
			title="Company" type="text" menuItem="Bill To>" detail="true"/>
			
		<field name="billToEmail" nativeName="DCUEML" tableName="DCUSMAS" 
			title="Email" type="text" detail="true" menuItem="Bill To>" />
			
		<field name="daytimePhone" nativeName="DCUDPH" tableName="DCUSMAS" 
			title="Daytime Phone" type="text" detail="true" menuItem="Bill To>" />
			
		<field name="eveningPhone" nativeName="DCUHPH" tableName="DCUSMAS" 
			title="Evening Phone" type="text" detail="true"	menuItem="Bill To>" />
			
		<field name="billToAddress1" title="Bill to Address1" type="text"
			customSelectExpression="COALESCE(DAAAD1, DCUAD1)"
			menuItem="Bill To>" detail="true" />
			
		<field name="billToAddress2" title="Bill to Address2" type="text"
			customSelectExpression="COALESCE(DAAAD2, DCUAD2)"
			menuItem="Bill To>" detail="true" />
			
		<field name="billToCity" title="Bill to City" type="text" detail="true"
			customSelectExpression="COALESCE(DAACTY, DCUCTY)"
			menuItem="Bill To>" />
			
		<field name="billToState" title="Billto State" type="text"
			customSelectExpression="COALESCE(DCUSADD.DSTATE, DCUSMAS.DSTATE)"
			menuItem="Bill To>" detail="true" />
			
		<field name="billToPostCode" title="Bill to Postal Code" type="text"
			customSelectExpression="COALESCE(DCUSADD.DPCZIP, DCUSMAS.DPCZIP)"
			menuItem="Bill To>" detail="true" />
			
		<field name="billToCountry" title="Bill to Country" type="text" detail="true"
			customSelectExpression="CASE WHEN DCUSADD.FCNCUN IS NULL THEN (SELECT FCNNAM FROM FCNTRY FCNTRY WHERE DCUSMAS.FCNCUN=FCNTRY.FCNCUN) 
			ELSE  (SELECT FCNNAM FROM FCNTRY FCNTRY WHERE DCUSADD.FCNCUN=FCNTRY.FCNCUN) END"
			menuItem="Bill To>" />
			
		<field name="lifetimeValue" title="Lifetime Values" type="currency" detail="true"
			customSelectExpression="DCUSMAS.DCUPUR-DCUSMAS.DCULRT+DCUSMAS.DCURPU"
			menuItem="Bill To>" />
			
		<!-- SHIPTO -->
		<field name="shipToCustomerId" title="Ship To Cust#" type="text"
			menuItem="Ship To>" detail="true" 
			customSelectExpression="DORDLIN.DCUCUS"/>
			
		<!-- PRODUCT -->
		<field name="productCode" nativeName="DPRPRD" detail="true"
			title="Product Code" type="text" menuItem="Product>"/>
			
		<field name="productDescription" nativeName="DPRDES" tableName="DPRODUC" detail="true" 
			title="Product Description" type="text" width="100"	menuItem="Product>"/>
			
		<field name="customerFriendlyDescription" nativeName="DPRCFD" tableName="DPRODUC"
			title="Product Description for Customer" type="text" width="125" menuItem="Product>"
			customSelectExpression="CASE WHEN LENGTH(TRIM(DPRODUC.DPRCFD))=0 THEN DPRODUC.DPRDES ELSE DPRODUC.DPRCFD END"/>
			
		<field name="vendorStyle" nativeName="FSKSIT" tableName="FSKUMAS"
			title="Vendor Style" type="text" length="15" menuItem="Product>" />	
				
		<field name="sku" nativeName="FSKSKU" detail="true"
			title="SKU" type="integer" length="10" summaryFunction="null" menuItem="Product>" />	
					
		<field name="color" nativeName="FCOCLR"
			title="Color" type="text" menuItem="Product>" 
			optionDataSource="FCOLOR" valueField="FCOCLR" displayField="FCODES"
			foreignKey="FCOLOR.FCOCLR" />
			
		<field name="colorCode" nativeName="FCOCLR" detail="true"
			title="Color Code" type="text" length="4" menuItem="Product>"/>

		<field name="size" nativeName="FSZSIZ"
			title="Size" type="text" menuItem="Product>" 
			optionDataSource="FSIZE" valueField="FSZSIZ" displayField="FSZDES"
			foreignKey="FSIZE.FSZSIZ"/>
			
		<field name="sizeCode" nativeName="FSZSIZ" detail="true"
			title="Size Code" type="text" length="5" menuItem="Product>"/>	
	
		<!-- LINE -->
		
		<field name="lineNumber" nativeName="DOLNUM" detail="true"
			title="Line #" type="integer" summaryFunction="null" menuItem="Order Line>" />
			
		<field name="shipToNumber" nativeName="DBXNUM" detail="true"
			title="Ship To Number" type="integer" canFilter="false" hidden="true" menuItem="Order Line>" />
			
		<field name="shipFromLoc" nativeName="DOLWHS" detail="true"
			title="Ship From Loc" type="text" menuItem="Order Line>" />
			
		<field name="shipMethod" nativeName="DDMCOD" detail="true" 
			title="Delivery Method" type="text"	menuItem="Order Line>" />
	
		<field name="priority" nativeName="DOLPTY" title="Priority" type="integer"
			detail="true" summaryFunction="null" menuItem="Order Line>" />
	
		<field name="upsellType" nativeName="DOLUST" title="Upsell Type" type="text" hidden="true"
			menuItem="Order Line>" detail="true"/>
						
		<field name="prefix" nativeName="DOLPFX" 
			title="Catalog Prefix" type="text" detail="true" summaryFunction="null" menuItem="Order Line>" />
			
		<field name="altSkuPrefix" nativeName="DOLASP" 
			title="Alternate SKU Prefix" type="text" detail="true" menuItem="Order Line>" />
			
		<field name="altSku" nativeName="DOLASK" 
			title="Alternate SKU" type="integer" detail="true" summaryFunction="null" menuItem="Order Line>" />
			
		<field name="priceOverrideCode" nativeName="DOLOVR" 
			title="Price Override Code" type="text" detail="true" menuItem="Order Line>" />

		<field name="priceOverrideReason" nativeName="DOLOVR" detail="true"
			title="Price Override Reason" type="text" menuItem="Order Line>" 
			optionDataSource="DOVRRSN" valueField="DORCOD" displayField="DORDES"
			foreignKey="DOVRRSN.DORCOD" />
						
		<field name="returnStatus" nativeName="DOLRTN"
			title="Return Status" type="text" detail="true" menuItem="Order Line>">
			<valueMap>
				<value ID="1">Customer will return</value>
				<value ID="2">Customer will not return</value>
				<value ID="3">Customer has returned</value>
			</valueMap>
		</field>
		
		<field name="returnReasonCode" nativeName="DRRCOD"
			title="Return Reason Code" type="text" detail="true" menuItem="Order Line>" />

		<field name="returnReason" nativeName="DRRCOD" detail="true"
			title="Return Reason" type="text" menuItem="Order Line>" 
			optionDataSource="DRTNRSN" valueField="DRRCOD" displayField="returnReasonDescription"
			foreignKey="DOVRRSN.DORCOD" />
			
		<field name="shipGroup" nativeName="DOLSHG"
			title="Ship Group" type="text" detail="true" menuItem="Order Line>" />
			
		<field name="cancelReasonCode" nativeName="DCRCOD"
			title="Cancel Reason" type="text" detail="true" menuItem="Order Line>" />

		<field name="cancelReason" nativeName="DCRCOD"
			title="Cancel Reason" type="text" detail="true" menuItem="Order Line>" 
			optionDataSource="DRTNRSN" valueField="DCRCOD" 
			displayField="cancelReasonDescription" foreignKey="DOVRRSN.DORCOD" />			
			
		<field name="shipMethodOverrideBy" nativeName="DOLOVS" 
			title="Ship Method Override By"	type="text" detail="true" menuItem="Order Line>" />
			
		<field name="dropShip" nativeName="DOLDSH" 
			title="Drop Shipment" type="boolean" 
			labelAsTitle="true" sqlStorageStrategy="singleCharYN" 
			detail="true" menuItem="Order Line>" />
			
		<field name="nonMerchCode" nativeName="DOLMER" 
			title="Non-Merch Code" type="text" detail="true" menuItem="Order Line>" />
			
		<field name="nonMerchItem" nativeName="DOLCON"
			title="Non-Merch Item" type="text" detail="true" menuItem="Order Line>" />
			
		<field name="compositeItem" nativeName="DOLCMP" 
			title="Composite Item" type="boolean" 
			labelAsTitle="true" sqlStorageStrategy="singleCharYN" 
			detail="true" menuItem="Order Line>" />
			
		<field name="demandSource" nativeName="DOLSRC" 
			title="Demand Source" type="text" length="7" detail="true" menuItem="Order Line>" />
			
		<field name="demandCatalog" nativeName="DOLCAT"  
			title="Demand Catalog" type="text" detail="true" menuItem="Order Line>" />
			
		<!-- LINE UNITS -->
		
		<field name="unitsOrdered" nativeName="DOLUOR"
			title="Units Ordered" type="integer" menuItem="Order Line>Units>" />
			
		<field name="unitsReserved" nativeName="DOLURS"
			title="Units Reserved" type="integer" menuItem="Order Line>Units>" detail="true" />
			
		<field name="unitsAllocated" nativeName="DOLUAL"
			title="Units Allocated" type="integer" menuItem="Order Line>Units>" detail="true" />
			
		<field name="unitsShipped" nativeName="DOLUSH"
			title="Units Shipped" type="integer" menuItem="Order Line>Units>" detail="true" />
			
		<field name="unitsBackordered" nativeName="DOLUBO"
			title="Units Backordered" type="integer" menuItem="Order Line>Units>" detail="true" />
			
		<field name="unitsCanceled" nativeName="DOLUCN"
			title="Units Canceled" type="integer" menuItem="Order Line>Units>" detail="true" />
			
		<field name="unitsAvailable" nativeName="DOLQAV"
			title="Quantity Available" type="integer" menuItem="Order Line>Units>" detail="true" hidden="true" />
			
		<field name="compositeDetailUnits" nativeName="FCSQTY"
			title="Composite Detail Units" type="integer" detail="true" menuItem="Order Line>Units>" />
			
		<!-- ORDER CURRENCY -->
		
		<field name="unitPrice" nativeName="DOLUPR" title="Unit Price Cur" detail="true"
			type="currency" summaryFunction="null" menuItem="Order Line>Order Currency>"/>	
		<field name="totalPrice" customSelectExpression="DOLUPR*DOLUOR" title="Total Price Cur" detail="true"
			type="currency" summaryFunction="null" menuItem="Order Line>Order Currency>"/>	
		<field name="continuityDetailAmount" nativeName="DOLAMC" title="Continuity Detail Amount"
			type="currency" detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="discountApplied" nativeName="DOLDSA" title="Discount Applied Cur"
			type="currency" detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="invoicedDiscount" nativeName="DOLADS" title="Invoiced Discount Applied Cur"
			type="currency" detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="additionalShipping" nativeName="DOLASH" title="Additional Shipping Cur"
			type="currency" detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="allocatedShipping" nativeName="DOLVAS" title="Allocated Shipping Cur"
			type="currency" detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="totalInvoiced" nativeName="DOLAIN" title="Total Invoiced Cur" 
			type="currency"	detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="giftCharge" nativeName="DOLGIF" title="Gift Charge Cur"
			type="currency"	detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="giftChargeInvoiced" nativeName="DOLAGF" title="Gift Charge Invoiced Cur" 
			type="currency"	detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="taxRate" nativeName="DOLTXR" title="Tax Rate Cur" 
			type="float" detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="taxAmount" nativeName="DOLTAX" title="Tax Amount Cur" 
			type="currency" detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="taxAmountInvoiced" nativeName="DOLATX" title="Invoiced Tax Amount Cur" 
			type="currency"	detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="otherCharge" nativeName="DOLHAN" title="Other Charge Cur" 
			type="currency" detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="otherTax" nativeName="DOLHTX" title="Other Tax Cur" 
			type="currency" detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="shipChargeInvoiced" nativeName="DOLAHN" title="Invoiced Shipping Cur" 
			type="currency" detail="true" menuItem="Order Line>Order Currency>" />			
		<field name="compositeDetailAmount" nativeName="FCSPRC" title="Composite Detail Amount Cur"
			type="currency" detail="true" menuItem="Order Line>Order Currency>" />
			
		<!-- HOME CURRENCY -->
		
		<field name="unitPriceHome" nativeName="DOLUPR" title="Unit Price"
			type="currency" summaryFunction="null" menuItem="Order Line>Home Currency>"/>		
		<field name="totalPriceHome" customSelectExpression="DOLUPR*DOLUOR" title="Unit Price"
			type="currency" summaryFunction="null" menuItem="Order Line>Home Currency>"/>		
		<field name="continuityDetailAmountHome" nativeName="DOLAMC" title="Continuity Detail Amount"
			type="currency" detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="discountAppliedHome" nativeName="DOLDSA" title="Discount Applied"
			type="currency" detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="invoicedDiscountHome" nativeName="DOLADS" title="Invoiced Discount Applied"
			type="currency" detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="additionalShippingHome" nativeName="DOLASH" title="Additional Shipping"
			type="currency" detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="allocatedShippingHome" nativeName="DOLVAS" title="Allocated Shipping"
			type="currency" detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="totalInvoicedHome" nativeName="DOLAIN" title="Total Invoiced" 
			type="currency"	detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="giftChargeHome" nativeName="DOLGIF" title="Gift Charge"
			type="currency"	detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="giftChargeInvoicedHome" nativeName="DOLAGF" title="Invoiced Gift Charge" 
			type="currency"	detail="true" menuItem="Order Line>Home Currency>" />			

		<field name="taxAmountHome" nativeName="DOLTAX" title="Tax Amount" 
			type="currency" detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="taxAmountInvoicedHome" nativeName="DOLATX" title="Invoiced Tax Amount" 
			type="currency"	detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="otherChargeHome" nativeName="DOLHAN" title="Other Charge" 
			type="currency" detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="otherTaxHome" nativeName="DOLHTX" title="Other Tax" 
			type="currency" detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="shipChargeInvoicedHome" nativeName="DOLAHN" title="Invoiced Shipping" 
			type="currency" detail="true" menuItem="Order Line>Home Currency>" />			
		<field name="compositeDetailAmountHome" nativeName="FCSPRC" title="Composite Detail Amount"
			type="currency" detail="true" menuItem="Order Line>Home Currency>" />			
			
		<!-- LINE DATES -->
		
		<field name="requestedToShipOn" nativeName="DOLRSD" title="Requested Ship" type="date" sqlStorageStrategy="number" 
			detail="true" menuItem="Order Line>Dates>" />
		<field name="actualShipOn" nativeName="DOLASD" title="Actual Ship Date" type="date" sqlStorageStrategy="number" 
			detail="true" summaryFunction="null" menuItem="Order Line>Dates>" />
		<field name="originalESD" nativeName="DOLOBD" title="Original ESD" type="date" sqlStorageStrategy="number" detail="true"
			summaryFunction="null" menuItem="Order Line>Dates>" />
		<field name="currentESD" nativeName="DOLCBD" title="Current ESD" type="date" sqlStorageStrategy="number" detail="true"
			summaryFunction="null" menuItem="Order Line>Dates>" />
		<field name="revisedESD" nativeName="DOLLBD" title="Revised ESD" type="date" sqlStorageStrategy="number" detail="true"
			summaryFunction="null" menuItem="Order Line>Dates>" />
		<field name="pendingESD" nativeName="DOLPBD" title="Pending ESD" type="date" sqlStorageStrategy="number" detail="true"
			summaryFunction="null" menuItem="Order Line>Dates>" />
		<field name="lineLastChangedOn" nativeName="DOLLCD" title="Line Last Changed" type="date" sqlStorageStrategy="number" 
			detail="true" summaryFunction="null" menuItem="Order Line>Dates>" />
		<field name="demandDate" nativeName="DOLDMD" title="Demand Date" type="date" sqlStorageStrategy="number" detail="true"
			summaryFunction="null" menuItem="Order Line>Dates>" />
		<field name="receivedDate" nativeName="DOLRCD" title="Received on" type="date" sqlStorageStrategy="number" 
			detail="true" summaryFunction="null" menuItem="Order Line>Dates>" />
		<field name="requiredBy" nativeName="DOLRQD" title="Required by" type="date" sqlStorageStrategy="number" 
			detail="true" summaryFunction="null" menuItem="Order Line>Dates>" />
		<field name="lineCreatedOn" nativeName="DOLCRD" title="Line Created on" type="date" sqlStorageStrategy="number" 
			detail="true" summaryFunction="null" menuItem="Order Line>Dates>" />
		<field name="lineCreatedAt" nativeName="DOLCRT" title="Line Created at" type="time" 
			customSelectExpression="TIME(substr(digits(DOLCRT),1,2)||':'||substr(digits(DOLCRT),3,2)||':'||substr(digits(DOLCRT),5,2))" 
			detail="true" summaryFunction="null" menuItem="Order Line>Dates>" />
			
		<!-- LINE FLAGS -->
		
		<field name="includeInShipping" nativeName="DOLISH" title="Include in Shipping"
			type="boolean" labelAsTitle="true" sqlStorageStrategy="singleCharYN" 
			detail="true" menuItem="Order Line>Options>" />
			
		<field name="giftItem" nativeName="DOLGFT" title="Gift Item" 
			type="boolean" labelAsTitle="true" sqlStorageStrategy="singleCharYN" 
			detail="true" menuItem="Order Line>Options>" />
			
		<field name="refundTax" nativeName="DOLRTX" title="Refund Tax" 
			type="boolean" labelAsTitle="true" sqlStorageStrategy="singleCharYN" 
			detail="true" menuItem="Order Line>Options>" />
			
		<field name="finalized" nativeName="DOLFIN" title="Finalized" 
			type="boolean" labelAsTitle="true" sqlStorageStrategy="singleCharYN" 
			detail="true" menuItem="Order Line>Options>" />
			
		<field name="replacement" nativeName="DOLRPL" title="Replacement" 
			type="boolean" labelAsTitle="true" sqlStorageStrategy="singleCharYN" 
			detail="true" menuItem="Order Line>Options>" />
			
		<field name="backorderAccepted" nativeName="DOLFTC" title="Backorder Accepted" 
			type="boolean" labelAsTitle="true" sqlStorageStrategy="singleCharYN" 
			detail="true" menuItem="Order Line>Options>" />
			
		<field name="firstBONoticeSent" nativeName="DOLFTW" title="1st BO Notice Sent" 
			type="boolean" labelAsTitle="true" sqlStorageStrategy="singleCharYN" 
			detail="true" menuItem="Order Line>Options>" />
			
		<field name="specialOffer" nativeName="DOLSPO" title="Special Offer"		
			type="boolean" labelAsTitle="true" sqlStorageStrategy="singleCharYN" 
			detail="true" menuItem="Order Line>Options>" hidden="true"/>
			
		<field name="masterSkuExploded" nativeName="DOLXPL" title="Master SKU Exploded"
			type="boolean" labelAsTitle="true" sqlStorageStrategy="singleCharYN" 
			detail="true" menuItem="Order Line>Options>" hidden="true"/>
	</fields>
	<operationBindings>
		<operationBinding operationType="fetch">
			<tableClause>
			dordlin dordlin
			left join dordhdr dordhdr on dordlin.dconum = dordhdr.dconum
			left join fskumas fskumas on dordlin.fsksku = fskumas.fsksku
			left join dproduc dproduc on dordlin.dprprd = dproduc.dprprd
			left join fcolor fcolor on dordlin.fcoclr = fcolor.fcoclr
			left join fsize fsize on dordlin.fszsiz = fsize.fszsiz
			left join ddelmth ddelmth on dordlin.ddmcod = ddelmth.ddmcod 
			left join dcusmas dcusmas on dordhdr.dcucus = dcusmas.dcucus
			left join dcusadd dcusadd on dordhdr.dcucus = dcusadd.dcucus and dordhdr.daanum=dcusadd.daanum		
		</tableClause>
		</operationBinding>
	</operationBindings>
</DataSource>

<DataSource ID="DORDTYP" dataFormat="iscServer"
	webServiceOperations="fetch"
	serverType="sql" dbName="as400" sparseUpdates="true" tableName="DORDTYP"
	serverConstructor="com.islandpacific.gui.server.customDataSource.IpDataSource">
	<!-- IP Direct order type file. -->
	<fields>
 <field name="DOTTYP" title="Order Type" type="text" length="2" primaryKey="true"/>
 <field name="DOTDES" title="Order Type Description" type="text" length="30"/>
 <field name="DOTCNF" title="Default To Send Confirmation Card?" type="text" length="1"/>
 <field name="DOTRLS" title="When Should Orders Be Released?" type="text" length="1"/>
 <field name="DOTACN" title="Automatically Cancel If Not Available?" type="text" length="1"/>
 <field name="DOTAHC" title="Category For Held Auto-cancelled Orders" type="text" length="3"/>
 <field name="DOTACA" title="Allow Cash" type="text" length="1"/>
 <field name="DOTACC" title="Allow Credit Card" type="text" length="1"/>
 <field name="DOTAGF" title="Allow Gift Certificate" type="text" length="1"/>
 <field name="DOTAIB" title="Allow Internal Billing" type="text" length="1"/>
 <field name="DOTEMC" title="Send Order Confirm Email Message?" type="text" length="1"/>
 <field name="DOTEMS" title="Send Shipment Confirm Email Message?" type="text" length="1"/>
 <field name="DOTDHO" title="Delete Held Orders After How Many Days?" type="integer" length="3"/>
 <field name="DOTINT" title="Internet Orders?" type="text" length="1"/>
 <field name="@@UPID" title="Field Update / Access Identifier" type="integer" length="7"/>
	</fields>
</DataSource>

<DataSource ID="DCATLOG" dataFormat="iscServer" serverType="sql"
	dbName="as400" sparseUpdates="true" tableName="DCATLOG"
	serverConstructor="com.islandpacific.gui.server.customDataSource.IpDataSource"
	qualifyColumnNames="false">
	<!-- IP Direct catalog file. -->
	<fields>
		<field name="catalogId" nativeName="DCACAT" title="Catalog Id"
			type="text" length="6" primaryKey="true" />
		<field name="catalogChannelCode" nativeName="DCDDIV"
			title="Catalog Channel Code" type="text" length="3" detail="true" />
		<field name="catalogPrefixCode" nativeName="DCXCOD" title="Catalog Prefix Code"
			type="text" length="2" detail="true" />
		<field name="allocatedDemandSourceCode" nativeName="DCAPSC"
			title="Allocated Demand Source Code" type="text" length="7" detail="true" />
		<field name="seasonCode" nativeName="FSESEA" title="Season Code"
			type="text" length="3" detail="true" />
		<field name="lastYearCatalogIdForComparison" nativeName="DCALCT"
			title="Last Year Catalog Id For Comparison" type="text" length="6"
			detail="true" />
		<field name="catalogType" nativeName="DCYTYP" title="Catalog Type"
			type="text" length="3" detail="true" />
		<field name="catalogDescription" nativeName="DCADES" title="Description"
			type="text" length="30" />
		<field name="inHomeCatalogDate" nativeName="DCAMDT"
			title="In-home Catalog Date" type="date" sqlStorageStrategy="number"
			sqlDateFormat="yyyyMMdd" detail="true" />
		<field name="totalCatalogCirculation" nativeName="DCACIR"
			title="Total Catalog Circulation" type="integer" length="9" detail="true" />
		<field name="numberOfPagesInCatalog" nativeName="DCAPAG"
			title="Number Of Pages In Catalog" type="integer" length="5" detail="true" />
		<field name="totalSquareInches" nativeName="DCASQI" title="Total Square Inches"
			type="currency" detail="true" />
		<field name="costPerSquareInch" nativeName="DCACSI"
			title="Cost Per Square Inch" type="currency" detail="true" />
		<field name="includeInForecastsYN" nativeName="DCAFCS"
			title="Include In Forecasts" type="boolean" labelAsTitle="true"
			sqlStorageStrategy="singleCharYN" detail="true" />
		<field name="totalUnitsForecastForProducts" nativeName="DCAPPU"
			title="Total Units Forecast For Products" type="integer" length="7"
			detail="true" />
		<field name="totalProductSalesForecast" nativeName="DCAPPS"
			title="Total Product Sales Forecast" type="integer" length="9"
			detail="true" />
		<field name="totalOrdersInCurrentPlan" nativeName="DCACPO"
			title="Total Orders In Current Plan" type="integer" length="7"
			detail="true" />
		<field name="currentSalesPlan" nativeName="DCACPA" title="Current Sales Plan"
			type="integer" length="9" detail="true" />
		<field name="totalOriginalPlanOrders" nativeName="DCAOPO"
			title="Total Original Plan Orders" type="integer" length="7" detail="true" />
		<field name="totalOriginalPlannedSales" nativeName="DCAOPA"
			title="Total Original Planned Sales" type="integer" length="7"
			detail="true" />
		<field name="totalActualOrdersForCatalog" nativeName="DCAACO"
			title="Total Actual Orders For Catalog" type="integer" length="7"
			detail="true" />
		<field name="totalActualSalesForCatalog" nativeName="DCAACA"
			title="Total Actual Sales For Catalog" type="currency" detail="true" />
		<field name="ordersOfAtLeast" nativeName="DCAFGA" title="Orders Of At Least"
			type="currency" detail="true" />
		<field name="specialOfferItem" nativeName="DCAFSK" title="Special Offer Item"
			type="integer" length="10" detail="true" />
		<field name="lostOrders" nativeName="DCALOR" title="Lost Orders"
			type="integer" length="7" detail="true" />
		<field name="lostSales" nativeName="DCALSL" title="Lost Sales"
			type="currency" detail="true" />
		<field name="bouncebackSourceCode" nativeName="DCABBS"
			title="Bounceback Source Code" type="text" length="7" detail="true" />
		<field name="catalogDiscountPercent" nativeName="DCADPC"
			title="Catalog Discount Percent" type="integer" length="3" detail="true" />
		<field name="catalogDiscountAmount" nativeName="DCADAM"
			title="Catalog Discount Amount" type="currency" detail="true" />
		<field name="catalogDiscountFromDate" nativeName="DCADFD"
			title="Catalog Discount From Date" type="date" sqlStorageStrategy="number"
			sqlDateFormat="yyyyMMdd" detail="true" />
		<field name="catalogDiscountThruDate" nativeName="DCADTD"
			title="Catalog Discount Thru Date" type="date" sqlStorageStrategy="number"
			sqlDateFormat="yyyyMMdd" detail="true" />
		<field name="specialOfferItemFromDate" nativeName="DCASFD"
			title="Special Offer Item From Date" type="date" sqlStorageStrategy="number"
			sqlDateFormat="yyyyMMdd" detail="true" />
		<field name="specialOfferItemThruDate" nativeName="DCASTD"
			title="Special Offer Item Thru Date" type="date" sqlStorageStrategy="number"
			sqlDateFormat="yyyyMMdd" detail="true" />
		<field name="freeGiftWrappingYN" nativeName="DCAFGW" title="Free Gift Wrapping"
			type="boolean" labelAsTitle="true" sqlStorageStrategy="singleCharYN"
			detail="true" />
		<field name="freeGiftWrappingFromDate" nativeName="DCAFFD"
			title="Free Gift Wrapping From Date" type="date" sqlStorageStrategy="number"
			sqlDateFormat="yyyyMMdd" detail="true" />
		<field name="freeGiftWrappingThruDate" nativeName="DCAFTD"
			title="Free Gift Wrapping Thru Date" type="date" sqlStorageStrategy="number"
			sqlDateFormat="yyyyMMdd" detail="true" />
		<field name="fieldUpdateAccessIdentifier" nativeName="@@UPID"
			title="Field Update / Access Identifier" type="integer" length="7"
			detail="true" hidden="true" />
	</fields>
</DataSource>

[Isomorphic]

We've looked these over, and there's not an obvious problem with the definitions. As you say the feature has worked elsewhere dozens of times - this really suggests a data problem. It could be something hard to spot, like extra trailing spaces, mismatched capitalization, that kind of thing. You may want to troubleshoot by providing the optionDataSource as a clientOnly DataSource just to remove any such possibilities.