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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...