Rank: Member
Groups: Registered
Joined: 4/12/2019(UTC) Posts: 14  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!
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 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
|
|
|
|
|
|
Rank: Member
Groups: Registered
Joined: 4/12/2019(UTC) Posts: 14 Location: Kerala Thanks: 6 times
|
Thank you for your response, epf!
When do you expect to release stable 5.0..?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
in June 2019 probably...perhaps we will release a beta before...so you can test it.
|
 1 user thanked epf for this useful post.
|
|
|
|
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.
