how to use action in user-context or how to pass more parameter than only passing '$(PrimaryKey)'?

exec RSEprocItem '$(PrimaryKey)', 'program','$(UserID)','$(ProgID)'

**** DEBUG MODE ENABLED *******
Dynamic Views Version: 1.0.5.18601
ModuleID: 466
TabID: 86

DotNetNuke Version: 5.5.1

This is the query we will be executing for this:exec RSEprocTrashItem '127', 'program','$(UserID)','$(ProgID)'
Detail View:
Detail View2:466
Loading Data
Inside Get Data:Load
New Page Size:
Record Count:2
Table or Query:0
Query Details:[dbo].[RSEvwTrash]
Error Finding Rows: [TYP] = 'program'
UserID:1
Sort Field:Name
Sort Order:ASC
Records Per Page:0

Richard

Actions is a new feature added into Dynamic Views and the primary purpose is to allow you to work with the detail record of that record for that action. Right now there are not other tokens that I know of but if you can provide me with some information on what you are trying to do/what you would like to accomplish I might be able to add some enhancements into the next patch for how fix.

A couple items to note...
Although $(UserID) should be a token and we can add this for the next release, you could also add this to your query as I know that is a valid token for the query.

So for example, if you query is:
Select * from yourtable

it could be
Select *, $(UserID) as [UserID] from yourtable

And then you would have the UserID to work with...

I am not sure about your program ID, where is that query coming form on your end?

-Chad

Hello Chad,

thanks for your reply. The Problem ist not to get data from SQL in usercontext however to pass data thru the action in usercontext.The action will be executed as an URL-string like

http://localhost/myProducts/tabid/8...PrimaryID/23/Default.aspx
Someone who knows the exact path, because he is a member of my portal, can change the ID promiscouos and can execute actions and can change data from other users.

So it is necessary to prevent this and pass the userID with the actionID.

It will be a great pleasure for me if you can change this asap.


This query
exec RSEprocItem '$(PrimaryKey)', 'program','$(UserID)','$(ProgID)'
was for testing to see if its possible to pass more than one parameter thru the action. Curious is that it is possible to pass the parameter 'program' or something else but not as a variable like '$(UserID)'

Do you have a timeline for next patch?

thanks,
Richard