Limit the rows returned by an analytic

[tmschiller]

I'm trying to create an analytic that will create update account tasks, but I need to be able to control the number of rows returned. I've tried the following, which works in the analyzer, but fails when creating the actual analytic with the error "Resultset Must Have column acctKey for allowed actions Update Account", which it obviously has. Now when I remove the "Limit 0, 100", I am able to save the analytic, but I lose the whole functionality I was intending.

Select
ACCOUNTKEY AS acctKey,
NAME,
DESCRIPTION
from
ACCOUNTS
Where
ENDPOINTKEY IN (4,5,6)
AND DESCRIPTION NOT LIKE '%SSM%'
AND STATUS = 1
ORDER BY NAME
Limit 0, 100

[rushikeshvartak]

try online with limit

[pruthvi_t]

Hi @tmschiller ,

Greetings.

I'm able to create analytics with same query but on 23.4 version. Can you please share the version you're trying it in. 

Thanks,

[tmschiller]

[dgandhi]

This works in Saviynt 5.5 version also. You can give below also a try

Select
ACCOUNTKEY AS acctKey,
NAME,
DESCRIPTION
from
ACCOUNTS
Where
ENDPOINTKEY IN (4,5,6)
AND DESCRIPTION NOT LIKE '%SSM%'
AND STATUS = 1
ORDER BY NAME
Limit 100

ME TOO

Thanks

[tmschiller]

Nope, same error

[dgandhi]

Do you have this config?

Thanks

[tmschiller]

Of course I do, not that it would impact saving/running the analytic if it wasn't there since "acctKey" would just be a column alias.

[dgandhi]

Ok, the same config works in my environment which is also on 5.5. Its better to open a Saviynt FD ticket and get this fixed.

Thanks

[pruthvi_t]

@tmschiller , I have tried in 5.5sp3.x version as well and I'm able to create the analytics using the same query as yours. Kindly raise a FD ticket with all the details so one of our support engineers can take a look at it.

Thanks,