Excel Client:CopRun: Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
==CopRun(Executable, <nowiki>[</nowiki>Parameter1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Parameter10<nowiki>]</nowiki>)==
==[[Excel_Client:Functions_(Formulas)|Function]]==
 
<span {{CoPFormel}}>CopRun(Executable, <nowiki>[</nowiki>Parameter1<nowiki>]</nowiki>, …, <nowiki>[</nowiki>Parameter10<nowiki>]</nowiki>)</span>


The [[Excel_Client:Functions_(Formulas)|function]] CopRun can be used to use or influence various functions in the CoPlanner [[Excel Client|Excel Client]].  
The [[Excel_Client:Functions_(Formulas)|function]] CopRun can be used to use or influence various functions in the CoPlanner [[Excel Client|Excel Client]].  


===Parameter===
{| class="wikitable" width={{{breite|80%}}}
 
|- {{Tabellentitel}}
{| class="wikitable" width={{{breite|50%}}}
| width="150px"|Parameter
| Description
|-
|-
|width="200pt" style=background-color:#f6f6f6 |'''Executable''' 
|Executable
|Defines the function that must be executed.
|Defines the function that must be executed.
:*Transfer - Executes a transfer object ([[Framework:Imports|import object]]) on the server.
:*ReadValue - Corresponds to [[Excel_Client:CellRead|CellRead]]; however, the value is loaded from the server immediately without being cached in the client.
:*ReadSessionValue - Corresponds to the function CopExpression; however, the expression is sent to the server immediately, evaluated, and returned, without being cached.
|-
|-
|style=background-color:#f6f6f6 |'''ParameterX'''
|Parameter1..10
|Optional parameters.
|Optional parameters.
|}
|}


==Example==
<span {{CoPFormel}}>CopRun("Transfer:Auszufuerender_Import", "Filtername1:=Filterwert1", …)</span><br>
<span {{CoPFormel}}>CopRun("Transfer:Auszufuerender_Import")</span><br>   
<span {{CoPFormel}}>CopRun("ReadValue:Umsatzerlose“, "Menge", 2Filtername1:=Filterwert1", …)</span><br>   
<span {{CoPFormel}}>CopRun("ReadSessionValue:@Session_Plan_ID@")</span>


===The following options are available===
{| class="wikitable" width={{{breite|50%}}}
|-
|width="200pt" style=background-color:#f6f6f6 |'''Transfer''' 
|Executes a transfer object ([[Framework:Imports|import object]]) on the server.
|-
|style=background-color:#f6f6f6 |'''ReadValue'''
|Corresponds to [[Excel_Client:CellRead|CellRead]]; however, the value is loaded from the server immediately without being cached in the client.
|-
|style=background-color:#f6f6f6 |'''ReadSessionValue'''
|Corresponds to the function CopExpression; however, the expression is sent to the server immediately, evaluated, and returned, without being cached.
|}
===Example===
{| class="wikitable" width={{{breite|50%}}}
|- {{Tabellentitel}}
|Function
|-
|CopRun(„Transfer:Auszufuerender_Import“, „Filtername1:=Filterwert1“, …)
|-
|CopRun(„Transfer:Auszufuerender_Import“)   
|-
|CopRun(„ReadValue:Umsatzerlose“, „Menge“, „Filtername1:=Filterwert1“, …)   
|-
|CopRun(„ReadSessionValue:@Session_Plan_ID@“)
|}
__NOTOC__


__NOEDITSECTION__
__NOEDITSECTION__
[[Category:Excel_Client_Formulas|CopRun]]
[[Category:Excel_Client_Formulas|CopRun]]
[[de:Excel_Client:CopRun]]
[[de:Excel_Client:CopRun]]

Latest revision as of 16:47, 15 April 2014

Function

CopRun(Executable, [Parameter1], …, [Parameter10])

The function CopRun can be used to use or influence various functions in the CoPlanner Excel Client.

Parameter Description
Executable Defines the function that must be executed.
  • Transfer - Executes a transfer object (import object) on the server.
  • ReadValue - Corresponds to CellRead; however, the value is loaded from the server immediately without being cached in the client.
  • ReadSessionValue - Corresponds to the function CopExpression; however, the expression is sent to the server immediately, evaluated, and returned, without being cached.
Parameter1..10 Optional parameters.

Example

CopRun("Transfer:Auszufuerender_Import", "Filtername1:=Filterwert1", …)
CopRun("Transfer:Auszufuerender_Import")
CopRun("ReadValue:Umsatzerlose“, "Menge", 2Filtername1:=Filterwert1", …)
CopRun("ReadSessionValue:@Session_Plan_ID@")