I am trying to set up a grid in Genie which uses an RPGsp program on the server to return information for the Grid.
However, the data url property on the grid seems to do a post so I am unable pass information from the screen to the RPGsp program. How can I pass information from the screen (e.g. cllient number) to the RPGsp program?
Grid using a data URL
-
- Profound User
- Posts: 72
- Joined: Fri May 08, 2009 2:43 pm
- First Name: David
- Last Name: Esdale
- Company Name: Guardian General Insurance
- City: Port of Spain
- State / Province: Outside Canada/USA
- Country: Trinidad and Tobago
- Location: Trinidad
- Contact:
- David
- Profound Logic Staff Member
- Posts: 690
- Joined: Fri Jan 04, 2008 12:11 pm
- First Name: David
- Last Name: Russo
- Company Name: Profound Logic Software
- Contact:
Re: Grid using a data URL
Currently there is no interface for sending parameters on the post. Are you able to use the SQL option for creating the grid? You can specify the SQL query using the "custom sql" property. Anything can be done here, such as joining files, filtering records, etc.
You can use property scripting to put the client number into the WHERE clause, for example, to filter the records.
Does this help?
You can use property scripting to put the client number into the WHERE clause, for example, to filter the records.
Does this help?
-
- Profound User
- Posts: 72
- Joined: Fri May 08, 2009 2:43 pm
- First Name: David
- Last Name: Esdale
- Company Name: Guardian General Insurance
- City: Port of Spain
- State / Province: Outside Canada/USA
- Country: Trinidad and Tobago
- Location: Trinidad
- Contact:
Re: Grid using a data URL
For the grid that I was hoping to create the results can not easily be created with an SQL statement. I would have to write a stored procedure (which is not something we have any experience with).
Any chance an option can be added for a data url option submitted with a get. This way I could include the required parameters in the URL?
Any chance an option can be added for a data url option submitted with a get. This way I could include the required parameters in the URL?
- David
- Profound Logic Staff Member
- Posts: 690
- Joined: Fri Jan 04, 2008 12:11 pm
- First Name: David
- Last Name: Russo
- Company Name: Profound Logic Software
- Contact:
Re: Grid using a data URL
This may be something that we can add to a future release. In the meanwhile, you could pass query string parameters and use RPGspGetQryStr() to return the full query string. It could then be parsed manually for the needed values.
Who is online
Users browsing this forum: No registered users and 1 guest