PostgreSQL Query

[jpjust]

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

[Frank_S]

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:

• https://community.qlik.com/t5/Official-Support-Articles/How-to-troubleshoot-and-resolve-reload-and-t...

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

Kind regards...

[NadiaB · Accepted solution]

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.