Grid Data URL

Use this board to ask questions or have discussions with other Rich Displays users.
SeanTyree
Profound User
Posts: 76
Joined: Fri Jan 11, 2013 6:11 pm
First Name: Sean
Last Name: Tyree
Company Name: US HealthWorks
State / Province: California
Zip / Postal Code: 91355
Country: United States
Contact:

Grid Data URL

Post 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
User avatar
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 Data URL

Post by David »

Yes, it works in the same way for a PUI screen.
SeanTyree
Profound User
Posts: 76
Joined: Fri Jan 11, 2013 6:11 pm
First Name: Sean
Last Name: Tyree
Company Name: US HealthWorks
State / Province: California
Zip / Postal Code: 91355
Country: United States
Contact:

Re: Grid Data URL

Post by SeanTyree »

Thanks David, I will try it now.

Sean
SeanTyree
Profound User
Posts: 76
Joined: Fri Jan 11, 2013 6:11 pm
First Name: Sean
Last Name: Tyree
Company Name: US HealthWorks
State / Province: California
Zip / Postal Code: 91355
Country: United States
Contact:

Re: Grid Data URL

Post 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.
Last edited by SeanTyree on Thu Jul 25, 2013 2:28 pm, edited 1 time in total.
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Grid Data URL

Post 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.
SeanTyree
Profound User
Posts: 76
Joined: Fri Jan 11, 2013 6:11 pm
First Name: Sean
Last Name: Tyree
Company Name: US HealthWorks
State / Province: California
Zip / Postal Code: 91355
Country: United States
Contact:

Re: Grid Data URL

Post 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
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Grid Data URL

Post 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?
SeanTyree
Profound User
Posts: 76
Joined: Fri Jan 11, 2013 6:11 pm
First Name: Sean
Last Name: Tyree
Company Name: US HealthWorks
State / Province: California
Zip / Postal Code: 91355
Country: United States
Contact:

Re: Grid Data URL

Post 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.
Scott Klement
Experienced User
Posts: 2711
Joined: Wed Aug 01, 2012 8:58 am
First Name: Scott
Last Name: Klement
Company Name: Profound Logic
City: Milwaukee
State / Province: Wisconsin

Re: Grid Data URL

Post 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?
SeanTyree
Profound User
Posts: 76
Joined: Fri Jan 11, 2013 6:11 pm
First Name: Sean
Last Name: Tyree
Company Name: US HealthWorks
State / Province: California
Zip / Postal Code: 91355
Country: United States
Contact:

Re: Grid Data URL

Post 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
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 1 guest