Can dropdowns be populated via SQL statements with Profound?

Use this board to ask questions or have discussions with other Rich Displays users.
Post Reply
dwrightgrinch
New User
Posts: 4
Joined: Mon Aug 01, 2011 1:10 pm
First Name: Donna
Last Name: Wright Walsh
Company Name: Genuine Parts Company
Phone: 770 850 2419
Address 1: 3100 Windy Hill Road
City: Atlanta
State / Province: Georgia
Zip / Postal Code: 30039
Country: United States
Contact:

Can dropdowns be populated via SQL statements with Profound?

Post by dwrightgrinch »

We have a SQL statement (that I thought could be used instead of doing within RPG SQL stmt) we want to use to populate a dropdown. Can this be done within a function/selection of ProfoundUI where there is no SQL stmt put in the RPG code? I don't want to do this with javascript either. If so, how would this be done?

Here's the SQL stmt:
Select b.cddesc fROM MAPGP as A join SYCDP as B on a.pgpgcd
=b.cdcode where a.pgpcd = 'NA' and b.sysys = 'MA' and b.cdtype =
'PROG' and a.pgtype = ' ' order by b.cddesc

Thanks, Donna Wright Walsh
GPC 770 850 2419
User avatar
Brian
Profound Logic Staff Member
Posts: 286
Joined: Thu Apr 14, 2011 10:23 am
First Name: Brian
Last Name: May
Company Name: Profound Logic Software
Contact:

Re: Can dropdowns be populated via SQL statements with Profound?

Post by Brian »

That statement contains a join which our Database-Driven Selection will not support directly. However, you could create an SQL view from that select statement and then use the view for the Database-Driven Selection parameters.
Post Reply

Who is online

Users browsing this forum: No registered users and 9 guests