It is currently Sun Dec 16, 2018 8:32 pm




Post new topic Reply to topic  [ 4 posts ] 
Need help with Filter Data by UserName 
Author Message

Joined: Thu Aug 07, 2008 12:39 pm
Posts: 69
Post Need help with Filter Data by UserName
I added a CustomerID column to every table, and I want to use it to filter everything based on which customer has logged-in. I have set each data page to filter on that CustomerID field.

I have a table of log-in credentials, which also as a CustomerID column. The problem is that one customer could have many users, each with a unique User ID. How can I look-up the user when they log-in and then get the CustomerID from my credentials table and put it into the UserID so that my filtering will work properly?

I have been having a heck of a time trying to figure out how to allow multiple, separate customers to use the same database.

Can anyone help?

Topher


Mon Aug 09, 2010 6:15 am
Profile E-mail

Joined: Sun Jun 07, 2009 8:54 am
Posts: 65
Post Re: Need help with Filter Data by UserName
You need Developer Edition, and Javascript, as well as a lot of custom code.

Then in the Query portion of the project you have to filter over this field.


Tue Aug 10, 2010 3:36 am
Profile E-mail

Joined: Thu Aug 07, 2008 12:39 pm
Posts: 69
Post Re: Need help with Filter Data by UserName
I have developer edition, but I don't know if I want to do the custom code.

I was hoping I could us the Filter by Username mechanism somehow. Dang.

How do people usually do this? Surely it is a common requirement?

Anyway, thanks for your help!


Tue Aug 10, 2010 6:47 am
Profile E-mail

Joined: Sun Jun 07, 2009 8:54 am
Posts: 65
Post Re: Need help with Filter Data by UserName
You can use the filter by function with a field, but when you have multiple userid's per field, then you need custom code.
No way around.


Tue Aug 10, 2010 6:51 am
Profile E-mail
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Copyright © 2004-2008 TheDevShop Ltd. All Rights Reserved