Skip to content

DataSplice Support Website

Sections
Personal tools
You are here: Home » Support Forums » DataSplice Forum » Database Procedure Conditions
 

 • Database Procedure Conditions

Replies: 3   Views: 3801
Up one level
You need to be a registered member to post to this forum. Register now.
Prev topic | Next topic

 
Member
Posts: 0

 • Database Procedure Conditions

Posted by aarogerm at 2006-02-16 10:58 AM

I've looked through the documentation but it seems to just mention there is a field for entering conditions it doesn't explain any builtins if available. Could you plese tell me what the syntax is if I only want a procedure to run if the new value entered is not equal to the original value?
If this is possible could you also please send a list of the builtins.
 
Manager
kunzem
Posts: 0

 • Re: Database Procedure Conditions

Posted by kunzem at 2006-02-16 11:17 AM

This functionality is new to DataSplice 3.0 - with version 2.3 there is no way to specify a condition like this.

With the newer version the condition would look like: IsModified("Field Name").

Full documentation of the functions available in the expression language is available here.
 
Manager
kfletcher
Posts: 0

 • Re: Database Procedure Conditions

Posted by kfletcher at 2006-02-16 11:19 AM

Assuming field of interest is named "foo"

In DataSplice 3.0:
the event chain action's "Action Condition" can be set to:

IsModified( 'foo' )

In DataSplice 2.3 this function is not available, you must create a
second field (in sql for view) 'foo2' and make this a hidden field the
user doesn't see.

then Condition is
${foo} <> ${foo2}

_________________________
()
 
Manager
kunzem
Posts: 0

 • Re: Database Procedure Conditions

Posted by kunzem at 2006-02-16 11:23 AM

I hadn't thought of that second trick for 2.3 - sneaky!
 

 
Powered by Plone

This site conforms to the following standards: