Berto2002 Posted December 15, 2021 Share Posted December 15, 2021 Hi, A couple of quickies please: In which table is the "Feedback Rating" for a Request Stored please? I looked on Wiki (Customer Feedback - Hornbill) and could see no reference. I thought it would be in the main Request table because it is part of the output from the Get Request Information > Request Details task We had a flow put in during our implementation that was supposed to identify low ratings and flag-up to the manager. But it's flagging-up even 5-star ratings. Can you tell me if this is the correct expression? The expression was set-up as "is in". Should it be "contains" or something else? Because I cannot find the field in the tables, I can't find it in database direct to check. Thank you Berto Link to comment Share on other sites More sharing options...
Victor Posted December 15, 2021 Share Posted December 15, 2021 5 hours ago, Berto2002 said: In which table is the "Feedback Rating" for a Request Stored please That would be the main requests table. 5 hours ago, Berto2002 said: I thought it would be in the main Request table because it is part of the output from the Get Request Information > Request Details task It is. It's the h_rating field. It stores a number equal with the number of stars provided in the feedback. 5 hours ago, Berto2002 said: Can you tell me if this is the correct expression? If you are looking to "flag" requests with a one, two or three star rating then that is a correct expression. 5 hours ago, Berto2002 said: flagging-up even 5-star ratings Perhaps this needs investigating then... hard to say what is happening without looking at some data. Link to comment Share on other sites More sharing options...
Alberto M Posted December 16, 2021 Share Posted December 16, 2021 Hi @Berto2002. I have a workflow that handles the feedback and I'm using this as expression, and it works fine. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now