I have a BAQ in which I am trying to retrieve a text value from the Configurator inputs view. Its truncating the value to the first 50 character, and I don’t know why. I have it set to far more than 50 is the display fields. Could it be the pivot or the fact that the data is coming from a view?
@Olga do you know if this is a limitation of the PcInputValue view ?
/*
* Disclaimer!!!
* This is not a real query being executed, but a simplified version for general vision.
* Executing it with any other tool may produce a different result.
*/
select
[JobHead].[ReqDueDate] as [JobHead_ReqDueDate],
[JobHead].[JobNum] as [JobHead_JobNum],
[Customer].[Name] as [Customer_Name],
[JobHead].[PartDescription] as [JobHead_PartDescription],
[JobHead].[ProdQty] as [JobHead_ProdQty],
[JobMtl].[PartNum] as [JobMtl_PartNum],
[JobMtl].[Description] as [JobMtl_Description],
[ConfigData].[ISBLength] as [ConfigData_ISBLength],
[ConfigData].[LapSelection] as [ConfigData_LapSelection],
[ConfigData].[StripDisplay] as [ConfigData_StripDisplay],
(LEN(ConfigData.StripDisplay)) as [Calculated_length]
from Erp.JobHead as JobHead
inner join Erp.JobProd as JobProd on
JobHead.Company = JobProd.Company
and JobHead.JobNum = JobProd.JobNum
inner join Erp.OrderDtl as OrderDtl on
JobProd.Company = OrderDtl.Company
and JobProd.OrderNum = OrderDtl.OrderNum
and JobProd.OrderLine = OrderDtl.OrderLine
and ( OrderDtl.OpenLine = 1 )
left outer join (select
[PcInputValue].[InputName] as [PcInputValue_InputName],
[PcInputValue].[InputValue] as [PcInputValue_InputValue],
[PcInputValue].[RelatedToSysRowID] as [PcInputValue_RelatedToSysRowID]
from Erp.PcInputValue as PcInputValue) ConfigData_src
pivot
(max(PcInputValue_InputValue)
for PcInputValue_InputName in ('ISBLength', 'LapSelection', 'StripDisplay') )
as ConfigData on
OrderDtl.SysRowID = ConfigData.PcInputValue_RelatedToSysRowID
inner join Erp.Customer as Customer on
OrderDtl.Company = Customer.Company
and OrderDtl.CustNum = Customer.CustNum
left outer join Erp.QuoteDtl as QuoteDtl on
OrderDtl.Company = QuoteDtl.Company
and OrderDtl.QuoteNum = QuoteDtl.QuoteNum
and OrderDtl.QuoteLine = QuoteDtl.QuoteLine
left outer join Erp.JobMtl as JobMtl on
JobHead.Company = JobMtl.Company
and JobHead.JobNum = JobMtl.JobNum
and ( JobMtl.Description like '%lap%' )
where (JobHead.ProdCode = 'Piano' and JobHead.QtyCompleted < JobHead.ProdQty)
