User contributions for Smtxwiki

27 June 2017

• 12:1312:13, 27 June 2017 diff hist +599 N External DataStores Created page with "this query gives all information of all datastore parameters which are of the type 'External Query'. It gives the name, Category, ConnectionString, SQLQuery, Refresh rate (in..."

12 June 2017

• 10:5910:59, 12 June 2017 diff hist +1,538 N Table Form No edit summary

31 May 2017

• 15:4815:48, 31 May 2017 diff hist +3,207 N ValueEncoding No edit summary

22 May 2017

• 17:1217:12, 22 May 2017 diff hist +211 N Copy text Created page with "case: From this sample text 'test\azerty', I only need the part before the '\'. do a calculation like this: SUBSTRING('#REPLACE-FORMFIELD-FORMFIELDHERE#', 0, INDEXOF('#REPLA..."

26 April 2017

• 13:4713:47, 26 April 2017 diff hist +2,180 N Datacalculation No edit summary

20 April 2017

• 16:5116:51, 20 April 2017 diff hist +401 N Redirect Forms Created page with "First, give the old form a redirect to the new form. Move form into topic that is 'retired'. The Magic is to have the old form live but adjust the role in the way that you jus..."

13 April 2017

• 12:1212:12, 13 April 2017 diff hist +691 N FormError No edit summary

12 April 2017

• 15:2015:20, 12 April 2017 diff hist +446 N Line Breaks HTML Editor Created page with "By default the HTML editor provided by SSP shows linebreaks of the type </p> similar to linebreaks of the type <br />. This is caused by a stylesheet setting. In order to show..."

3 April 2017

• 09:2709:27, 3 April 2017 diff hist +1,076 N Checkfordifferences No edit summary
• 08:4808:48, 3 April 2017 diff hist +472 N Use Main Form Field in subform without naming the mainform Created page with "Case: I want to provide data to a subform, coming from a mainform, without naming the mainform. Because, I want to re-use the same subform in multiple mainforms, so I only wa..."

8 March 2017

• 10:2810:28, 8 March 2017 diff hist +114 N Float Cancel Right No edit summary

2 March 2017

• 09:5309:53, 2 March 2017 diff hist +234 N TicketsPerMonth No edit summary

28 February 2017

• 11:5111:51, 28 February 2017 diff hist +1,457 N Numberformat No edit summary

27 February 2017

• 17:5617:56, 27 February 2017 diff hist +136 N UseOfSubProcess Created page with "SELECT ProcessId FROM ProcessStep WHERE SubProcessId = 176 This gives all processIDs where process with ID 176 is used as sub-process."

15 February 2017

• 22:0222:02, 15 February 2017 diff hist +1,494 N Workflow Update Variable Created page with "The url of the webservice is: /Workflow/WebService/WorkflowService.asmx, the method “ProcessInstanceUpdateVariable” has been added with these parameters: ProcessInstance..."

13 February 2017

• 18:0818:08, 13 February 2017 diff hist +602 N Run query on SSP database No edit summary

10 February 2017

• 17:5317:53, 10 February 2017 diff hist +1,506 N Nice looking layout without using images No edit summary
• 17:5017:50, 10 February 2017 diff hist +106 N EmailTips No edit summary
• 16:1416:14, 10 February 2017 diff hist +2,937 N Classes No edit summary

8 February 2017

• 18:3118:31, 8 February 2017 diff hist +318 N AdvancedFilters Created page with "More advanced filters can be set in the following way: RequestorExtraFields=Country==$person_Country$ The example above shows all tickets for which the Person attribute 'Cou..."

3 February 2017

• 15:4515:45, 3 February 2017 diff hist +353 N Print PDF No edit summary

1 February 2017

• 16:5316:53, 1 February 2017 diff hist +367 N IncreaseMailsize Created page with "Change the following setting <system.web.extensions> <scripting> <webServices> <jsonSerialization maxJsonL..."

20 December 2016

• 16:1716:17, 20 December 2016 diff hist +204 N Filter a view on a formfield No edit summary

19 December 2016

• 13:1813:18, 19 December 2016 diff hist +1,241 N UseWebServiceInForm Created page with "Sometimes you want to retrieve data from web services while completing a form. SSP provides a NCALC function to lookup web service data from any web service d..."
• 13:1613:16, 19 December 2016 diff hist +3,799 N UseWebServiceInProcess Created page with "After adding a new web service definition, the web service can be used in processes. Go to the Admin-Processes menu and open the process in which you want..."
• 13:1513:15, 19 December 2016 diff hist +920 N AddNewWebService Created page with "This article is about creating a new webservice, assuming all data required is already available. For information how to create a correct XSLT and which headers to use, please..."
• 13:1413:14, 19 December 2016 diff hist +680 N Only show accessories Created page with "We want to show accessories, only when a main product is selected. But, we also need an ordertype, that allows to order ONLY accessories ! follow these steps : 1. Make new..."
• 13:1413:14, 19 December 2016 diff hist +884 N Link into an Order Type Created page with "You can create a link into a shop, but how to link with an ordertype (OT) selected, or even go into the next chevron, called 'Select Products'? <br> First of all, if there are..."
• 13:1413:14, 19 December 2016 diff hist +472 N Map user data Created page with "Here are the 3 business levels : REPLACE-EXTAPPFIELD-SSP6.Webstore-UserBU1 : CORP REPLACE-EXTAPPFIELD-SSP6.Webstore-UserBU2: HITI REPLACE-EXTAPPFIELD-SSP6.Webstore-UserBU3:..."
• 13:1313:13, 19 December 2016 diff hist +1,658 N External Apps Created page with "External Apps > WebStore will always contain a basic set of fields that the webstore sends accross.<br><br> When you want to hide a field from 'Request Overview' : edit the f..."
• 13:1313:13, 19 December 2016 diff hist +216 N Show traffic light per each simultanuous path Created page with "When you search for a ticket, you can see the status of the process using the “AllOpenStepsStatusImage”. This option now is also available to be used in Emails and Proc..."
• 13:1313:13, 19 December 2016 diff hist +128 N Add Variables in a View Created page with "The ID does not matter, the name of the variable is ok :) syntax: Variable-<name-of-variable> Sample: Variable-ApprovalLinks"
• 13:1213:12, 19 December 2016 diff hist +271 N Add Columns that show Personal data from Requestor or RequestedFor Created page with "You can add any field from the User Data in SSP. Example: RequestedFor-PORDepartment Do not forget the '-' between de user & the value ! or as we wrote in the manual : Requ..."
• 13:1213:12, 19 December 2016 diff hist +509 N Show tickets where a person attribute is the same as the logged in person in a single view Created page with "Case: we want a view that shows all open tickets of all users, based on a person's attribute (like department). TicketStatus=Open<br> RequestedForExtraFields=PORDepartment==$..."
• 13:1213:12, 19 December 2016 diff hist +265 N Show tickets from multiple selected processes Created page with "This query will show all your approvals from 2 selected processes. Tip is to seperate them by double pipes || OpenActionIsApproval<br> MyOpenActions<br> TicketName=Form1||For..."
• 13:1113:11, 19 December 2016 diff hist +387 N Show WebStore fields in a View Created page with "==Default WebStore Fields== You just need the internal label of the Field, as defined in External Apps.<br><br> Example 01: MainProductNames: <br> - FormField-MainProductNames..."
• 13:1113:11, 19 December 2016 diff hist +413 N Available fields to sort on in Ticket type views Created page with "If you want to sort on a certain column in a view, SSP sorts through all tickets that match the views criteria. Therfore, for performance reasons, in the viewtype=ticket, the..."
• 13:1113:11, 19 December 2016 diff hist +222 N Open Approvals Created page with "This will show all your open approvals: OpenActionIsApproval MyOpenActions If you want to show all approvals to which you have access rights (so where you are not necessa..."
• 13:1013:10, 19 December 2016 diff hist +179 N Exclude Created page with "You can now exclude processes Using the filter TicketNameNot= (followed by friendly display name of processe(s)) You can use multiple processes, seperated by a double pipe..."
• 13:1013:10, 19 December 2016 diff hist +676 N ExternalApps Created page with "When an external app creates tickets in SSP, and you want to make a view, showing only tickets from that source. There is an issue, as the basic filters require a FormName, wh..."
• 13:0913:09, 19 December 2016 diff hist +1,071 N All sources that can be used in a View Created page with "These sources can be used in the "Source column" field of a View Field settings. Please note that they are case sensitive. "ticketnr" "ticketdatestarted" "ticketdateended"..."
• 12:4812:48, 19 December 2016 diff hist +687 N Tableinemail Created page with "An email template sometimes has tables in it. to define the code of those tables, you need to add this (on top) into the code view when editing the email (template) : <sty..."
• 12:4712:47, 19 December 2016 diff hist +390 N SeeAllForms Created page with "We created this query for Proximus, it also holds a fixed entry 'Report an issue' this is the query (created by Bart) : SELECT "Form_Id" "Id", "InternalLabel", "Title" "Titl..."
• 12:4412:44, 19 December 2016 diff hist +247 N GetViewDefinition Created page with "Use the query below to see the view definition through an SQL command select definition from sys.objects o join sys.sql_modules m on m.object_id = o.object_id whe..."
• 12:4412:44, 19 December 2016 diff hist +336 N GetFormTranslations Created page with "select fl.language_id, f.id, ff.internallabel, ff.selectionparameter, fl.label, fl.helptext, fl.selectiondisplayfields, fl.dynamicvalue, fl.dynamicvalueselectionfield, fl.help..."
• 12:4012:40, 19 December 2016 diff hist +4,201 N GetDataFromDataStore Created page with "New feature since 17/11/2014. You can now pull data from a Datastore Parameter, in a process.<br> The WebService needs a filterField, and potentially a SortField.<br><br> An..."
• 12:4012:40, 19 December 2016 diff hist +133 N GetFormInstanceValues Created page with "This query returns all values that were stored during submit of a form: select * from forminstancevalue where forminstance_id = 1846"
• 12:3912:39, 19 December 2016 diff hist +549 N ClearTickets Created page with "In some situations, the SSP database needs to be flushed from any operational data. This can be helpful before a go-live to reset the SSP ticket numbering to 0. Definitions of..."
• 12:2912:29, 19 December 2016 diff hist +336 N ReportingTemplates Created page with "Q: is it possible to have the basic fields from 'search tickets' in a reporting template? these fields in particular: - status - current step name - current actor - last actio..."
• 12:2812:28, 19 December 2016 diff hist +280 N Make a CSV Created page with "First, make the 'text File', that can be done under 'General Settings' of a process (see the new section 'text files on that page). This is a new feature in SSP 7.1 ! When..."