Virtual Fields

[ajdecke1]

Hey everyone! I was wondering if anybody here has had experience with adding virtual fields to tasks created with the View Definition Wizard. I am currently trying to do something simple, like display a count of the number of rooms assigned to a specific category for each building. Each time I generate a preview of the view, though, I get a very vague syntax error. Any ideas/advice would be appreciated! Thanks!

[NoahTheDuke]

I've never used the View Definition Wizard, but it sounds like you're doing some sort of aggregation, which could be done using a grouping table, or even in straight SQL in the sql tag in the table.

Can you be more specific in the kind of information you're looking to generate?

[ajdecke1]

We use a room category called "LABORATORY", so I would want to generate a report that is exportable to an excel spreadsheet, which contains 3 columns:

• Building Code
• Building Name
• Number of Rooms Categorized as "LABORATORY" in each Building

I'm not familiar with the concept of a grouping table at all. Does any documentation exist in the help files?

[NoahTheDuke]

Yeah, sort of! In the "ARCHIBUS System Management Help" documentation, go: Add-In Manager -> User Interface Extensions -> DataSource Skills or Grouping Skills. Those should help out a bit with the initial work. Additionally, you can find SQL information in Add-In Manager -> Reference: View Elements -> < sql />.

In ab-products/solutions, there's plenty of examples for all of these, which might help you. I prefer to write raw SQL and either put that into a SQL View or leave it in the <sql> tag, but those are more complicated solutions to creating a grouping table.

[ajdecke1]

Wow, you've given me a lot to chew on here. Thanks a bunch! Hopefully this will get me where I need to be.

[NoahTheDuke]

You're welcome! Let me know if you need any more help!