Hi there !
Trying to create a report based on counting register and group by date. So, the result should something like that:
Records Day 10 25 4 26 9 27 25 28 16 29
Looking for a solution, I find out this function that handler month and year, but nothin for day.
Is it possible to do that in another way ? Dunno, a workaround using a expression, for example.
Thanks anyway for read till here!
Discussion posts and replies are publicly visible
Syncronized records support custom fields which allow you to get the date from a dateTime field. Then you can aggregate on this custom field.
Thanks for reply so fast!
looks like this doesn't work, since aggregationFields cannot be used with custom record field expressions, according the documentation.
Or there's another option ?
Which version are you using? Assuming you're on 21.2 or later, The grouping function supports grouping by lots of things, including DAY_OF_MONTH, DATE, etc.Can you share a sample of the query you created?
We're using Appian version 21.4.
According the documentation, only YEAR and MONTH could be used in this situation. Is there another approach ?
It looks like you're using a!queryEntity() - can you use a!queryRecordType() instead?
I'll try it. Meanwhile ... What's the difference between them ? Which scenario should I use each one ? Should queryEntity handle this case?
In general a!queryRecordType() is newer and has more functionality for reporting. I typically recommend that a!queryEntity() should be used on forms / processes, and a!queryRecordType() can be used for record views and reports.
hum... got it... I guess. I've converted for queryRecordType solution and works flawless. Thanks !