Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jpjust
Specialist
Specialist

PostgreSQL Query

Hi - I am trying to run a query like below on the qsr PostgreSQL database in pgadmin 

select * from public."LicenseProfessionalAccessTypes" , public."Users"
where public."LicenseProfessionalAccessTypes"."User_ID" = public."Users"."UserId"

But I get the following error:

ERROR: operator does not exist: uuid = character varying LINE 2: ...public."LicenseProfessionalAccessTypes"."User_ID" = public."... ^

HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. SQL state: 42883 Character: 129

Can some one please advice?

THanks

Labels (2)
1 Solution

Accepted Solutions
NadiaB
Support
Support

Hi @jpjust 

The field UserId from Users table is  varying(255) while User_ID from the licenses table is uuid, it looks you are trying to join the tables based on user id, the field from the Users table would be ID not UserId.

You can double check the values in both tables by doing a select * separately and make sure you are considering the correct fields. 

Kind Regards. 

 

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm

View solution in original post

2 Replies
Frank_S
Support
Support

Hi @jpjust,

Rather than trying to help you with your code...I am going to recommend that you use the built in license monitor (and Operations Monitor) applications which provide this type of information. 

 

If your license monitor is not working, you can solve that likely by updating the 'data connections' user account associated with each internal rest data connection found in the QMC.

For more information see point 13 in the following article:

Here is a look at just one sheet of my own vApp license monitor tool in Qlik Sense.

 

Kind regards...

 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
NadiaB
Support
Support

Hi @jpjust 

The field UserId from Users table is  varying(255) while User_ID from the licenses table is uuid, it looks you are trying to join the tables based on user id, the field from the Users table would be ID not UserId.

You can double check the values in both tables by doing a select * separately and make sure you are considering the correct fields. 

Kind Regards. 

 

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm