Aware IM User Forums

I'm not sure why the LIMIT switch is a non-starter since the values can be expressions whereas TAKE BEST required a literal integer. From the documentation example: If this construct is used after the FIND action, only the specified rows will be returned. The first parameter indicates the first row ...

Are the number to be returned limited enough that you can IF your way through it?

IF SomeChoice = 1 THEN
Query Take Best 1
ELSIF SomeChoice=2 THEN
Query Take Best 2
etc...

Here's the online documentation: https://www.awareim.com/dokuwiki/doku.p ... redirect=1

Put this in the update rules for the JobStatus object:

IF OLD_VALUE(JobStatus.JobStatus) = 'Pending' AND JobStatus.JobStatus WAS CHANGED THEN
REPORT ERROR 'Cannot change the value of Pending status'

Awesome. Very glad to help.

Maybe try the LIMIT option?

FIND Account WHERE Account.State = 'OPEN' AND Account.Balance > 1000 LIMIT 20,3

Hi Harry, In the JobStatus business object, there are update rules and delete rules. In the delete rule, make the following rule: If JobStatus.JobStatus=‘Pending’ Then Report Error ‘Cannot delete Pending status’ This should do it. If not, please DM me and I will be happy to set up a Google meet of s...

Oh. Then try a delete business rule on the JobStatus object.

If JobStatus.JobStatus=‘Pending’ Then
Report Error ‘Cannot delete Pending status’

Refer to the docs on using Protect statements. I think you need to say:

Protect JobStatus.JobStatus FROM ALL

Or

Protect JobStatus.JobStatus FROM [Access Level]

Or

Protect JobStatus.JobStatus FROM ALL Except [Access Level]

Your parentheses are out of balance. I believe you can remove the first ( after IF.

The last part should refer to just the business object i. e.,

AND NOT (JobStatus IS NEW)

I suggest a Protect Rule

If Objects.Status='Pending' THEN
Protect Object.Status

On the second issue, it's similar:

If Objects.Status='Pending' AND NOT (Object IS NEW) THEN
Protect Object.Status

The second rule is really all you need.

I'm looking a MS Surface or Surface laptop running an ARM Snapdragon processor. Any idea if AwareIM will run on it or not?

Take a look at the UNSENT_EMAIL folder. I purge that folder all the time. I have no theory that it's causing the issue but it's something you can try.

I need to give users the ability to filter a query and see the results. There may be several pages in the results. Then I need to process the query results without having them select all on each page of the query. Is there a way to get the current filtered query and use it in a process?

Update: Instead of trying to download multiple zipped files and created a single zip file with a file directory and structure.