All public logs

Combined display of all available logs of SMTX Wiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 11:31, 17 January 2025 Smtxwiki talk contribs created page Transpose datastore columns into rows with linebreaks (Created page with "In case you have a multi select form field and you want to show the selected values in a readonly display field and you want to combine multiple columns of the datastore behind the multi-select field, you should use the Transpose function. For example: you have a list with persons and want to show from the selected person their email address and organisation: TRANSPOSE('||', ' - ', '<br />', '#REPLACE-FORMFIELD-FormName||PersonList||EmailAddress#', '#REPLACE-FORMFIELD...")
• 11:24, 17 January 2025 Smtxwiki talk contribs moved page Transpose to Transpose in database queries
• 07:47, 17 September 2024 Smtxwiki talk contribs created page Avoid the white screen (Created page with "When the app isused to show a form, you sometimes get a whitescreen after submitting the form (as a user). THerefor, update the COntent of the page 'redirect-after-submit) to: <script language="javascript" type="text/javascript"> if (window.top.location.search && window.top.location.search.length > 0) { window.top.location.search = "?" + window.top.location.search.substring(1).split('&').filter(function (currentsearch) { return currentsearch.indexOf("tab=") <...")
• 07:46, 17 September 2024 Smtxwiki talk contribs created page SSP Studio Tips (Created page with "Avoid the white screen")
• 10:07, 9 September 2024 Smtxwiki talk contribs created page Make Grid look better with multiple lines (Created page with "In case a grid contains multiple lines in 1 cell, you see the color of the background image, even if you configured a different color. The CSS classes below should be included in your customer.css .RadGrid_Office2010Silver .rgSelectedRow { background: #165f9e78 !important; } .RadGrid_Office2010Silver .rgHoveredRowRow { background: #BBB !important; } .RadGrid_Office2010Silver .rgSelectedRow>td { background-image: none !important; }")
• 12:45, 6 August 2024 Smtxwiki talk contribs created page Import persons into custom actor (Created page with "The script below was written to import people from a CSV file as actor in a service, for which only the id was available. The actor field was a custom multi person field. var file=#1#; //The CSV file comes here. Structure: header on top, per line: serviceid, servicename, actoremail var fileLines=file.split('\r\n'); var log=[]; var allServices = JSON.parse(ServiceCatalogInterface.getAllServicesSummary()); for (var i=1; i< fileLines.length; i++) { var newActor=fil...")
• 12:36, 15 April 2024 Smtxwiki talk contribs created page Get form field values in javascript execution block (Created page with "Example function to retrieve a value from a simple field in a request form var getFormField (formvalues, fieldname) { formvalues.filter(function(fld) { return fld.internallabel === fieldname }).map(function(fld) { return fld.value; }).join(""); } var fieldValue = getFormField(g_forminstance.values, 'fieldname');")
• 09:33, 29 March 2024 Smtxwiki talk contribs created page Update Yes/No field for all documents in a service (Created page with "Updaten van een yes / no veld bij een document, hiervoor kun je de webservice “Services: update document template part numeric value” gebruiken, yes = 1 en no = 0. Ik heb die webservice toegevoegd aan jullie test omgeving. Je kunt dit script gebruiken om alle documenten van een onderzoek die DOC_delete op yes hebben staan aan te passen naar no: var serviceguid = "12345"; var externalprovidername = "the name"; var externalproviderkey = "the key"; var servicedetail...")
• 14:06, 20 February 2024 Smtxwiki talk contribs created page Retrieve Group membership (Created page with "If you want to know in a form, to which groups a user belongs,use this Query in a webservice: SELECT [Name] FROM [PersonGroup] WHERE [Id] IN (SELECT [PersonGroupId] FROM [PersonGroupPerson] WHERE [PersonId] IN (SELECT [Id] FROM [Person] WHERE [Email] = #EMAIL#)) AND [Name] IN ( '03. Anesthesiology (PD)', '04. Biobank (PD)', '05. Cardiologie (PD - OD)', '06. DPO (PD)', '07. Gastro-enterology (PD)', '08. Information management (PD)', '09. Laboratory (PD)', '10. Legal depa...")
• 11:25, 12 February 2024 Smtxwiki talk contribs created page Fetch date last uploaded document in a specific folder (Created page with "If you need to know the date the last documetn was uploaded in a folder: the example below return this form the selected Category (this is a document part 'Doc_Category') of the value : 'J1. Annual progress report' var serviceGuid = #REPLACE-VARIABLE-1550-ServiceGUID#; var serviceDetails = JSON.parse(ServiceCatalogInterface.getServiceDetail(serviceGuid, { LoadRelations: false, LoadParts: false, PartsUseValue: true })); var annualreportdates = serviceDetails.documents.f...")
• 09:15, 8 February 2024 Smtxwiki talk contribs created page Send uploaded files via attachment (Created page with "see test form in DEV : https://dev.ssp7.smt-x.com/Forms/Admin/formDetail.aspx?tab=1&id=739&ActiveFieldId=15011 it contains 2 file upload fields: 1. single file : Upload1FileForm 2. Multiple files: Upload2FilesForm This links into this process: https://dev.ssp7.smt-x.com/Workflow/Admin/ProcessAddEdit.aspx?saved=true&genericid=433 that contains 2 action steps: 1. upload 1 file 2. upload multiple files")
• 08:54, 26 January 2024 Smtxwiki talk contribs created page ACL - make a tab temporarily editable after publication (Created page with "WIth ACLs, you can set read/write access on tabs. But, after a publication flow has started, all fields are locked, and the ACLS do no longer apply. Our Best practice: - set all fields to 'editable when locked' - there is a query for this purpose: https://dev.ssp7.smt-x.com/common/Admin/WsCallAddEdit.aspx?genericid=400 name: SYS - Make all template parts editable when locked for template guid Next, create ACLs that hand out read/write rights, when the ervice is l...")
• 10:24, 19 January 2024 Smtxwiki talk contribs created page Basic Authentication in header (Created page with "Below is an example how to use basic authentication in the SMTX WebServices var username = "john"; var password = "pass123"; var basicauthvalue = CommonInterface.convertToBase64(username + ':' + password); return { updateheaders: { Authorization: "Basic " + basicauthvalue } };")
• 17:26, 9 May 2023 Smtxwiki talk contribs created page Mass close stuck tickets (Created page with "When you have a large amount of stuck tickets, you can use the following javascript script to close multiple at once. Use the serviceIds array to set all tickets ids const serviceIds = [1234, 1235, 1236]; var errorLog = []; for (var i=0; i<serviceIds.length; i++) { try { CommonInterface.callWebservice('Workflow - Stop Process Instance', { ProcessInstanceId : serviceIds[i], Log : 'Some comment line to explain why you closed the ticket'...")
• 12:06, 31 January 2023 Smtxwiki talk contribs created page Use variable from main process in subprocess (Created page with "Insert a step of the type 'Execute Javascript' Run this script: Note: enter the name of the variable of the main proces where is says: VARIABLENAMEHERE var url = #REPLACE-STEP-LINKONLY#; var processInstanceId = +url.split('processInstanceId=')[1].substr(0,6); return WorkflowInterface.getVariableValue(processInstanceId, 'VARIABLENAMEHERE');")
• 15:30, 21 December 2022 Smtxwiki talk contribs created page Customer Journey Configuration (Created page with "Below are some examples for referring to fields in the customer journey")
• 16:16, 13 December 2022 Smtxwiki talk contribs created page Query unused forms datastores processes (Created page with "Show forms with 0 tickets in teh last 24 months (see fixed date in query !!) SELECT * FROM [Form] WHERE [Id] NOT IN ( SELECT [FormField].[Form_Id] FROM [FormInstanceValue], [FormField], [FormInstance] WHERE [FormInstanceValue].[Field_Id] = [FormField].[Id] AND [FormInstanceValue].[FormInstance_Id] = FormInstance.Id AND [FormInstance].[LastUpdate] > '2020-12-12' ) Query to show processes without tickets in the last 24 months (see fixed date in query !!) SE...")
• 12:39, 4 November 2022 Smtxwiki talk contribs created page Calculate the total size in Kb of all uploaded files (Created page with "Field 1 : multi upload file (internal label: 'file') Field 2 : Hidden field (internal label: 'roSize') Field 3: Read only display field (internal label: 'roTotalSize')")
• 10:17, 24 August 2022 Smtxwiki talk contribs created page Find form based on internal label (Created page with "If you want to know the ID of a form, and you only know the internal label, use this query: SELECT [Id] FROM [Form] WHERE [InternalLabel] = 'FormLabel';")
• 09:05, 4 August 2022 Smtxwiki talk contribs created page See where a form isused as a subform (Created page with "If you want to know if a form is used as a subform, do this :")
• 07:28, 8 June 2022 Smtxwiki talk contribs created page PDFtoServiceCatalog (Created page with "So, you made a PDF in the process, but now it needs to go to the ServiceCatalog. JJust using the created link will not get it over there :( what you need to do : 1. Create folder on the server : “D:\Temp” 2. Added variable that stores the location of the file 3. added a step of the type 'save file', before the step where you add the document to the SC 4. in the step 'add report to SC', use the variable from step 2 as documentpath 5. Finally, a step to remove the l...")
• 13:59, 19 May 2022 Smtxwiki talk contribs created page Query approver votes of approval steps (Created page with "The query below retrieves all approvers and their votes for a provided ticket id select pi.[Id], pi.[UniqueReference], pi.[DateStarted] as [ProcessStarted], pi.[DateEnded] as [ProcessEnded], pisl.[Name], pisa.[Email] as [ApproverEmail], pisa.[Name] as [ApproverName], pisia.[DateStarted] as [ApprovalStepStarted], pisia.[DateEnded] as [ApprovalStepEnded], pisia.[DecisionId] as [ApprovalVote] from [ProcessInstance] pi left outer join [ProcessInstanceStep] pis on pis.[Proce...")
• 15:09, 28 March 2022 Smtxwiki talk contribs created page File:ClassSRM2.png
• 15:09, 28 March 2022 Smtxwiki talk contribs uploaded File:ClassSRM2.png
• 15:08, 28 March 2022 Smtxwiki talk contribs created page File:ClassSRM1.png
• 15:08, 28 March 2022 Smtxwiki talk contribs uploaded File:ClassSRM1.png
• 15:07, 28 March 2022 Smtxwiki talk contribs created page Review meeting CSS classes (Created page with "There are build-in classes that can be used in your CSS to make a service look different in case a validity period of a service has expired possible classes: reviewcycle-clo...")
• 15:05, 28 March 2022 Smtxwiki talk contribs created page Service Review Meetings (Created page with "Service Review Meetings are used to keep the service data up to date. Schedule a validity period for your services and plan a meeting to have a review meeting between provider...")
• 14:32, 24 March 2022 Smtxwiki talk contribs created page Show popup when a specific value is selected in multi select (Created page with "This example shows how you can use "Javascript to execute on asynchronous postback" to trigger on specific values that get selected in a multi selection listbox. Define this...")
• 14:10, 14 March 2022 Smtxwiki talk contribs created page Datastore filter operators (Created page with "When filtering datastores from within javascript, you can use these filter operators: equals isdifferent startswith endswith contains greaterthanorequalto lessthanoreq...")
• 14:48, 10 February 2022 Smtxwiki talk contribs created page Lucene search Engine (Created page with "==Rebuild lucene index== In order to force a complete rebuild of the Lucene index, you can include an additional parameter in the Task that normally updates the index. { "reb...")
• 08:44, 10 February 2022 Smtxwiki talk contribs created page Get Unique IDs of Group Members (Created page with "If an actor is a group, and you want to show it in the Service Catalog under 'My Approvals', you need the unique IDs. to get those unique IDs, based on the Group name, use thi...")
• 16:01, 8 February 2022 Smtxwiki talk contribs created page External App Fields (Created page with "When publishing a service, the external app Services contains a large number of fields. Some of these fields contains codes. In this page an overview is provided of the values...")
• 13:25, 16 November 2021 Smtxwiki talk contribs created page Field Validation examples (Created page with "1. FieldTwo kijkt of die gelijk is aan FieldOne, indien niet: toon error a. FieldOne: geen validation b. FieldTwo: i. Set validation error via: Javascript ii. Validation Erro...")
• 12:41, 30 July 2021 Smtxwiki talk contribs created page Setting password in LDAP person sync (Created page with "When using the LDAP Person sync, the password in the configuration file can be set this way: SMTX.LdapImport.ConsoleApplication.exe encrypt")
• 12:39, 30 July 2021 Smtxwiki talk contribs created page Using LDAPS (Created page with "In order to use LDAPS, you should keep LDAP in the connection string and check the Secure checkbox under 'LDAP Authentication Types'.")
• 20:11, 4 May 2021 Smtxwiki talk contribs created page Concatenate array values into a single string (Created page with "Example: filteredArray.join('||');")
• 20:09, 4 May 2021 Smtxwiki talk contribs created page Remove duplicates from array (Created page with "Example how to build an array of persons and in the end filter out the duplicates <nowiki> var returnRequest = #1#; var allActors = JSON.parse(CommonInterface.callWebservice...")
• 14:26, 22 April 2021 Smtxwiki talk contribs created page Creating a new service through API (Created page with "Below is some javascript that shows how to create a new service and set some template fields through javascript: <nowiki>var newGuid = CommonInterface.newGuid(); var knowled...")
• 21:31, 30 March 2021 Smtxwiki talk contribs created page Retrieving all service details through public API (Created page with "The javascript below retrieves all services through the available API and per retrieved service, the details of the service is retrieved through an additional API call. <now...")
• 11:06, 7 January 2021 Smtxwiki talk contribs created page Export Grid field to Excel in Form (Created page with "Case: you have a Grid fiel that you want the user to export into Excel Add a field of the type 'Export'. In the field 'dynamic value', put the internal label of the field tha...")
• 16:49, 2 November 2020 Smtxwiki talk contribs created page Working with dates (Created page with "When using the new Date function, you will get the date in the timezone of the SSP server: <nowiki> WorkflowInterface.updateTicketFields(5320, { "Status": "Open", "Descripti...")
• 15:27, 2 October 2020 Smtxwiki talk contribs created page Filtering on JSON array (Created page with "In case there is an array of JSON elements this is an example how to search in the JSON array: <nowiki> mandantList.filter(function (m) { return m.Mandant === 'BG-Bau'; });...")
• 15:14, 2 October 2020 Smtxwiki talk contribs created page Storing PowerShell results in datastore (Created page with "This example takes the output of a powershell script and stores it in a datastore. The script returns 3 columns per line (; seperated) and an additional lookup is done in a JS...")
• 13:47, 30 September 2020 Smtxwiki talk contribs created page Adding Timeslots to datastore (Created page with "This script creates time slots in a datastore on a given date between 2 given hours with a given number of minutes between the slots. <nowiki> //var FORMFIELD_DATUM = #1#; /...")
• 13:45, 30 September 2020 Smtxwiki talk contribs created page Example JavaScript (Created page with "This page contains some example code to use javascript within SSP Adding Timeslots to datastore")
• 12:11, 8 September 2020 Smtxwiki talk contribs created page JavaScript (Created page with "Since version 7.20.10 SSP supports javascript steps in the workflow. Below is a summary of all SSP specific functions, available to be used within the step: <nowiki> /**** Com...")
• 12:51, 11 August 2020 Smtxwiki talk contribs created page RestServiceExamples (Created page with "SSP supports REST webservices with which JSON files are used to transfer data between 2 systems. This page contains some examples how to define REST webservices. == Call type...")
• 14:37, 5 June 2020 Smtxwiki talk contribs created page File:WebServiceCallsProcess.png
• 14:37, 5 June 2020 Smtxwiki talk contribs uploaded File:WebServiceCallsProcess.png