Forum / Remote Desktop Manager - Feature Request

promt for parameters

  • Create an Issue

Hi All,
it's now the time to request a new feature:
would it be possible to have sth. like a "promt for paramters". I would like to store a sql query/precedure at RDM, but this sql command needs for example a customernr or an adressid or sth like this...

Clock7 yrs

Hi,
Do you mean to add a prompt for parameter in the Data Report?

David Hervieux

signaturesignature

Clock7 yrs

exactly...

Clock7 yrs

Excellent. Thank you

David Hervieux

signaturesignature

Clock7 yrs

would this be possible ad this feature to the current beta or are you already feature completed?

Clock7 yrs

André has just came back from vacation and he has a lot of work to catch up. I will see if he do this in then next few weeks.

David Hervieux

signaturesignature

Clock7 yrs

Hi David,
first i would like to say thank you for your implementation!

would it be possible, to add these parameters also to the sql-query-session-tools-type?
and could you change the sql-report-sessions, to allow more than one select statements?
i'd like to do sth like this:
declare @FirmID int = @Param1

SELECT VetsXL_Firms.*
FROM VetsXL_Firms
WHERE VetsXL_Firms.FirmID=@FirmID

SELECT VetsXL_Addresses.*
FROM VetsXL_Firms, VetsXL_Addresses
WHERE VetsXL_Firms.FirmID=@FirmID and VetsXL_Firms.AddressID = VetsXL_Addresses.AddressID

SELECT VetsXL_Users.*
FROM VetsXL_Users
WHERE VetsXL_Users.FirmID=@FirmID

Clock6 yrs

This means that we will need to generate 3 results (datagrid), isn't it?

David Hervieux

signaturesignature

Clock6 yrs

yeah, thats exactly what i would like to have. I think it's "just" a foreach datagrid wink

Clock6 yrs

Added to our todo list smile

David Hervieux

signaturesignature

Clock6 yrs

Thank you

Clock6 yrs