https://wiki.smt-x.com/index.php?action=history&feed=atom&title=Queries_related_to_the_datastore_parameters 2026-04-03T23:06:12Z Revision history for this page on the wiki MediaWiki 1.44.3 https://wiki.smt-x.com/index.php?title=Queries_related_to_the_datastore_parameters&diff=195&oldid=prev 2020-05-25T20:44:30Z

<p>1 revision imported</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <tr class="diff-title" lang="en"> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="1" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 22:44, 25 May 2020</td> </tr><tr><td colspan="2" class="diff-notice" lang="en"><div class="mw-diff-empty">(No difference)</div> </td></tr></table>

Smtxwiki https://wiki.smt-x.com/index.php?title=Queries_related_to_the_datastore_parameters&diff=194&oldid=prev 2018-08-14T12:52:52Z

<p>Created page with &quot;Below are some example queries that run on the parameter data table: update processinstance set ticketdescription=field6, ticketinformation=field27,...&quot;</p> <p><b>New page</b></p><div>Below are some example queries that run on the parameter data table:<br /> update processinstance set <br /> ticketdescription=field6, <br /> ticketinformation=field27, <br /> ticketsolution=&#039;ActualFinish: &#039; + Field7 + &#039;&lt;br /&gt;&#039; + replace(field26,char(13),&#039;&lt;br /&gt;&#039;),<br /> ticketpoolid = 14,<br /> ticketclassification = &#039;3W&#039;,<br /> ticketstatus = &#039;Closed&#039;,<br /> ticketMedium = &#039;HPSD&#039;,<br /> TicketService = &#039;3W&#039;,<br /> TicketFieldsLocked = 1<br /> from parameterdata where parameter_id=1058 and processinstance.id=field5 and Field8=&#039;281521429887887&#039;<br /> <br /> Save HPSD Ticketnummer<br /> insert into ProcessInstTicketCustomFldVal <br /> select field5, 6, min(field1) from ParameterData where Parameter_Id=1058 and Field8=&#039;281521429887887&#039; group by field5 <br /> Save Instruction<br /> insert into ProcessInstTicketCustomFldVal <br /> select field5, 5, field28 from ParameterData inner join ProcessInstTicketCustomFldVal on stringvalue=field1 where Parameter_Id=1058 and Field8=&#039;281521429887887&#039; and field28 is not null and field28 &lt;&gt; &#039;&#039; group by field5,field28<br /> <br /> Add remark to history<br /> insert into ProcessInstanceMessage <br /> select field5, getdate(), 1, &#039;Actie &amp; Analyse geïmporteerd vanuit HPSD in het Instructie veld&#039;, 6,3,0 from ParameterData where Parameter_Id=1058 and Field8=&#039;281521429887887&#039; <br /> <br /> Field1 to field20 and field26 to field50 are varchar(1000) fields. Field21-field25 are unlimited varchar fields.<br /> <br /> Read out full contents of datastore parameter<br /> SELECT FIELD1 as Name, Field2 as Name2 from parameterdata where parameter_id=123</div>

Smtxwiki