order selection in report by distance

Justin Wolff

03 Januari 2019 20:08

I've created a workflow to select features based on the user's current location or a map-specified point.  The workflow adds a distance field, which is used to order the results in ascending order in the map.  I need to allow users to print a map that contains a report of the selected features (fuel stations).  My current report orders the selected features by OID, where I need them ordered by their distance (from the user's location/selection point).  Is this possible?  Further, I'd like to include that distance value in the report as well.  I need labels in the map ('1' for the closest, '2' for the next closest, etc.) that correspond to the report records as well.

 

I'm still working on getting my workflows uploaded....

 

Thanks

 

Justin

 

_img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=906f2000000XcGd&feoid=Body&refid=0EMf2000000YEqS" _/_img_

 

_img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=906f2000000XcGd&feoid=Body&refid=0EMf2000000YEqX" _/_img_

 

_img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=906f2000000XcGd&feoid=Body&refid=0EMf2000000YEqc" _/_img_

0

• 

  Permanently deleted user

  08 Mars 2019 00:59

  Hi Justin,

   

  To do this you have many options.  If you're already using out-of-the-box reporting, I recomend investigating the Dataset Transformer workflow, which could perform runtime analysis of your data and should be able to calculate and sort your data.  The difficult part about Dataset Transformers is that there isn't much opportunity to test or troubleshoot them - if an error is encountered during trasnformation, Essentials will revert the dataset to its original form.

   

  Otherwise, if you're already using a workflow to generate your data, you should be able to add columns to your data with whatever values you like, and also sort the data to present it in your report.  If you aren't able to do this yourself I recommend opening a support case with us (or your local provider) for some assistance.

   

  Regards,

   

  -Malcolm

  0

Du måste logga in om du vill lämna en kommentar.