71305 - no subject - #Records Hi, we are trying to create a b

kdimitrov over 11 years ago

#Records Hi, we are trying to create a bar graph in the new SAIL interface, which shows new records by month (i.e. {January, 56}, {February, 25}, etc..... We are storing the date of the record's insertion (i.e. 18/06/2013 for example). Is it possible to convert these dates to a month value and aggregate the data over it? We are currently using the queryrecord() and type!Query as the tutorial has recommended, but it does not seem to allow that use case....

Discussion posts and replies are publicly visible

Parents

0 kdimitrov over 11 years ago

Hi Sathya, thanks for that info. We have created a view with 2 fields (label and data) that does the MONTH() and GROUP BY calculation, but we are unable to register a data type against it. It seems that Appian is demanding a primary key (the DDL script shows ALTER TABLE .... ADD PRIMARY KEY a_id ....). Is there any way go around that issue? We can't put a primary key on a view obviously.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 kdimitrov over 11 years ago

Hi Sathya, thanks for that info. We have created a view with 2 fields (label and data) that does the MONTH() and GROUP BY calculation, but we are unable to register a data type against it. It seems that Appian is demanding a primary key (the DDL script shows ALTER TABLE .... ADD PRIMARY KEY a_id ....). Is there any way go around that issue? We can't put a primary key on a view obviously.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data