Sorry, i keep looking for ways to not let user insert duplicate username to the database, but always fails, i know primary key as username can't be repeatedly insert in to the database by its service, but i just want
to give user a hint, and tell him can't register same username others used before and let it not to update to the back end database by its smartservice, then how can I do?
{
label: "Insert", saveInto:( a!writeToDataStoreEntity( dataStoreEntity: cons!usernameConstant, valueToStore:(ri!username) ), ), submit: if(ri!username.username in local!rule.username ,false,true), style: "PRIMARY",
} OR
label: "Insert", saveInto:(
if(
ri!username.username in local!rule.username,
{}, a!writeToDataStoreEntity( dataStoreEntity: cons!usernameConstant, valueToStore:(ri!username)
) ), ), submit: true, style: "PRIMARY",
Discussion posts and replies are publicly visible
If the parameter "validate" for a button is set to true, it will perform all validations on the interface before submitting. In case there is any non-null validation it will not submit.
Check this and filter for "Validation" below "Search Patterns"
docs.appian.com/.../SAIL_Recipes.html
Thanks for your help, but seems lastly could you tell me how to get rid of error of "When the value of "operator" is "=" "value" must not be null or empty." from your validation part give me away? I think the value can't be empty, but i can't throw its error away. Thank you