Hi all,
I am new to appian and I am trying to build a to-do list, in which the list automatically updates the date to today in the interface, and from the database queries all the to activities for today as well as yesterday.
So, I was able to make the date field dynamic in the interface layout, therefore unable to retrieve the data from the database corresponding to of current date. In the SQL, still I can manage to check the current date, but how can I update the date field in the interface layout to show todays date as my column header.
Discussion posts and replies are publicly visible
The best way to approach this is to set up a local variable that contains the current date. You can set a default value for the local variable of today, but the variable can still be changed using a date field. Plus, you can use the current value of the variable to return the current list of activities for today.
Here's an example:
a!localVariables( local!date: today(), local!query: {}, /* rule!GetDataByDate(local!date) */ { a!dateField( label: "Date", value: local!date, saveInto: local!date ), a!sectionLayout( contents: { a!richTextDisplayField( value: a!richTextItem( text: /* Display the results of local!query here */ "Here's the results for " & local!date, size: "LARGE" ) ) } ) } )
Thank you, I will for sure try to make the changes accordingly.