For the Query Database Smart Service, it looks like it doesn't allow an aste

nickh413445

Certified Senior Developer

over 9 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?

Discussion posts and replies are publicly visible

Parents

0 nickh413445
Certified Senior Developer
over 9 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 9 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