Aware IM User Forums

After playing with it some more it appears that the records do eventually get there, but only after much scrolling up and down. Even though it is set to 'Fetch records for all pages at once....'

I have a query that should show records that do not have a Date Closed. I am grouping these records by a CaseType. When I specify that I want the display to be Unlimited, I define the Height to be 1200. Nothing complicated so far. I should get 1200 records out of 37000. Instead I get 100. If I chang...

This is probably a dumb question, but I was wondering if there is a way to see a list of the users currently logged in to a BSV.

The reason is we would like to send a message to those users whenever we want to take the system down for period of time.

I have a process that prepares a query for a report. My report works fine with the following: FIND CaseMaster WHERE CaseMaster.DateFiled>=PromptData.DateBeginning AND CaseMaster.DateFiled<=PromptData.DateEnding ORDER BY CaseMaster.CaseTypeDescription,CaseMaster.DateFiled IN BATCHES OF 100000 DISPLAY...

Thanks Jaymer, As a side to that... Is it possible to override the location of the actual data element on the grid? So, that Yes/No or Date fields get left justified instead of centered, or a Numeric is centered instead of right justified. The column settings options that you mentioned seem to only ...

Jaymer wrote:https://www.awareim.com/forum/viewtopic ... =15#p46896

So, nothing right now, but there is hope?

I have the same question. Are there any examples of how to do this?

But apparently they only work with Derby. I use this extensively in MySql That's interesting. This is what it says in Appendix B of the User Guide: 4. The following functions are supported only in Cloudscape/Derby database: - WORD_NUMBER - WORDS_FROM_LEFT - WORDS_FROM_RIGHT I also tried this and it...

intra wrote:Maybe something along the lines of this.

FullString = John Smith

Firstname = SUBSTRING(FullString, 0,INDEX_OF(' ',FullString))
Surname = SUBSTRING(FullString, INDEX_OF(' ',FullString),LENGTH(FullString))

Thanks, that works.

ACDC wrote:

But apparently they only work with Derby.

I use this extensively in MySql

That's interesting. This is what it says in Appendix B of the User Guide:

4. The following functions are supported only in Cloudscape/Derby database:
- WORD_NUMBER
- WORDS_FROM_LEFT
- WORDS_FROM_RIGHT

I have a Full Name attribute that I want to split into FirstName and LastName attributes. I thought I could use the WORDS_FROM_LEFT or WORDS_FROM_RIGHT functions to do this. But apparently they only work with Derby.

So, I am wondering what is the easiest way to do this in Aware?

Jaymer,

That would certainly make the process more efficient.

But, is that really going to impact the ability to Cancel a running process?

Jim

In this particular case the process does the following: FIND CaseNotes WHERE CaseNotes.Note='requested discovery' AND CaseNotes.NoteType IS UNDEFINED IN BATCHES OF 1 FIND mfNoteTypes WHERE mfNoteTypes.NoteType='REQUEST FOR DISCOVERY' INSERT mfNoteTypes IN CaseNotes.NoteType Pretty basic stuff really...

In my opinion, this issue is subject to each individual application. Rennur, see below... Things to check: 1) Incorrect/faulty design/use of Business object groups. No Business Object groups defined 2) Ensure all SHOW SECTION_START, SECTION_END in document templates are properly enclosed. This does...

Is there some trick to Cancelling an Active Process? For example: I have a process that updates a certain attribute in a BO. I start the process and have it run in background after 5 seconds (Which is another topic in itself, because I don't know whose clock that 5 seconds runs on but it is more lik...