Search found 1642 matches
- Fri May 31, 2024 4:30 pm
- Forum: General discussion and questions about Aware IM
- Topic: Variable TAKE BEST
- Replies: 9
- Views: 160
Re: Variable TAKE BEST
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 ...
- Fri May 31, 2024 4:08 pm
- Forum: General discussion and questions about Aware IM
- Topic: Variable TAKE BEST
- Replies: 9
- Views: 160
Re: Variable TAKE BEST
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...
IF SomeChoice = 1 THEN
Query Take Best 1
ELSIF SomeChoice=2 THEN
Query Take Best 2
etc...
- Fri May 31, 2024 4:00 pm
- Forum: General discussion and questions about Aware IM
- Topic: Prevent a dropdown choice from being edited or deleted.
- Replies: 15
- Views: 264
Re: Prevent a dropdown choice from being edited or deleted.
Here's the online documentation: https://www.awareim.com/dokuwiki/doku.p ... redirect=1
- Fri May 31, 2024 3:06 pm
- Forum: General discussion and questions about Aware IM
- Topic: Prevent a dropdown choice from being edited or deleted.
- Replies: 15
- Views: 264
Re: Prevent a dropdown choice from being edited or deleted.
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'
IF OLD_VALUE(JobStatus.JobStatus) = 'Pending' AND JobStatus.JobStatus WAS CHANGED THEN
REPORT ERROR 'Cannot change the value of Pending status'
- Thu May 30, 2024 7:58 pm
- Forum: General discussion and questions about Aware IM
- Topic: Prevent a dropdown choice from being edited or deleted.
- Replies: 15
- Views: 264
Re: Prevent a dropdown choice from being edited or deleted.
Awesome. Very glad to help.
- Thu May 30, 2024 7:55 pm
- Forum: General discussion and questions about Aware IM
- Topic: Variable TAKE BEST
- Replies: 9
- Views: 160
Re: Variable TAKE BEST
Maybe try the LIMIT option?
FIND Account WHERE Account.State = 'OPEN' AND Account.Balance > 1000 LIMIT 20,3
FIND Account WHERE Account.State = 'OPEN' AND Account.Balance > 1000 LIMIT 20,3
- Thu May 30, 2024 7:51 pm
- Forum: General discussion and questions about Aware IM
- Topic: Prevent a dropdown choice from being edited or deleted.
- Replies: 15
- Views: 264
Re: Prevent a dropdown choice from being edited or deleted.
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...
- Thu May 30, 2024 5:32 pm
- Forum: General discussion and questions about Aware IM
- Topic: Prevent a dropdown choice from being edited or deleted.
- Replies: 15
- Views: 264
Re: Prevent a dropdown choice from being edited or deleted.
Oh. Then try a delete business rule on the JobStatus object.
If JobStatus.JobStatus=‘Pending’ Then
Report Error ‘Cannot delete Pending status’
If JobStatus.JobStatus=‘Pending’ Then
Report Error ‘Cannot delete Pending status’
- Thu May 30, 2024 12:59 pm
- Forum: General discussion and questions about Aware IM
- Topic: Prevent a dropdown choice from being edited or deleted.
- Replies: 15
- Views: 264
Re: Prevent a dropdown choice from being edited or deleted.
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]
Protect JobStatus.JobStatus FROM ALL
Or
Protect JobStatus.JobStatus FROM [Access Level]
Or
Protect JobStatus.JobStatus FROM ALL Except [Access Level]
- Thu May 30, 2024 5:29 am
- Forum: General discussion and questions about Aware IM
- Topic: Prevent a dropdown choice from being edited or deleted.
- Replies: 15
- Views: 264
Re: Prevent a dropdown choice from being edited or deleted.
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)
The last part should refer to just the business object i. e.,
AND NOT (JobStatus IS NEW)
- Wed May 29, 2024 11:36 pm
- Forum: General discussion and questions about Aware IM
- Topic: Prevent a dropdown choice from being edited or deleted.
- Replies: 15
- Views: 264
Re: Prevent a dropdown choice from being edited or deleted.
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.
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.
- Tue May 21, 2024 8:17 pm
- Forum: General discussion and questions about Aware IM
- Topic: AwareIM on Snapdragon
- Replies: 0
- Views: 182
AwareIM on Snapdragon
I'm looking a MS Surface or Surface laptop running an ARM Snapdragon processor. Any idea if AwareIM will run on it or not?
- Wed May 15, 2024 6:23 pm
- Forum: General discussion and questions about Aware IM
- Topic: Using <<bo.attribute>> in notifications
- Replies: 1
- Views: 147
Re: Using <<bo.attribute>> in notifications
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.
- Mon May 06, 2024 3:01 pm
- Forum: General discussion and questions about Aware IM
- Topic: How to process records from a filtered query without picking the records
- Replies: 0
- Views: 177
How to process records from a filtered query without picking the records
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?
- Sat Apr 13, 2024 11:13 pm
- Forum: General discussion and questions about Aware IM
- Topic: Process Applicable to Multiple in query
- Replies: 2
- Views: 796
Re: Process Applicable to Multiple in query
Update: Instead of trying to download multiple zipped files and created a single zip file with a file directory and structure.