List of Contributions

Steve Bish

Pitney Bowes Software Inc.

Contact Details

Pitney Bowes Software Inc.
United Kingdom

My Content

1 to 20 of 36 total
Posted By Steve Bish Nov 26, 2020 10:39 AM
Found In Egroup: Confirm
\ view thread
Hi Rob, You may also wish to remove the following: document_link.document_notes LIKE 'Photo added by_%' To capture every document link attached to the Inspection Feature. For example, the Inspector may have chosen to override the Document Notes in ConfirmConnect, or you have permutations of 'Photo added ...
Posted By Steve Bish Nov 13, 2020 7:09 AM
Found In Egroup: Confirm
\ view thread
Hi Richard, You'd need only add the column to the GROUP BY list. For example: SELECT    job.job_number,    job.job_entry_date,    SUM( job_item.job_item_quantity * contract_boq.contract_rate) Estimated_Value ... ... GROUP BY    job.job_number,    job.job_entry_date Hope this helps. Kind regards, Steve ...
Posted By Steve Bish Oct 16, 2020 8:53 AM
Found In Egroup: Confirm
\ view thread
@Afzal Hussain Certainly, I've responded to your thread. @Richard White I forgot to mention (I think we possibly discussed this on a recent Tech Support case), be mindful joining the sw_notice_header and sw_notice_site tables using the work_version_no. These don't always correlate, because we don't always ...
Posted By Steve Bish Oct 16, 2020 8:47 AM
Found In Egroup: Confirm
\ view thread
Hi Afzal, I would consider using the Order Items rather than the Job Items. This mitigates the need to involve the Contract BOQ table to ascertain the correct rate for the Contract and Price Factor combination. I would also link the Job and Job Status Log tables on the Job Log Number column, which will ...
Posted By Steve Bish Oct 1, 2020 12:05 PM
Found In Egroup: Confirm
\ view thread
Hi Richard, You'll want the sw_notice_site.site_issue_time having joined to this table using the work_header_no and work_version_no. Kind regards, Steve ------------------------------ Steve Bish Senior Software Support Analyst Confirm ------------------------------
Posted By Steve Bish Oct 1, 2020 11:47 AM
Found In Egroup: Confirm
\ view thread
Hi all, You may find the following Knowledge Article beneficial - How to embed Document Link images in a Report Template in Confirm   Its shows some example SQL in how to decipher the Document File path, and it also covers your question Steven about embedding images into reports (which can subsequently ...
Posted By Steve Bish Sep 29, 2020 6:20 AM
Found In Egroup: Confirm
\ view thread
Hi Richard, Hope you're well. You could try adding the following line to the WHERE clause: sw_notice_header.permit_status IS NULL Which should return those records with a blank permit status. Hope this helps! Cheers, Steve ------------------------------ Steve Bish Senior Software Support Analyst Confirm ...
Posted By Steve Bish Sep 16, 2020 11:24 AM
Found In Library: Confirm
Posted By Steve Bish Sep 16, 2020 11:24 AM
Found In Egroup: Confirm
\ view thread
Hi Lesley, If it helps, you can embed the images into the Email body itself. I've attached a working example of this in case you wanted to test this out in your Development environment. email_example is how the email is received by the recipient enquiry_alert_configuration is an example of using ...
Posted By Steve Bish Sep 9, 2020 10:05 AM
Found In Egroup: Confirm
\ view thread
Hi Chris, Try this: SELECT    NVL(attribute_value.attrib_value_name, 'No Tree Height Attribute set against Feature') tree_height,    COUNT(job.job_number) no_of_jobs FROM    job    JOIN feature ON       job.site_code = feature.site_code AND       job.plot_number = feature.plot_number    left JOIN (       ...
Posted By Steve Bish Aug 20, 2020 6:56 AM
Found In Egroup: Confirm
\ view thread
Hi Louis, Try the following example: SELECT feature.site_code, feature.plot_number, feature.feature_id, feature.feature_type_code FROM feature WHERE feature.feature_deadflag = 'N' AND NOT EXISTS ( SELECT * FROM feature_document WHERE feature_document.site_code = feature.site_code AND ...
Posted By Steve Bish Aug 18, 2020 4:28 AM
Found In Egroup: Confirm
\ view thread
To build on Chris' answer above. On the Linked Tables tab of the Data Source screen; if you add in the Feature Table, this will give you the ability to drill-down to this report using the List button on the Feature Screen. The Data Source will also be pre-qualified to the Feature you are initiating it ...
Posted By Steve Bish Aug 12, 2020 10:44 AM
Found In Egroup: Confirm
\ view thread
Hi Jamie, Not at the moment, although this is a great idea to place on the Ideas Portal. You almost want the option to SHIFT + Click and have every task in between be selected. Then you could use your CTRL + Click to deselect the tasks you didn't want, which would be easier that CTRL + Clicking 400 of ...
Posted By Steve Bish Aug 10, 2020 6:11 AM
Found In Egroup: Confirm
\ view thread
Hi Rebecca, Try this example: SELECT central_enquiry.enquiry_number, central_enquiry.enquiry_desc, central_enquiry.enquiry_time, central_enquiry.commit_log_number, enquiry_commitment.commit_log_time, enquiry_commitment.commit_target_time, enquiry_commitment.commit_actual_time, (CASE WHEN ...
Posted By Steve Bish Aug 4, 2020 11:49 AM
Found In Egroup: Confirm
\ view thread
Hi Ana, If you take a look at the Help Topic 'Feature Map Layer Import', this will guide you through how this import utility works. Essentially you need the mapping file to contain a column named central_asset_id. This column is then used to make a match on the Feature's Central Asset ID in Confirm and ...
Posted By Steve Bish Aug 4, 2020 9:44 AM
Found In Egroup: Confirm
\ view thread
Hi Ana, Try removing and re-typing that last line, I'm not sure if it's not translating well when you copy and paste from the forum post perhaps. With regard to digitising these, you'd need to select the globe icon on the Feature screen. This will then open the Map window with the 'Unmapped Features' ...
Posted By Steve Bish Aug 4, 2020 7:10 AM
Found In Egroup: Confirm
\ view thread
Hi Ana, No problem, there isn't a way to mass digitise the Features in Confirm, these would need to be done individually. You do have the option of using 'Feature Map Layer Import' if you have an existing map file containing the digitisations; you'd need only make a match on Central_Asset_Id and Confirm ...
Posted By Steve Bish Aug 4, 2020 6:00 AM
Found In Egroup: Confirm
\ view thread
Hi Ana, Having had a quick look at your Map Layer 'WSF: Highways', I can see that Date Filtering hasn't been applied on the Map Workspace Manager for this layer. If you apply this, you should start to see the Dead/End Date Features drop off the map. Also, the new 'WSF' Feature on Site Code 9410228 doesn't ...
Posted By Steve Bish Aug 4, 2020 5:14 AM
Found In Egroup: Confirm
\ view thread
Hi Ana, If you've made spatial updates directly within the Confirm Database Map Layer (Blue C), then these changes should be instantaneous in the map. The only anomaly is when you end date a feature and have 'Date Filtering' switched on for that layer within the Map Workspace Manager. If you made a Feature ...
Posted By Steve Bish Jul 24, 2020 11:09 AM
Found In Egroup: Confirm
\ view thread
Hi Laura, That's the one. The screenshot you're showing with the Transmission Type , File Format , Export Directory and so on - that Scheduled Report is using the 'Scheduled Report Export Transformation' to take the results from the Data Source 'IF: Post Completion Inspection Auto', and transform them ...