View Creation Multiply Database Columns

kevinn397 over 8 years ago

I get an error when I try to use multiplication of two columns from the same table of an Oracle database. I'm using the format (column1 * column2) AS column3 and I end up with an error that says, "You cannot perform a * query."

Discussion posts and replies are publicly visible

0 vinayakb over 8 years ago

can you try adding space here "r"."probability"*"r"."impact" for the star sign. Also, is it necessary to add the query in double quotes?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sanjays0006 over 8 years ago

Kevin,
I think you need to create a view and then create a datastore entity to fetch the data.
This query is not working on the Query Database Smart Service.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kevinn397 over 8 years ago

Hi,
Sanjay:
The datastore entites already exists and it's populated. The actual view CDT already exists too. the source of the issue is using the "*" symbol inside of Database Query Smart Service.
Vinayakb:
Not using the double quotes will cause the Smart Service to throw an error as far as I know. I'll try it without it and post results.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sanjays0006 over 8 years ago

Kevin,
In that case, you don't have to use the Query Database Smart Service.
You can create a query rule and fetch the data from the datastore entity.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kevinn397 over 8 years ago

Ok got it. Thanks everyone for helping.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel