Aware IM User Forums

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

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 ...

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

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

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.

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 ...

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

Thank you Bruce
this was a cumbersome way of doing it

Evelyn

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...

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

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...

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...

Thank you for the reply.
So I can't use case when ... , Replace or Decode?

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...

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...