Custom Property Sets - Data from other databases

General questions and answers about infoRouter EDMS

Moderator: infoRouter Guru

Post Reply
Data

Custom Property Sets - Data from other databases

Post by Data » Sat Aug 08, 2009 6:54 pm

I would like to create a drop down field to present the user with a list of options. In my case the options are not static. Can I retrieve them from a DB other than the inforouter database every time a user is presented with the options?

User avatar
infoRouter Guru
Posts: 230
Joined: Fri Aug 07, 2009 8:46 pm

Re: Custom Property Sets - Data from other databases

Post by infoRouter Guru » Mon Sep 07, 2009 2:59 am

Easy!
All you have to do is create a field in a custom property. Be sure to create the type as "lookup".
Click on the field properties icon to specify the Database/Table/SQL settings.

Remember to be careful when you create the SQL statement. As my good friend Ray Petrone says:
The problem is always in the where clause
Lookup.jpg
Lookup.jpg (129.25 KiB) Viewed 10619 times
Hope this helps.

The Guru.

tengiz
Posts: 2
Joined: Wed Sep 30, 2009 2:13 pm

Re: Custom Property Sets - Data from other databases

Post by tengiz » Thu Aug 12, 2010 9:09 am

hello

can i use in sql statment value of other lookup field?
exampl:
AAA field type lookup
BBB field type lookup and SQL is { Select Name from Company where CompId= AAA field value }

User avatar
infoRouter Guru
Posts: 230
Joined: Fri Aug 07, 2009 8:46 pm

Re: Custom Property Sets - Data from other databases

Post by infoRouter Guru » Fri Sep 03, 2010 4:20 am

As far as I know, it should work. Just get the where clause to work.

tengiz
Posts: 2
Joined: Wed Sep 30, 2009 2:13 pm

Re: Custom Property Sets - Data from other databases

Post by tengiz » Tue Sep 07, 2010 3:44 am

hello,

can you give me some example?

Post Reply

Return to “General Questions & Issues About infoRouter EDMS”

Who is online

Users browsing this forum: No registered users and 17 guests