How to put where condition in views formula, while retrieving the data from columns

5 pts.
Tags:
Domino Designer
Lotus Notes
I'm new to Domino Designer, my Views record is like this:
Username            Email                               Status
abc                       abc@gmail.com              Active
xyz                        xyz@gmail.com                Active
rst                         rst@gmail.com               Inactive
I want to display usernames in a combobox in a form, where the data's will be retrieved from Views. but in the views I'm unable to pull only the usernames whose status is active.
But I 'm getting all the usernames whose status is Inactive also.
Can you please help me in retrieving only the active persons by putting the formula?


Software/Hardware used:
Lotus notes 8.5

Answer Wiki

Thanks. We'll let you know when a new response is added.

IMO, you would be better off creating a separate, hidden view that only contained the Usernames with a Status of Active.  Then, use @DBColumn to retrieve them.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • shivasanjay
    Create a view with status as sorted and categorised in the first column. then use the formula @dblookup("":"Nocache";Server:Db;"viewname";Key;column no)
    where server="" for the same database
    db="" for the same database;
    viewname is the name of the view ; 
    key ="Active";
    column no= column no. of username  ( you can make this column at column no. 2 or as your choice other than column no.1)
    with this formula you will get all the users who are active.
    hope this will help you.

    2,510 pointsBadges:
    report
  • shivasanjay
    As I suggested earlier that you can make a separate view and you can get the result.
    There is another way of doing this. you can change view formula as:
    select form="formname" & status="Active". Thus this view contains only active users. Now you can get all usernames in your @dbcolumn formula.
    2,510 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following