Hi Jolee,
your query should look like this:
FIND Client WHERE EXISTS Property WHERE (Property IN Client.System.Properties AND EXISTS IPU WHERE (IPU IN Property.IPUs AND IPU.Lic.Finish_Date IS DEFINED))
Hope this helps.
Search found 7527 matches
- Tue Nov 15, 2005 4:14 am
- Forum: General discussion and questions about Aware IM
- Topic: Queries in Aware
- Replies: 14
- Views: 45105
- Mon Nov 14, 2005 11:28 pm
- Forum: General discussion and questions about Aware IM
- Topic: Status Bar in Firefox
- Replies: 1
- Views: 7943
- Mon Nov 14, 2005 11:24 pm
- Forum: General discussion and questions about Aware IM
- Topic: Queries in Aware
- Replies: 14
- Views: 45105
Hi Jolee, can you tell me exactly what objects and attributes you have in your example, how they are related and what you are trying to find? In general, the example I described indeed works for one-to-one relationships. If you want to use many-to-many relationships you have to use "IN" expression, ...
- Mon Nov 14, 2005 12:11 pm
- Forum: General discussion and questions about Aware IM
- Topic: Configuration Tool connection issue
- Replies: 1
- Views: 7837
- Mon Nov 14, 2005 12:10 pm
- Forum: Problem reports
- Topic: Problems connecting to Hosted Aware IM Server
- Replies: 9
- Views: 12817
Hi, I need to ask you a few questions: 1) When installing the Configuration Tool on a workstation did you specify the correct name of your server? You can double check it by inspecting the "HostServer" property in the uiconfig.props file located in the BIN directory of your Configuration Tool instal...
- Fri Nov 11, 2005 6:57 am
- Forum: Problem reports
- Topic: Importing CSV file
- Replies: 2
- Views: 8567
- Fri Nov 11, 2005 1:59 am
- Forum: Problem reports
- Topic: Importing CSV file
- Replies: 2
- Views: 8567
You should enclose the data that have embedded commas into quotation mark symbols, for example: "my data1, mydata2", "mydata3, mydata4", ... Aware IM should be able to read data in this format. This is also the format that most programs, such as Excel, will export the data in, when the data has embe...
- Wed Nov 09, 2005 11:17 pm
- Forum: General discussion and questions about Aware IM
- Topic: Queries in Aware
- Replies: 14
- Views: 45105
- Wed Nov 09, 2005 11:15 pm
- Forum: General discussion and questions about Aware IM
- Topic: Queries in Aware
- Replies: 14
- Views: 45105
Hi Jolee, not sure if I understood the question correctly, but let me try to answer anyway. If you have a chain of linked objects from A to E you can use dot notation to query on any of the objects in a chain. For example, let's say has as attribute BRef that points to B, B has attribute CRef that p...
- Thu Nov 03, 2005 11:39 pm
- Forum: Problem reports
- Topic: Restriction on apostrophe use
- Replies: 1
- Views: 6699
- Wed Sep 28, 2005 8:38 am
- Forum: General discussion and questions about Aware IM
- Topic: Default form settings
- Replies: 1
- Views: 7720
- Tue Sep 27, 2005 2:31 am
- Forum: Problem reports
- Topic: AwareIM "number" => SQLServer data type problem
- Replies: 1
- Views: 7404
- Fri Sep 23, 2005 1:08 am
- Forum: General discussion and questions about Aware IM
- Topic: currency format
- Replies: 8
- Views: 21708
We have just discovered a simpler and nicer work around: rather than adding a condition to the SUM expression in the Title band, leave the expression as is, select it, open the property dialog, click on the "Evaluation Time" button. In the dialog that appears make sure that "At the end of the report...
- Fri Sep 23, 2005 12:37 am
- Forum: General discussion and questions about Aware IM
- Topic: Connection error with form preview
- Replies: 8
- Views: 22128
Please add the following line to your UIConfig.props file (or change the existing setting if already there):
OperationMode=http://r2053ws001548:8080/AwareIM/logon.jsp
(this includes the name of your web server instead of the default localhost)
OperationMode=http://r2053ws001548:8080/AwareIM/logon.jsp
(this includes the name of your web server instead of the default localhost)
- Thu Sep 22, 2005 12:27 pm
- Forum: General discussion and questions about Aware IM
- Topic: currency format
- Replies: 8
- Views: 21708
The fact that it doesn't work when placed in the Title section is a bug. There is a workaround though. Add the condition to the SUM expression that is guaranteed to return true, for example: 'SUM PurchaseOrder.TotalCost WHERE(PurchaseOrder.TotalCost>0),$#,##0.00' This will work even if placed in the...