Hello!
I have a problem with Query that I saved previously and Query Editor functionality:
- Every time I open my Query in Query Editor and try to make even small changes (Delete the default buttons or Operations) it seems like the actual code of the query gets modified by the system so that I have to correct it and put my original Query code back. At the same time the
"Simple Form" of the Query stays unchanged.
- If I switch tabs "Simple Form", "Rule Form" and "SQL Form" the actual
Query code also gets modified by the System without any warnings, etc.
My questions are:
1. Is it the normal behaviour of the Query Editor?
2. If it is normal then how should I work with the Editor correctly so that
I won't loose the query code that has been already developed and saved?
3. Maybe there is something wrong with my Aware IM installation and I need to reinstall it?
Thank you in advance!
Angarato.
Problem with previously saved Query and Query Editor.
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
The following steps give me the problem described:
1. Create new Query - "Test"
2. Select Look for: "BObject1"
3. Switch to "Rule Form" Tab.
4. Enter: "FIND BObject1 WHERE TO_UPPER_CASE(BObject1.Description) CONTAINS TO_UPPER_CASE(BObject2.Keyword)"
5. Click "Create" and then "Save" buttons.
6. Perform "Update and keep Locked" of Business Space.
7. Switch to the "Simple Form" tab and see "FIND ALL BObject1" query
instead of query entered in p.4 and saved in pp.5,6.
Thanks,
Angarato.
1. Create new Query - "Test"
2. Select Look for: "BObject1"
3. Switch to "Rule Form" Tab.
4. Enter: "FIND BObject1 WHERE TO_UPPER_CASE(BObject1.Description) CONTAINS TO_UPPER_CASE(BObject2.Keyword)"
5. Click "Create" and then "Save" buttons.
6. Perform "Update and keep Locked" of Business Space.
7. Switch to the "Simple Form" tab and see "FIND ALL BObject1" query
instead of query entered in p.4 and saved in pp.5,6.
Thanks,
Angarato.
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Thank you for the new build! However, my first impression is that it still didn't fix the problem:
1.Create query test
2.Go to the Rule Form tab
3.Create statement like: "Find Bo1 where bo1.attribute1 contains tempbo2.attribute1 and bo1.attribute2 contains tempbo2.attribute2"
4.Click on create, save, update business space and keep locked
5.Go to the simple rule tab and back to rule form tab.
6.Watch how you query Statement changed!
Angarato.
1.Create query test
2.Go to the Rule Form tab
3.Create statement like: "Find Bo1 where bo1.attribute1 contains tempbo2.attribute1 and bo1.attribute2 contains tempbo2.attribute2"
4.Click on create, save, update business space and keep locked
5.Go to the simple rule tab and back to rule form tab.
6.Watch how you query Statement changed!
Angarato.
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Yes, I have a latest version. However I noticed that if after swithing to the rule form tab and noticing the default (modified by the system query) I try to close the whole configuration tool it will ask me if I want to save my query. If I say 'No' and then after shut down of the Configuration tool start it all over again, the query statement gets back to my code. I don't belive my eyes! As to me it is a very strange and suspicious behaviour of the query editor.
Thanks.
Thanks.
-
- Posts: 7526
- Joined: Sun Apr 24, 2005 12:36 am
- Contact: