Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"probsummary.g" Adding a field

Status
Not open for further replies.
TudorSmith

TudorSmith

Programmer
Jan 14, 2002
245
0
0
GB
Hi All,

I'm running SC3.0 sp5

In the current "probsummary.g" screen, I have the usual fields to search against i.e. Problem#, Category, Assignment etc.

I need to perform a Mass Update and change all the "Resolved" tickets to "Closed" but this value is held in the "Problem.Status" field in the table, and guess what...this field is not available on the probsummry.g screen.

I can add the field in the format design view...and I can even bind the field to the "Problem.Status" but when I try searching against this field...nothing happens. what else do I need to do to allow me to search against Problem.Status on the probsummary.g form?

Birklea

birklea ~©¿©~ <><
Dim objJedi as Jedi.Knight
Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))
 
Sort by date Sort by votes
normally , there are some workflows behind the close function. Take care with this . What you can do , select from db manager your normal close format , options advanced query : last=true and problem.status=&quot;Resolved&quot; . After this run the mass update. Normally the fields in the probsummary are automatically updated

bye
 
Upvote 0 Downvote
I got it to work!

I had the input for the field set as &quot;Problem.Status&quot; but of course I had type this in free-hand when I was in the format design view.

To fix it I actually used the combo-box and you know what, by selecting &quot;problem.status&quot; (note the case!) it worked.

Thaks for your input though

birklea

birklea ~©¿©~ <><
Dim objJedi as Jedi.Knight
Set objJedi[skyWalker].Aniken = FatherOf(useThe.Force(objJedi[skyWalker].luke))
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jflarente
  • Locked
  • Question
changing controls on a wizard page at &quot;runtime&quot;
Replies
1
Views
90
Jasonic
Jasonic
Bunis
  • Locked
  • Question
Peregrine Asset Center - Asset ID assignment problem
Replies
0
Views
270
Bunis
Bunis
jlouiett
  • Locked
  • Question
Link to Update Problem from Probsummary Field?
Replies
0
Views
53
jlouiett
jlouiett
makots9
  • Locked
  • Question
How do I close a ticket in Servicecenter?
Replies
3
Views
104
chrishaw
chrishaw
phoenixshads
  • Locked
  • Question
Expert searches for blank fields
Replies
1
Views
94
chrishaw
chrishaw

Part and Inventory Search

Sponsor

Back
Top