AnsweredAssumed Answered

Sorting in a Virtual List

Question asked by connections on Jan 5, 2015
Latest reply on Jan 7, 2015 by jbante

I have created a report based on a virtual list (thank you to those who have posted articles on the technique!) but I am getting a strange sort order on one column. It happens in table view and in the report. Attached is the table view showing Column11 sorted in ascending order but not sorted correctly. What could cause this?

 

ExecuteSQL (

"Select

   EST.EstimateID, EST.Estimate, EST.EstimateName,

   ED.Room, ED.RoomDescript, ED.SystemID, ED.System, ED.RoomDim_eval as Area,

   SYS.SystemName,

   SD.SystemID, SD.MaterialCode, SD.MaterialCoverage, SD.MaterialPrice, SD.MaterialProduction, SD.MaterialJobClass,

   M.MaterialName,

   UD.JobClass, UD.PayRate, UD.Benefits,

 

   ED.RoomDim_eval / SD.MaterialCoverage as Quantity,

   Quantity * SD.MaterialPrice as Cost,

   Quantity / SD.MaterialProduction as Hours,

   Hours * (UD.Payrate + UD.Benefits) as Labor

  

From EstimateDetail ED

Join SystemDetail SD on ED.SystemID = SD.SystemID

Join System SYS on ED.SystemID = SYS.SystemID

Join Material M on SD.MaterialCode = M.MaterialCode

Join Estimate EST on EST.EstimateID = ED.EstimateID

Join UnionDetail UD on EST.UnionID = UD.UnionID and SD.MaterialJobClass = UD.JobClass

 

Where ED.EstimateID = ?

";

"~" ; "" ;

$EstimateID )

 

Thank you,

Brian

FMP A 12.0v5 on Mac

Attachments

Outcomes