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
HI Himanshu, Are you getting any errors while applying sorting?
No Gopal error is not coming only thing is I am not able to sort data
Did you try to make this a synched record and put this logic into a custom record field?
Sort works only on fields not on logical value. My suggestion is create a custom field with this logic within your record and then you can use that field directly here and apply sort.
this record is made on view . so cannot take custom record field.
can we create custom record field in view based record
OK. Why not implement that display logic in the view itself?
Does it need to still be based on a VIEW? Have you fully considered just scrapping the view and creating it as an Appian synched record? It honestly might sound like a lot of work, but might actually be less work than it sounds.
I would, of course, if you go that route, create the custom synched record first, then delete the VIEW if you really determine you don't need it anymore after you develop it. That's what we did, though granted on a very small project.
As venky said Implement the same logic at the view level, then the sorting will work as sorting will not work on logical values. You must be having all the data for a row at the view just modify the logic for status column .
© 2022 Appian. All rights reserved.