Skip to content
Site Tools
Narrow screen resolution Wide screen resolution Auto adjust screen size Increase font size Decrease font size Default font size default color blue color green color
Advertisement
You are here: Home arrow Forums

Newsflash

  • See the Calendar tab above for information on the NW RUG meeting on 7/24/2007 at Amazon.com at 6PM
  • You will need to register on this RemedyUserGroups site to RVSP to this meeting.
 
  • The Northwest Remedy User Group has begun moving their site content to RemedyUserGroups.com.  Welcome to the community!
 
  • The San Diego RUG has also joined our growing community!  Welcome one and all!
 
  • MWRUG has come on board and will be using this site as their portal going forward!  Welcome to you all!
 
Remedy User Groups
Welcome, Guest
Please Login or Register.    Lost Password?
Remedy User Groups General Tech Talk
Populate table field from sql query? (1 viewing) (1) Guest
Go to bottom Post Reply Favoured: 0
TOPIC: Populate table field from sql query?
#78
adg (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Populate table field from sql query? 8 Months, 2 Weeks ago Karma: 0  
Hi, I'm using 6.3 and I have a query that returns multiple rows from a non-remedy database. I want to put the results in a table field. Is there a good way to do this?

I can't figure out how to get the result of the query into the table field since the table field only seems to support displaying data from another Remedy form.

Thanks!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#79
mreinfeldt (Admin)
Admin
Posts: 19
graph
User Online Now Click here to see the profile of this user
Re:Populate table field from sql query? 8 Months, 2 Weeks ago Karma: 0  
Not possible, that I know of. What you could do, however, is create a View form to overlay the non-remedy database table, create a table-field showing data from the View Form, and use your query to filter it. Just a thought.
 
Report to moderator   Logged Logged  
 
--------------
Matt Reinfeldt
  The administrator has disabled public write access.
#80
adg (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Re:Populate table field from sql query? 8 Months, 2 Weeks ago Karma: 0  
Thanks for the suggestion! I'll give that a try in a few hours when I get to work.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#85
adg (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Re:Populate table field from sql query? 8 Months, 2 Weeks ago Karma: 0  
That worked perfectly. It took a while because I had to get the DB admin to create a view for me but after that it was a breeze. Thanks so much!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#86
mreinfeldt (Admin)
Admin
Posts: 19
graph
User Online Now Click here to see the profile of this user
Re:Populate table field from sql query? 8 Months, 2 Weeks ago Karma: 0  
I'm glad it worked out for you! Good job!
 
Report to moderator   Logged Logged  
 
--------------
Matt Reinfeldt
  The administrator has disabled public write access.
#89
adg (User)
Fresh Boarder
Posts: 9
graphgraph
User Offline Click here to see the profile of this user
Re:Populate table field from sql query? 8 Months, 1 Week ago Karma: 0  
Thanks! Now that I'm displaying data from the form view into the table, I would like to modify that data before it is displayed. Is there an way I can trigger workflow on each row when the data is loaded into the table?

Thanks again!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Powered by FireBoardget the latest posts directly to your desktop
 

Site Login

Who's Online

No Users Online

CB Gallery Module

rug pug


 

CB Workflows

You are not authorised to view this resource.
You need to login.