Page 1 of 2

Grid Data URL

Posted: Wed Jul 24, 2013 12:51 pm
by SeanTyree
Does the Data URL property of a grid support a program call in ProfoundUI the same way it does for Genie (referred to here: http://www.profoundlogic.com/docs/displ ... Genie+Grid in the documentation)?

Thanks,
Sean

Re: Grid Data URL

Posted: Wed Jul 24, 2013 12:53 pm
by David
Yes, it works in the same way for a PUI screen.

Re: Grid Data URL

Posted: Wed Jul 24, 2013 1:01 pm
by SeanTyree
Thanks David, I will try it now.

Sean

Re: Grid Data URL

Posted: Thu Jul 25, 2013 2:02 pm
by SeanTyree
Are there any examples of using a program to populate a grid. I have it working using a web service, but when I try to use a program I am getting a 404 - Not Found.

Thanks,
Sean


******
I found the problem - we have a directory match setting for programs to match the pattern PUI000*. Once I renamed the program everything worked.

Re: Grid Data URL

Posted: Thu Jul 25, 2013 2:27 pm
by Scott Klement
Sean,

Normally, a grid in Profound UI is treated as a subfile. An RPG program loops trhough a database file and writes records to the subfile. When the screen is displayed, the subfile contains the data you wrote.

But, it's also possible to load a grid by handing an SQL statement to the database -- in which case, it's loaded separately.

Or, you could use th4e 'data url' which would cause it to call a web service to populate the grid.

All of these, of course, require a program in a manner of speaking.

Re: Grid Data URL

Posted: Thu Jul 25, 2013 2:30 pm
by SeanTyree
Thanks Scott, this was using the program call functionality of the Data URL.

I wanted to compare the performance of the direct call as opposed to the call to a URL through the webservice (this would also avoid the need to modify the web server).

Thanks again,
Sean

Re: Grid Data URL

Posted: Thu Jul 25, 2013 3:27 pm
by Scott Klement
As far as I know, "program call" and "web service" are two different ways of describing what the data url does. i.e., they mean the same thing (in the context of the data url property, anyway)

Make sense?

Re: Grid Data URL

Posted: Thu Jul 25, 2013 4:18 pm
by SeanTyree
I think you are right, but the program call doesn't get any of the HTTP request information like the webservice style.

So the interface is closer to a program call then a webservice call.

Re: Grid Data URL

Posted: Thu Jul 25, 2013 5:15 pm
by Scott Klement
Sorry, I'm just not understanding what you're referring to when you say "program call". It may be a feature that I'm unfamiliar with.

How do you configure PUI to do this program call?

Re: Grid Data URL

Posted: Thu Jul 25, 2013 5:24 pm
by SeanTyree
Data URL = '/profoundui/PUI00030.pgm'

As I am testing, I realized that this functionality needs to be documented since the JSON output is the same, but without the request information that using the URL and a webservice are passed.

Also documentation regarding the passing of parameters (if available) would also help.

Thanks,
Sean