187473 - no subject - Hi,\n\nI have created a Oracle SQL view

madhubindug over 8 years ago

Hi,

I have created a Oracle SQL view and one of the column is a difference of date and time, the data type shown in the view description is of Interval Day To Second. Now what is the corresponding type I have to give while creating the custom data type in Appian. I would be using this column for calculating the Average, aggregation function [AVG] in a!queryEntity works for data types [[Number (Integer), Number (Decimal), Interval (Day to Second)]].

Thanks,
Madhu

Discussion posts and replies are publicly visible

Parents

0 Tim
Certified Lead Developer
over 8 years ago

Agree with @sikhi, you should look at using the EXTRACT() function in Oracle so that it returns a primitive type that maps to Appina.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tim
Certified Lead Developer
over 8 years ago

Agree with @sikhi, you should look at using the EXTRACT() function in Oracle so that it returns a primitive type that maps to Appina.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data