User contributions for Smtxwiki

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 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 MyOpenActions 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. Example 01: MainProductNames: - 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. The WebService needs a filterField, and potentially a SortField. 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..."
12:2712:27, 19 December 2016 diff hist +787 N External Forms and default values Created page with "Case : '' How far can you set default values when using 'external forms' in action steps'' A Form is filled in, contains field called 'Field A1'. The process has 2 Action..."
12:2612:26, 19 December 2016 diff hist +3,058 N Make an ICS 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 ! There is..."
12:2612:26, 19 December 2016 diff hist +281 N Use fields that come from external form in shop Created page with "When you have an external form, that is used in a shop, there is no need to add these fields to External Apps. Just take the field from 'Lookup > Form', it will be populated..."
12:2612:26, 19 December 2016 diff hist +104 N Decision Point after yes-no Created page with "The key here is to use 'True' and 'False' in your decision step path rows. yes/no does not work :("
12:2512:25, 19 December 2016 diff hist +452 N TableinStepinformation Created page with "When a table is added in Translations (step information), it sometimes gets pushed all the way down, creating a big white space, and causing a lot of unneeded scrolling. ..."
12:2412:24, 19 December 2016 diff hist +298 N CSS classes used Created page with " Since the version of 9 december 2016, you can see the classes used in formlabels & valuelabels. Just add: “&css=1”, example: http://dev.ssp7.smt-x.com/Forms/Admin..."
12:2412:24, 19 December 2016 diff hist +744 N FieldTypes in database Created page with " TextAreaField = 2, YesNoField = 3, UploadField = 4, DateField = 5, DateTimeField = 6, PasswordField = 7..."
12:2412:24, 19 December 2016 diff hist +93 N Line breaks in helptexts Created page with "In the new helptexts (that atay longer), you can force line breaks by entering "
12:2312:23, 19 December 2016 diff hist +1,516 N Split Multiselect Values Created page with "Cae : we have a multiselect field (checkbox) and we need each individual value (to call a subform). So how to move from the piped values into seperate values (each value in a..."
12:2312:23, 19 December 2016 diff hist +405 N DatastoreDateAsDefault Created page with "An entry of a date in a datatore field is stored as dd/MM/yyyy but to set a default date in a datafield , you need in as yyyyMMdd, so we need to convert it in a hidden field..."
12:2112:21, 19 December 2016 diff hist +476 N Current Date Created page with "Hide the read-only date field (in my example, I called it ‘datefield_hidden’), that has as default value T+0 Then make a new read only display field that shows the value..."
12:2112:21, 19 December 2016 diff hist +2,623 N BulletedListFiles Created page with "Case: we build a list of Names, they can all have multiple attachments linked to them. Data is stored in a simple datastore, with 2 fields : Name & Attachments. Goal is to s..."
12:1712:17, 19 December 2016 diff hist +475 N BulletedList Created page with "For a nicer display, it is possible to create a bulletted list from a checkbox or multi-selection field. The list can only be displayed in a read-only field or in a hidden fie..."
12:1612:16, 19 December 2016 diff hist +351 N TabLinking Created page with "You can link into a tab on the same form, and it is very simple. Just mouse-over the tab and copy the hyperlink. It will start with javascript:...., but will work. Note: if..."
12:1512:15, 19 December 2016 diff hist +663 N DefaultValuesURL Created page with "It is possible to set default values on form field, coming from the link to the form. Just add the internal label and the wanted value at the end of the link, seperated by '&'..."
12:1512:15, 19 December 2016 diff hist +358 N Prefill Date Created page with "This is actually quite simple. in the datastore, set your field as : - date field - text field When using a text field, fill it following this syntax: yyyyMMdd ..."
12:1412:14, 19 December 2016 diff hist +744 N AdvancedRadioButtons Created page with "Sometimes you need to add an image or some more help text to each option in a list (radio or checkbox). You can build something link this : File:radio.png Just make a..."
12:1212:12, 19 December 2016 diff hist +218 N Actor refresh on step activate Created page with "when you have for example a person search, for actors File:screen1.png if you want the actor to be dynamic lookup in the process, do not forget to also send the display..."
12:1212:12, 19 December 2016 diff hist +231 N NextBusinessDayCalc Created page with "To calculate the next business in a form use this calculation: format('{0:yyyyMMdd}', todate(IIF(format('{0:ddd}', now())='Fr',dateadd(now(),3,'d'), IIF(format('{0:ddd}', no..."
12:1212:12, 19 December 2016 diff hist +378 N DefaultValues Created page with "case: fieldA : holds a selection of for example groupmailboxes, and the approver is in a seperate column, called 'Approver'. fieldB : shows the approver, but needs to be HELPD..."
12:1112:11, 19 December 2016 diff hist +80 N DisplayMultiSelectTable Created page with "http://demo.smt-x.com/Forms/Admin/formDetail.aspx?tab=1&id=179&ActiveFieldId=806"
12:1012:10, 19 December 2016 diff hist +746 N NotEmptyFieldSection2 Created page with "Suppose you want to start a section, but only when a previous field (field A)is filled in. Problem is that the section's rules do not allow for something like : IF (fieldA)is..."
12:0912:09, 19 December 2016 diff hist +2,056 N NotEmptyFieldSection No edit summary
12:0912:09, 19 December 2016 diff hist +1,103 N DisplaySearcheableListbox Created page with "When you use a searcheable listbox, the values are sent to the workflow engine, with pipes (||) in between. this sometimes results in ugly displays : this is an example when..."
12:0612:06, 19 December 2016 diff hist +1,902 N ListLimitBasedOnValue Created page with "A formfield contains a comma seperated list of allowed values. another formfield showing a datastore parameter should be dynamically filtered based on the values in the comma..."
12:0212:02, 19 December 2016 diff hist +1,355 N Button Created page with "If you want a button, that holds a link in a form, use an HTML field, and we wil build a table in there. The HTML button can not be used, as you need javascript to make it wo..."
12:0112:01, 19 December 2016 diff hist +910 N DateFieldSettings Created page with "To set a default date in a form, select a date field and in the default settings field add one of the following: T+0 - if the default date is the current date T+25 - if the..."
12:0112:01, 19 December 2016 diff hist +650 N HTMLFormatting Created page with "Fake headers,or Static HTML can be used in sections that match the background and font color of the main section headers. the below is the Honeywell example. <table bgcolor=..."
12:0012:00, 19 December 2016 diff hist +24 N Nameofpage Created page with "now you start writing :)"
11:3811:38, 19 December 2016 diff hist +570 N FSC Created page with "Categories & Topics : Class = [name of the color] list: - red - orange - green - blue - pink - lemon Icon : Icon = ic_aanvragen_red.png File:ic_box_green.png..."

User contributions for Smtxwiki

19 December 2016

Navigation menu

Search