Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
9 replies
Subscribers
5 subscribers
Views
3592 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
For the Query Database Smart Service, it looks like it doesn't allow an aste
nickh413445
Certified Senior Developer
over 10 years ago
For the Query Database Smart Service, it looks like it doesn't allow an asterisk (*) anywhere within the SQL statement field. The problem I'm running into is that I need to do a multiplication function within the SQL.
How do would we do multiplication in that SQL Statement box without using the asterisk?
OriginalPostID-152904
OriginalPostID-152904
Discussion posts and replies are publicly visible
Parents
0
nickh413445
Certified Senior Developer
over 10 years ago
So I was able to get around this by using the a!query rule in SAIL, and then by applying the math funtion using the index(where(search())) to the result set.
So I have:
local!AllDetails: a!queryEntity()...
...
local!filter: index(
local!AllDetails.data,
where(
search(
180*tan(45)*cos(local!AllDetails.data.field),
180*tan(45)*cos(local!AllDetails.data.field)
)
)
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
nickh413445
Certified Senior Developer
over 10 years ago
So I was able to get around this by using the a!query rule in SAIL, and then by applying the math funtion using the index(where(search())) to the result set.
So I have:
local!AllDetails: a!queryEntity()...
...
local!filter: index(
local!AllDetails.data,
where(
search(
180*tan(45)*cos(local!AllDetails.data.field),
180*tan(45)*cos(local!AllDetails.data.field)
)
)
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data