Hi I m facing the many times. that same formula in a field sometimes working and sometimes not. it’s not picking the value. which i changed. i’ts picking the old value.
when i go in designer remove and edit field then it started working. I m not getting why this problem come. What is the logic behind
anyone have anyidea plz tell me.
Many Thanks …
Subject: Field refresh
Hi Dee,
Whats your formula ?, on which type of field you have written ?
Rishi
Subject: RE: Field refresh
Hinot in a particular field. it happens sometimes like i was accessing the name from view. i changed the name of that means new name should come. but it was displaying the old previous. when i opened that form in designer mode and re-edited that field then that was displaying the right name. I would like to know why this type of problem happenning. What is behing this.
2nd problem like
Sub Onload(Source As Notesuidocument)
Dim view As NotesView
Dim myview As NotesView
Dim ws As New NotesUIWorkspace
Dim session As New NotesSession
Dim db As NotesDatabase
Set db = session.CurrentDatabase
Set view = db.GetView(“pendingwithapprover”)
Set myview = db.GetView(“ByInitiatorStatus”)
Dim selString As String
Dim selString1 As String
selString =“SELECT ((Form = ‘frmForexForm’)) & (@contains(@Explode(currentApprover;‘,’);'”& session.CommonUserName & “‘))|(@Contains(@Explode(siteFinanceuser;’;‘);’”& session.CommonUserName &“') & pendingatFinanceDepartment=‘1’)”
’ |(@Contains(@Explode(siteFinanceuser;‘,’);“& session.CommonUserName &”) & pendingatFinanceDepartment=‘1’))"
view.SelectionFormula =selString
Call view.Refresh()
selString1 ="SELECT ((Form = 'frmForexForm')) & (txtOriginator='" & session.CommonUserName & "' | SecName='" & Session.CommonUserName & "')"
myview.SelectionFormula = selString1
Call myview.Refresh()
End Sub
------------------------above formula i putted onload of the page. when i m accessing the view “ByInitiatorStatus” it should show my initiated doc. this is ok…now when other user are accessing the doc then he is seeing my initiated doc. when im closing and refreshing many times it’s working.
Why these all problem arising in lotus notes.
plz can u tell me
Subject: RE: Field refresh
It might be because views are not a dynamic query, they are a static index. DO NOT use shared views that way.
Subject: RE: Field refresh
HiStan As i told application is working properly.
But some times its creating problem. I m getting the value in views there are no problem. except this is not refreshing for other user.
Subject: RE: Field refresh
Right – and that’s because you are trying to use a shared view for something it is not designed to do. What you are seeing is the reason why Designer Help says you should not use @UserName in view selection or column formulas. FIND ANOTHER WAY.
Subject: RE: Field refresh
ThanksThen what to do?
===========
one other problem:
I have put the following code in field.
Its working properly. but sometimes it’s also not working. When i opened the form and re-edit new field with same formula .then its working. is there any process happed. which stored the value. how to resolve this
;;;;;;;;;;
manager:=@NameLookup([Exhaustive];@Name([CN];@UserName);“Manager”) ;
manager:=@Implode(manager;“,”);
managersManager:=@NameLookup([Exhaustive];@Name([CN];manager);“Manager”) ;
managersManager:=@Implode(managersManager;“,”);
all:=@Text(@Name([CN];manager)+“,”+@Name([CN];managersManager));
all:=@Explode(all;“,”);
all
Subject: RE: Field refresh
If it is creating a problem “sometimes” then there IS a problem!
Stan is right - you need to find another way to achieve your goal.
Subject: RE: Field refresh
ThanksDo you have any idea to do the same this?
Subject: RE: Field refresh
I might not understand the nature of what you want… But instead of a view how about a folder?
Creating a folder (I believe you need it to be private on first use) that has documents added to it based up a Search Formula against the DB.
Subject: RE: Field refresh
Hi Stephenwhen i m opening the view its showing my document. as i puttted the code onload of the page. let that you are going to open the view as per the code it will show you the document created by you. This is working but some time when you will open the view it shows my document to you.
As Stan saying that this is due to the @username
do u have any other soln.
and suffring with the field as i already posted as 4th response.
Subject: RE: Field refresh
I’m likely missing what you’re trying to do…
Seem my idea may not work as I write it out as I see a couple of problems:
What I would have happen is as you change the name (I believe anyone can do this) have an agent that runs collects the documents you want and place them in a folder.
I expect more than one person can do this at once… I’m guessing it would need to be private on first use (not sure if you can embedded a private on first use view).
If you can then display the folder instead of the embedded view. However, I’m guessing you’d still need to do a refresh on the folder when values change and given I don’t think you can refresh an embedded view / folder… You’re not better off.
Sorry, guess I wasn’t any help.
Subject: RE: Field refresh
Thanks