Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a program that list all users connected to our alarmcenter and their contact person. The user and the contact persons information seems to be located in 2 seperate databases (database tables) and when i import it into clickviewer i cant seem to get all the information into a table box the way i want. What i end up with is the contact information shows up after the user information like this.
User | Phone | Contact |
---|---|---|
User 1 | Phone 1 | |
User 2 | Phone 2 | |
Contact 1 | ||
Contact 2 |
But what i need is more like this
User | Phone | Contact |
---|---|---|
User 1 | Phone 1 | Contact 1 |
User 2 | Phone 2 | Contact 2 |
Hope you understand what i want, and that someone can help
This is how my script looks like now
DBC CONNECT TO triggerII;
LOAD Address,
AlarmCode,
"Department_Name",
DoorCode,
FirstName,
ImportantInformation,
Information,
KeyInformation,
LastName,
ProtectedIdentity,
RoadDescription,
Sex,
SSN;
SQL SELECT Address,
AlarmCode,
"Department_Name",
DoorCode,
FirstName,
ImportantInformation,
Information,
KeyInformation,
LastName,
ProtectedIdentity,
RoadDescription,
Sex,
SSN
FROM TriggerII.dbo."VIEW_KundUppgifter";
LOAD FirstName AS FirstName2,
LastName AS Lastname2,
Notes,
Phone AS Phone2,
RelationTypeText;
SQL SELECT FirstName,
LastName,
Notes,
Phone,
RelationTypeText
FROM TriggerII.dbo.viewPersonRelations;