Jump to content
Npprojects

Custom Tabs - Dataview

Recommended Posts

Hello All,

 

Does anybody know the 'Additional Where' parameter to get the dataviews within Custom Tabs to only show that client's results?

 

I've tried 'Clients.Name = '%clientname%' and various other queries but I'm very new to SQL

 

Any help would be appreciated!

 

The Custom Tab is on the Device field

 

Thank you

Share this post


Link to post
Share on other sites

The first post in the Custom Tabs mentions:

Dataview is a LabTech Dataview. You select the dataview to show and optionally you enter the additional Where. The additional Where is used to limit the dataview to show only the items you want, an example would be "Clients.ClientID=%ClientID%". You can use the replacements here as well.

A couple of posts down, it also mentions:

Tips:

Replacements are available, Press F2

Use Command Execute and use "Message:" as the Program, It will pop up a messagebox with the arguments replaced with variables, this helps in testing.

Its @ID@ for the ID of the item you are on(client,computer,etc)

So if "Clients.ClientID=%ClientID%" didn't work, you might try "Clients.ClientID=@ID@".

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×