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

Notification

Icon
Error

Options
Go to last post Go to first unread
scott9677  
#1 Posted : Thursday, December 16, 2021 9:04:52 PM(UTC)
scott9677

Rank: Advanced Member

Groups: Registered
Joined: 5/18/2018(UTC)
Posts: 32

Thanks: 2 times
Is there a way to use variables set in the Input Values under General in SQL Models?

For instance, if I have input values set up in the collection as "year" and "month", should a SQL Model with

Select {CommonValue_year} as year, {CommonValue_month} as month

return a one record result with the entered values? If not, what are those called? Or do I need a script in the pre-load script to set the common values to the input values?

Thanks.
epf  
#2 Posted : Friday, December 17, 2021 1:38:39 PM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 182 time(s) in 176 post(s)
Yes it works (for Common Values not Input Values)
In attachment is a sample to display the Common Value prompted to the user.
select common value.srex (5kb) downloaded 2 time(s).

Edited by user Friday, December 17, 2021 1:39:29 PM(UTC)  | Reason: Not specified

scott9677  
#3 Posted : Wednesday, December 22, 2021 3:30:01 PM(UTC)
scott9677

Rank: Advanced Member

Groups: Registered
Joined: 5/18/2018(UTC)
Posts: 32

Thanks: 2 times
Where do you declare the common values?

When I go into my report sources 'common restrictions and values', there's no add or remove buttons.
epf  
#4 Posted : Saturday, December 25, 2021 5:52:26 PM(UTC)
epf

Rank: Administration

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

Thanks: 14 times
Was thanked: 182 time(s) in 176 post(s)
Common restrictions or values are automatically added from the SQL statements defining tables or models.
Check https://sealreport.org/Sources#lineTables_cr
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.