I need a custom record field, of which the value is the result of query, can we do any query in custom record field
Discussion posts and replies are publicly visible
Sorry, no. That would get you in a huge performance risk situation. To avoid such danger, Appian does not support this.