Differences

This shows you the differences between two versions of the page.

--- pcdistsetup [2020/10/05 18:06] – [Column in Vacancy Search Results] Justin Willey
+++ pcdistsetup [2020/10/05 20:36] (current) – [Columns in Vacancy & Person Search Results] Justin Willey
@@ Line 9: / Line 9: @@
 ==== Columns in Vacancy & Person Search Results ====
-In the VACANCY SEARCHRESULT view, add a custom column of Data Type 'Number' with Descriptor <code>round(DistanceBetweenPostCodes(Person.PostCode,:Q_SitePostCodeForMap,'Mi'),1)</code>
+In Maintenance | Database Setup | Custom Grid Columns choose Department: DEFAULT, Form: VACANCY, View: SEARCHRESULT
+and then <key>Add</key> the details shown:
+{{ :vacancysearchdistance.jpg?1200 |}}
+the Descriptor should read: <code>round(DistanceBetweenPostCodes(Person.PostCode,:Q_SitePostCodeForMap,'Mi'),1)</code>
+Then click <key>Update</key> To add a distance column to the Person Vacancy Search Results table, choose Department: DEFAULT, Form: PERSON, View: SEARCHRESULT and then click <key>Add</key> again. Then complete the details below:
+{{ :personsearchdistance.jpg?1200 |}}
+This time the Descriptor should be: <code>round(DistanceBetweenPostCodes(:Q_PostCode,isnull(vacancy.postcode, company.postcode) ,'Mi'),1)</code>
 ==== Column in Shift Matcher ====