I have the question as below
1. Put 2 values include MG and AM in POSIT_SYS
2. need to put start with some char (IT) in SECTCODE
3. select null value only in RESIGN
A few ways you can do it:
-Use Filter and advanced to specify your requirements.
-Create Sql table or Stored procedure to do the filtering as you specified. Then create smartobject from that and call it in K2.
» First of all, you logic should handle multiple value (whether stored procedure or assembly)
Stored procedure smartobject, you can use string with delimiter Assembly smartobject, you can create serialize parameter
» You need to handle how you query on your logic (ex. LIKE keyword for stored procedure)
» Stored procedure smartobject, you can define default parameter (ex @INPUTPARAM NVARCHAR(50)=NULL), when null, you no need to assign value.
or if you consider empty string is NULL, you can convert it to null using NULLIF in stored procedure.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.