Skip navigation
95 Views 1 Reply Latest reply: May 10, 2012 2:03 PM by rivasy RSS
Apprentice 75 posts since
Apr 19, 2011

Has received 1 of 9 achievements.
Currently Being Moderated

May 10, 2012 1:26 PM

Adding a condition to SQL filter

I have created a form that contains single record field, displaying computer name that pulls data from "All assets" data list and since I want only computers, I set SQL Filter to [ALM_ASSET_BASE].[ALM_Type]=50 to ensure only computers are displayed.

 

Now my task has changed and I need to display only laptops. I know that I can use ALM_OBJ26.AM_COMPUTERTYPE field to determine whether the device is a laptop, but how do I incorporate it into the SQL Filter? I tried adding it as [ALM_ASSET_BASE].[ALM_Type]=50 AND [ALM_OBJ26].AM_COMPUTERTYPE]='Laptop' but getting an error "multipart identifier ALM_OBJ26.AM_COMPUTERTYPE could not be bound".

 

What's the best way to proceed?

 

Should I create another data list with just Laptops? if so, how do I do that?

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS® 4.5.7.1  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software