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
nithin  
#1 Posted : Tuesday, May 7, 2019 4:46:22 AM(UTC)
nithin

Rank: Member

Groups: Registered
Joined: 4/12/2019(UTC)
Posts: 14
India
Location: Kerala

Thanks: 6 times
Hi dev!

Is it possible to populate restriction values based on a selected restriction value, like sub filters..?
For example, Im preparing a sales report. The restrictions/filters applied be Customer Type, Customers, Region, Branch, Sales Person. If the restriction value of Customer type is selected from an enum list, how to generate the enum list for restriction Customers falling under the selected Customer type..? Also, i need to pass the IDs of selected restriction values, like CustomerTypeID, CustomerID and so to the procedure and only the filtered data set has to be fetched from the database. How the IDs of selected restriction values can be fetched and passed to the procedure as common restrictions?

Im using SR 5.0

Thank you!
epf  
#2 Posted : Tuesday, May 7, 2019 6:53:37 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)
Yes, it is coming in the 5.0 with the 'Select SQL for prompted restriction' in the 'Dynamic Display'
You can defined a dependency with a keyword like:
Code:
SELECT DISTINCT City
FROM Customers
WHERE Country in ({EnumValues_Country})
ORDER BY 1


where Country is the name of another enum named 'Country'

However the 5.0 is in beta and still in dev. so you should wait for a more stable 5.0....

Edited by user Tuesday, May 7, 2019 6:54:12 AM(UTC)  | Reason: Not specified

nithin  
#3 Posted : Wednesday, May 8, 2019 4:41:07 AM(UTC)
nithin

Rank: Member

Groups: Registered
Joined: 4/12/2019(UTC)
Posts: 14
India
Location: Kerala

Thanks: 6 times
Thank you for your response, epf!

When do you expect to release stable 5.0..?
epf  
#4 Posted : Wednesday, May 8, 2019 5:55:08 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)
in June 2019 probably...perhaps we will release a beta before...so you can test it.
thanks 1 user thanked epf for this useful post.
nithin on 5/9/2019(UTC)
Users browsing this topic
Similar Topics
Dynamic restrictions are not clearing and are sticky (Reports)
by Padma 11/21/2019 8:02:11 PM(UTC)
Dynamic Restriction Values in Prompt (Reports)
by Benbabu 8/16/2019 10:01:30 AM(UTC)
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.