Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
< Back to user profile
sauravk's Likes
RE: Dropdown null value issue
Venkatesh Suram
@sauravk: Can you please try below code snippet. load( local!data:{ {id:1,name:"user1",year:2016}, {id:2,name:"user2",year:2017} }, local!selectedYear:year( today() ), local!selectedCycleYear, local!dataSubset:todatasubset( local!data, a!pagingInfo…
over 5 years ago
Discussions
User Interface
RE: Filter condition in dataset
Mike Schmitt
The result of the and() function simply returns true or false, regardless of how much stuff you have in it. I'm guessing it would not work as expected when your function evaluates to ri!aCdt[true()] or ri!aCdt[false()].
over 5 years ago
Discussions
User Interface
RE: Filter condition in dataset
chandu
Apart from the above suggestion, try to use Index function.
over 5 years ago
Discussions
User Interface
RE: How to count frequency of data in dataset
Carlos Santander
I'm assuming you mean this is a grid that is presented to the user and not data that's coming from the database. While there's no out-of-the-box rule that will give you this, the following expression can serve as a starting point: = load( local!data…
over 5 years ago
Discussions
User Interface
RE: How to count frequency of data in dataset
mayurm168
1. Let's name the master data you have as coreData having 3 columns (col1,col2,col3) 2. Create an expression rule named filterData which accepts input of cdt type of coreData (NO MULTIPLE) Code for the rule... if( rule!apn_isEmpty(ri!input), …
over 5 years ago
Discussions
User Interface
RE: How to count frequency of data in dataset
ankita0004
For this, You can apply the validation at field level like for column 1 a!gridRowLayout( contents:{ a!textField( label:"Column 1", value:ri!data[ri!index].c1, saveInto:ri!data[ri!index].c1, validations:{ if( count( whereContains( ri!data…
over 5 years ago
Discussions
User Interface
RE: Need one function
chandhinir
You can find all available functions in the below link: docs.appian.com/.../Appian_Functions.html Ldrop,rdrop will be under array functions.
over 5 years ago
Discussions
User Interface
RE: Need one function
Edwin Yesa
Hi sauravk , Here is the code for the function. load( local !months : { "JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP", "OCT", "NOV", "DEC" }, local!quarter: { "Q1", "Q2", "Q3", "Q4" }, /…
over 5 years ago
Discussions
User Interface
RE: Search text in cdt
PhilB
Here you go - pretty sure this does what you want - paste it into the interface designer and see what you think. load( local!data: a!forEach( items: enumerate( 5 ) + 1, expression: { "A": 1 + ( ( fv!item - 1 ) * 10 ), "B": 2 +…
over 5 years ago
Discussions
User Interface
RE: Validation Rule Issue
dipaki
Hi sauravk , Try using any of the following, 1) if( length( wherecontains(ri!testData[ri!index].nameCell,ri!testData.nameCell) )>1, "Duplicate",null), 2) if( contains( remove(ri!testData.nameCell, fv!index), ri!testData[fv!index].nameCell), "Duplicate…
over 5 years ago
Discussions
User Interface
<
>