logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
dhd  
#1 Posted : Friday, June 21, 2019 7:51:14 PM(UTC)
dhd

Rank: Newbie

Groups: Registered
Joined: 6/17/2019(UTC)
Posts: 1
Brazil
Location: brasilia

Thanks: 3 times
Was thanked: 2 time(s) in 2 post(s)
I've looked at sample 51, and looked some old Posts here. I created the Views Enum, the script to search the restriction and redirect to the choosen view.

But i can't figure out how to create the restriction without having Seal to create a WHERE clause, and therefore a syntax error.

Can anybody help me?
epf  
#2 Posted : Monday, June 24, 2019 6:13:10 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
This will be changed in the incoming 5.0.

Before the 5.0:
Set the property 'Advanced/Use As Parameter' to true for your restriction. So your restriction will have no impact on the WHERE Clause.

After the 5.0 (coming this week):
Create a 'Report Input Values' from the collection shown in the root 'Views' node.

Warning: the 'Advanced/Use As Parameter' property has been removed from the 5.0, you have to rework your reports when upgrading from 4 to 5.
thanks 1 user thanked epf for this useful post.
dhd on 6/26/2019(UTC)
dhd  
#3 Posted : Monday, June 24, 2019 12:37:31 PM(UTC)
dhd

Rank: Newbie

Groups: Registered
Joined: 6/17/2019(UTC)
Posts: 1
Brazil
Location: brasilia

Thanks: 3 times
Was thanked: 2 time(s) in 2 post(s)
Originally Posted by: epf Go to Quoted Post
This will be changed in the incoming 5.0.

Before the 5.0:
Set the property 'Advanced/Use As Parameter' to true for your restriction. So your restriction will have no impact on the WHERE Clause.

After the 5.0 (coming this week):
Create a 'Report Input Values' from the collection shown in the root 'Views' node.

Warning: the 'Advanced/Use As Parameter' property has been removed from the 5.0, you have to rework your reports when upgrading from 4 to 5.


Thanks epf,

Worked Like a charm. Just to keep note: Seal is a great product, Powerful Simple and extremely useful for a DBA. We are very excited with the capabilities this software gave to our bussiness.
thanks 1 user thanked dhd for this useful post.
epf on 6/24/2019(UTC)
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.