Rules Engine: Allowing rules to sort by the newest entry in a table
CS Rules & Permissions
Clients would like to be able to take the newest entry in a table and export that data into further aggregation.
For example:
(12:30am) Jan15 25k
(2:30am) Jan15 30k
(5:00pm) Jan15 60k
(12:30am) Jan16 29k
(2:30am) Jan16 42k
(5:00pm) Jan16 77k
Be able to grab only the latest entry (5:00PM) and use that data to update the field for that date. This is useful if clients have scripts updating certain fields multiple times per day, but only the last entry is needed to summarize the date's data.
For example:
(12:30am) Jan15 25k
(2:30am) Jan15 30k
(5:00pm) Jan15 60k
(12:30am) Jan16 29k
(2:30am) Jan16 42k
(5:00pm) Jan16 77k
Be able to grab only the latest entry (5:00PM) and use that data to update the field for that date. This is useful if clients have scripts updating certain fields multiple times per day, but only the last entry is needed to summarize the date's data.
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
I'm the client Logan was helping - I didn't follow your answer - what did you mean by 'first field in the show fields'?
When is the sort happening?
What write are you referring too?
Thanks so much,
Alison
When you do a test run you will see that it will return the results like this
Now when I have an action "Load to Customer", you will find that the latest value in each account will be the final data you see.
Try this out and let me know if it works.
I am now trying with a date_only field and am finding its not working.... do I need to use upsert insert or update in the rule action?
are there any other tricks to this?
Can you put through a support ticket if you are not able to get this working?