Register  Login  
  February 5, 2012  
Forum    
Forum Minimize
 
ForumForumDiscussionsDiscussionsSQLGridSelected...SQLGridSelected...Is there a way to pass a Condition in a querystring?Is there a way to pass a Condition in a querystring?
Previous Previous
 
Next Next
New Post
 3/3/2010 4:26 AM
 

Using SGSV is there a way to pass the status of a Condition using the query string?

I am wanting to use an existing instance and provide a link from another page that will show results whilst applying one of the conditions available. without having to copy the instance.

Clear as mud ;)

Antony

New Post
 3/3/2010 10:42 PM
 

Antony,

SGSV does allow you to pass a string via the query string.. It is typically used to pass the ItemID of some record, but in fact can be just about anything (except SQL) ... so the format is [QUERY:<keyname><:default_value>]. The default value is optional, but if supplied will be used if the keyname and keyvalue are not present in the query string.

Not sure what "condition" you want to pass, but you can place the subsitution variable in the primary select or one of the filter selections.

Hope this helps
Paul.

New Post
 3/3/2010 11:05 PM
 

Hi Paul

The condition I am referring to is one I have defined in the SGSV settings. In this case it selects users who are members of a particular role. When viewing the module without passing anything to the page the viewer sees the quesiton:

'Only show users in Role X' with a checkbox next to it.

What I would like to do is pass a querysting var to the page so this condition is selected. I thought it might be something like 'SGSVpage.aspx?condition1=true' but that isn't working

Antony

New Post
 3/5/2010 7:01 PM
 

Antony,

Yes SGSV does allow you to use the ...?condition1=true on the request string. You do need to check the processing option ""Check Request String for Default Values" for the option to work .. this is a security issue -- I don't check the request string unless I am asked to.

Let me know if you have any problem with this...

Paul.

New Post
 4/8/2010 9:49 PM
 

Just getting back to this one.

I have selected the 'check querystring' setting. However when I add '?condition1=true' to the end of the url (and go there) it just loads the page without the option selected and no records returned. I must be missing something.

Antony

New Post
 4/8/2010 10:32 PM
 

Think I have figured it out. Could be a bug.

I had the 'Select Before First Display' processing option selected. Thinking that this would apply if there wasn't a querystring or 'remember selections' was selected. Unselect it and both the querystring and remember selections options start working.

IMHO the process should be (assuming each are enabled):

  1. Check for query string if so run query with query string
  2. Check for remembered selections if so run query with remembered selections.
  3. Check if Select before first Display is active, if so run with that.
  4. run query with no parms/ options

As a follow on it would be nice that if any Options/Parms are used as a result of 1 or 2 it shows which to the user. At the moment they are left blank.

Antony

New Post
 4/10/2010 2:39 PM
 

Antony,

The issue you encountered in not really a bug, but a UI issue. I believe you have a valid issue, but I believe this should be a completely different option so the use understand the steps taken in each.

I will look to add this into V5.8 coming soon.

Thanks for the feedback - always helps
Paul.

Previous Previous
 
Next Next
ForumForumDiscussionsDiscussionsSQLGridSelected...SQLGridSelected...Is there a way to pass a Condition in a querystring?Is there a way to pass a Condition in a querystring?

Print  

  Home | Blog | Forum | Subscriptions | Free Modules | Videos   Page generated in 0.594719 seconds.
  Copyright 2010 by TressleWorks   Terms Of Use | Privacy Statement