> Steve, > > This might be off-topic, but there's really not a good forum > for "general webapp what-the-heck-is-going-on discussion". > But hey, we're nice folks ;) > > Steve Ingraham wrote: > > If no person is assigned to the case the phrase "NO > ASSIGNMENT" shows > > up on the front page of the application where the person's > name should > > have been and there is no record created in the ASSIGN table in the > > MySQL database for the case and subsequently no ASSIGN.ID > that shows > > up in the web browser for that case. > > Okay. > > > I am attempting to create a report that will return all instances > > where a person has not been assigned to a case. There is nothing in > > the database in any fields that the NO ASSIGNMENT phrase is related > > to > > This is not surprising. I'll bet that the code looks for an > assignment and, finding none, displays this message. > > > I have been trying to track down within the code for the web page > > where this NO ASSIGNMENT phrase is coming from in hopes of > > understanding how the application knows to return this > statement. My > > theory is that if I can see how the application is > returning this I > > can figure out how to query the database to show me all instances > > where this has occurred. > > This sounds reasonable. Unfortunately, web application can > grow to significant complexity, and sometimes things like > strings displayed in a page can come from unlikely sources. > Are you familiar with Java at all? That might be helpful for > your forensic reconstruction, here. > > > Can someone give me some direction on where I can search for this > > type of code? > > Well, it's unlikely that the phrase "NO ASSIGNMENT" will > appear in any of your Java source code (that is, files with > the ".java" extension). You're more likely to find it in > either a JSP file (ending in ".jsp") or in a properties file > (ending in ".properties"). > > You can search everything on a UNIX system using something > similar to the following: > > $ grep -l "NO ASSIGNMENT" `find /path/to/application -type f` > > (Note the use of back ticks). > > This will display a list of files that contain that phrase. > > > <a > > > href="/occa/model.do?model=oscn.seq.prompt-Assignment&assi > gnType=1&a > > mp;data=95972&caseMasterId=95972"> NO ASSIGNMENT</a> > > Can you determine which file generated this output? Usually > Java web applications will use JSP or some other technology > to generate the actual HTML that the user sees. By locating > the file that generates this output, you can probably figure > out how the decision is made that there is no judicial assignment. > > Otherwise, you'll have to start searching through code and > basically backtrack through the process. > > I can probably take a stab at a query that might work. You > mentioned that you have tables like this (well, I'm guessing > for most of this) > > CASE > - ---- > id > > ASSIGN > - ------ > case_id (points to case.id?) > id (points to assignee.id?) > > If an assigned case has a record in the ASSIGN table, then an > unassigned case would probably have /no/ records in the ASSIGN table. > > You could find those cases using a query like this: > > SELECT case.id > FROM case > LEFT OUTER JOIN assign ON assign.case_id=case.id > WHERE assign.id IS NULL > > This should pull all CASE records who have no matching ASSIGN > records in the database. > > Just a thought, but I have /no/ idea how your database is > laid out or if there's a better way to do this. > > > If this question is better answered outside the Tomcat community > > please let me know and I will not waste your time any > further. Thank > > you in advance for any assistance you can provide. > > This list typically deals with Tomcat-specific issues, but, > as I said, there's no really good forum for asking for this > type of thing. Just leave "OT" in the subject line and you'll > generally be forgiven ;) > > - -chris
Chris, I appreciate your detailed help with this off topic issue. You have been very helpful. To answer your question about my Java experience, I do not know much at all. I have started a Java for beginners class this January that I am taking online and I am attempting to work through the O'Reilley book "Learning Java" on my own. I am a little overwhelmed but trying to understand it all. I appreciate the fact that this was not a Tomcat issue but I knew you guys were a lot smarter than I on these topics. I was confident you guys could help. I will take your advice in searching for the code for NO ASSIGNMENT. This application is residing on a RedHat AS 3 server so I will try the command you recommended. I have to say that your recommended query was the advice that helped more than anything else. I ultimately have been trying to figure out how the NO ASSIGNMENT data was returning in hopes of figuring out how to query for these records in the database. Your select statement was just what I needed to jumpstart my brain. If you are familiar with Crystal Reports at all I have been attempting to query the database in that application without success. I have a terrible time sometimes getting CR to do some things and this was turning out to be one of them. When I wrote the SQL query in the MySQL Query Browser (with the appropriate table names of course) I got the returns I needed. Again thank you so much for taking the time out of your busy day to offer this information up. It has been very very helpful and greatly appreciated. Steve --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
