Search found 15 matches
- Fri May 13, 2022 6:57 am
- Forum: General discussion and questions about Aware IM
- Topic: Show Business space name in header
- Replies: 1
- Views: 1143
Show Business space name in header
Hi I have search the forum as well as the users guide, but can't find how to refer to the Business space name or domain variable . I want to put the value of the variable in my Top Bar header text. I know it shows in the status bar at the bottom, but we want it to be more visible for the user. Evelyn
- Wed May 04, 2022 12:44 pm
- Forum: Tips and Tricks
- Topic: How to show a table column value in a header
- Replies: 4
- Views: 15404
Re: How to show a table column value in a header
Thank you Jaymer, I ended up by like You suggested, and created a toolbar-text referring to the column <<LoggedInRegularUser.Temp_LastUpdatedFromPSDV>> The value will not refresh if the data changes in the table, so I had to add a Refresh button as well. I tried to create a process that ran every 5 ...
- Mon May 02, 2022 1:36 pm
- Forum: Tips and Tricks
- Topic: How to show a table column value in a header
- Replies: 4
- Views: 15404
How to show a table column value in a header
Hi
I have a one-row table containing status information.
How can I present a column value (status_code) from this table in a header.
I don't want to show the value using av query, it takes a lot of space.
Best regards
Evelyn
I have a one-row table containing status information.
How can I present a column value (status_code) from this table in a header.
I don't want to show the value using av query, it takes a lot of space.
Best regards
Evelyn
- Mon Apr 11, 2022 12:13 pm
- Forum: General discussion and questions about Aware IM
- Topic: aggregated calculation in a query
- Replies: 4
- Views: 1773
Re: aggregated calculation in a query
Thank you Bruce.
I think the best way will be to create a view in the database and create a BO of type existing external...
br
Evelyn
I think the best way will be to create a view in the database and create a BO of type existing external...
br
Evelyn
- Mon Apr 11, 2022 12:01 pm
- Forum: General discussion and questions about Aware IM
- Topic: How do we create a Query as Select DISTINCT ....
- Replies: 5
- Views: 2048
Re: How do we create a Query as Select DISTINCT ....
Thank you both
The Employee.Department was only an example.
I don't really have any table that the column relates to.
I've done what Bruce suggested, creating a view.
The Employee.Department was only an example.
I don't really have any table that the column relates to.
I've done what Bruce suggested, creating a view.
- Fri Apr 08, 2022 12:27 pm
- Forum: General discussion and questions about Aware IM
- Topic: aggregated calculation in a query
- Replies: 4
- Views: 1773
aggregated calculation in a query
Hi I find some old posts saying you can't use WHERE in a calculation. I want to add a calculated column to my query, telling me if there exists details for this record. I have a query fetching all Departments and I want a column that returns count(employees) belonging to the department How can I do ...
- Fri Apr 08, 2022 8:55 am
- Forum: General discussion and questions about Aware IM
- Topic: How to run a query dependent on another query
- Replies: 6
- Views: 2163
Re: How to run a query dependent on another query
Thank you Bruce
I'm not able to get the query2 to run when navigating to another record, It seems like I ned at button to fire the process.
I have created an "Operation with Records" of type "Start Process" and Default = Yes
Evelyn
I'm not able to get the query2 to run when navigating to another record, It seems like I ned at button to fire the process.
I have created an "Operation with Records" of type "Start Process" and Default = Yes
Evelyn
- Fri Apr 08, 2022 6:25 am
- Forum: General discussion and questions about Aware IM
- Topic: How do we create a Query as Select DISTINCT ....
- Replies: 5
- Views: 2048
Re: How do we create a Query as Select DISTINCT ....
Thank you Bruce
this was a cumbersome way of doing it
Evelyn
this was a cumbersome way of doing it
Evelyn
- Thu Apr 07, 2022 9:55 am
- Forum: General discussion and questions about Aware IM
- Topic: How to run a query dependent on another query
- Replies: 6
- Views: 2163
Re: How to run a query dependent on another query
Jaymer, I have now managed to see the details (query2) as you described. My only problem now is: I don't want to allow any columns to be inline edited, but as fare as I can see, at least one column must be editable in order to have the functionallity to refresh the second query by click on the recor...
- Thu Apr 07, 2022 8:24 am
- Forum: General discussion and questions about Aware IM
- Topic: How do we create a Query as Select DISTINCT ....
- Replies: 5
- Views: 2048
How do we create a Query as Select DISTINCT ....
Hi experts
How do I create a query that returns distinct values from a Business Object, as we do it the SQL way:
Select distinct DepartmentID from Employee
Is there a simular way of doing this using the FIND statement?
Best regards
Evelyn
How do I create a query that returns distinct values from a Business Object, as we do it the SQL way:
Select distinct DepartmentID from Employee
Is there a simular way of doing this using the FIND statement?
Best regards
Evelyn
- Thu Apr 07, 2022 8:08 am
- Forum: General discussion and questions about Aware IM
- Topic: How to run a query dependent on another query
- Replies: 6
- Views: 2163
Re: How to run a query dependent on another query
Thank you Jaymer! I'm not sure I understand. I've managed to see the details, but it apperars in a new window. Please see my questions below marked red. I imagine you’re using a visual perspective with content panels. Your first query is in one panel. Don’t put a second query in the other panel. But...
- Wed Apr 06, 2022 8:57 am
- Forum: General discussion and questions about Aware IM
- Topic: How to run a query dependent on another query
- Replies: 6
- Views: 2163
How to run a query dependent on another query
Hi all I hope some of you experts can explain how and the best way to run a query based on another query's highligted record (the record where the cursor points) Query1 at the left or on the top of the screen shows Departments. when moving towards the department records, Query2 to the right/or below...
- Thu Mar 03, 2022 7:10 am
- Forum: General discussion and questions about Aware IM
- Topic: Dynamically Calculated Column
- Replies: 2
- Views: 2189
Re: Dynamically Calculated Column
Thank you for the reply.
So I can't use case when ... , Replace or Decode?
So I can't use case when ... , Replace or Decode?
- Wed Mar 02, 2022 1:49 pm
- Forum: General discussion and questions about Aware IM
- Topic: Dynamically Calculated Column
- Replies: 2
- Views: 2189
Dynamically Calculated Column
Hi, I'm trying to add a simple dynamically Calculated Column on a query, but i get this eror I just want to do something like this : IF BO.ColumnName = 'xxx' then 1 else 0 How do i do this? Where can I find more about creating calculated columns and what syntax to us in the documentation or in the t...
- Tue Feb 15, 2022 9:31 am
- Forum: General discussion and questions about Aware IM
- Topic: Combo-box, dynamic choice - return another value than displayed
- Replies: 1
- Views: 1895
Combo-box, dynamic choice - return another value than displayed
Hi I have a similar issue explained in this topic: https://www.awareim.com/forum/viewtopic.php?f=4&t=1703 I want a drop-down list on a form column that lists fields from one BO dependent on a column value in the current form. Is it possible to List one value and return another value? eks list Descri...