i have performed calculation of some status staying in grid and that is changing on everyday basis i am not storing that value in any database .
and that status calculation is happening and dependent on many field . how can i apply sorting when dependency of that data is not on any particular field.
Discussion posts and replies are publicly visible
Sure Manish will try to implement by view level that
Yeah I would be interested in understanding why you chose to use a view. If you're doing joins to reference data or calculations most of those can instead be achieved through record relationships and custom record fields respectively.
yeah like initially we were not aware that calculations would be come.
Peter this Custom record field does not support now () function is there any substitute for now() function in custom record field.
venky is there any substitute for now() function in appian becz custom record field does not support now() function . This function i have used for calculation.
This will not work as the calculation of the value for the custom record field is not made at query time, but at the time of writing the data.
Ah okay, unfortunately it isn't possible to use now() in a custom record field yet, although stay tuned for releases later this year! We're definitely working on this and hope to allow for query-time calculations like this soon :)