User contributions for Smtxwiki

12:1112: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..."
12:1112: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..."
12:1112: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..."
12:1012: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..."
12:1012: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..."
12:0912: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"..."
11:4811: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..."
11:4711: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..."
11:4411: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..."
11:4411: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..."
11:4011: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..."
11:4011: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"
11:3911: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..."
11:2911: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..."
11:2811: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..."
11:2711: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..."
11:2611: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..."
11:2611: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..."
11:2611: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 :("
11:2511: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. ..."
11:2411: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..."
11:2411: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..."
11:2411: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 "
11:2311: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..."
11:2311: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..."
11:2111: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..."
11:2111: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..."
11:1711: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..."
11:1611: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..."
11:1511: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 '&'..."
11:1511: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 ..."
11:1411: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..."
11:1211: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..."
11:1211: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..."
11:1211: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..."
11:1111: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"
11:1011: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..."
11:0911:09, 19 December 2016 diff hist +2,056‎ N NotEmptyFieldSection ‎No edit summary
11:0911: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..."
11:0611: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..."
11:0211: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..."
11:0111: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..."
11:0111: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=..."
11:0011:00, 19 December 2016 diff hist +24‎ N Nameofpage ‎ Created page with "now you start writing :)"
10:3810: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..."
10:3710:37, 19 December 2016 diff hist +1,385‎ N ReferenceTips ‎ Created page with "How to create a reference to SSP's Knowledge Management (KM) pages. To refer to a KM page in a form, create a read-only field where the default value is going to be something..."
10:3610:36, 19 December 2016 diff hist +641‎ N Transpose in database queries ‎ Created page with "Sometime you want to transpose data from rows into columns. For example, the person_extra table contains values that belong to persons, but the data is stored as rows. Here's..."
10:2110:21, 19 December 2016 diff hist +419‎ N TopicTips ‎ Created page with "How to link directly to a topic. You can make a direct link, by following this syntax : https://<link to SSP>/Forms/requests.aspx?categoryid='''35'''&topicid='''9..."
07:3807:38, 19 December 2016 diff hist +704‎ N ServerErrorCommon ‎ Created page with "The error message '''Server Error in '\Common\' Application''' indicates that something went wrong while executing code in the Common application. This application is used by..."
07:3707:37, 19 December 2016 diff hist +539‎ N GeneralError ‎ Created page with "In case something went wrong in the loading of SSP, you may get to see the "A general error has occured" page. This is an error page that SSP displays to non-admin users and d..."

User contributions for Smtxwiki

19 December 2016

Navigation menu

Search