Solved

which view has details of base profile


Userlevel 2
Badge +4

Please help how to find details of base profile in back end .. i cant see any views in system info

 

icon

Best answer by Charith Epitawatta 8 June 2021, 19:13

Hi @proharikg,

Hi Charith,

I can only find Profile ID in this table , could you please help me to find the base profile name which is associated with these id’s

If all you need is just the base profile IDs and their names, then following query mentioned in @dsj’s reply is the easiest way to do that. 

Base profiles can be identified using following query

select * from CLIENT_PROFILE where owner is null

 

I should also highlight that a certain profile appears in FNDRR_USER_CLIENT_PROFILE_TAB only if it is assigned to a user. Otherwise it will not show up here. So to list down all base profiles, regardless of whether they are assigned to a user or not, above query is more accurate.

You can JOIN these tables as necessary using the Profile_ID column to fetch any other data you need since it is common to them all.

Hope this helps!

View original

6 replies

Userlevel 7
Badge +15

Base profiles can be identified using following query

select * from CLIENT_PROFILE where owner is null

 

Base profile values:

select p.profile_id, p.profile_name,
       pv.profile_id,
       pv.profile_section,
       pv.profile_entry,
       pv.profile_value,
       pv.profile_binary_value   
       from CLIENT_PROFILE p, CLIENT_PROFILE_VALUE pv
where p.owner is null
and p.profile_id = pv.profile_id

 

Cheers!

Damith

Userlevel 6
Badge +11

Hi @proharikg,

You can use following tables.

  • FNDRR_USER_CLIENT_PROFILE_TAB
  • FNDRR_CLIENT_PROFILE_TAB
  • FNDRR_CLIENT_PROFILE_VALUE_TAB

In FNDRR_USER_CLIENT_PROFILE_TAB, you would ideally see 3 profiles per user and you can identify which is which using the value in ‘ORDINAL’    column. 

Ordinal 0 - current personal profile

Ordinal 1 - current base profile

Ordinal 9 - IFS Standard profile, which is assigned by the system the first time a user logs into the application. 

Hope this helps!

Userlevel 2
Badge +4

Hi @proharikg,

You can use following tables.

  • FNDRR_USER_CLIENT_PROFILE_TAB
  • FNDRR_CLIENT_PROFILE_TAB
  • FNDRR_CLIENT_PROFILE_VALUE_TAB

In FNDRR_USER_CLIENT_PROFILE_TAB, you would ideally see 3 profiles per user and you can identify which is which using the value in ‘ORDINAL’    column. 

Ordinal 0 - current personal profile

Ordinal 1 - current base profile

Ordinal 9 - IFS Standard profile, which is assigned by the system the first time a user logs into the application. 

Hope this helps!

Hi Charith,

I can only find Profile ID in this table , could you please help me to find the base profile name which is associated with these id’s

 

Thanks in advance

Userlevel 6
Badge +11

Hi @proharikg,

Hi Charith,

I can only find Profile ID in this table , could you please help me to find the base profile name which is associated with these id’s

If all you need is just the base profile IDs and their names, then following query mentioned in @dsj’s reply is the easiest way to do that. 

Base profiles can be identified using following query

select * from CLIENT_PROFILE where owner is null

 

I should also highlight that a certain profile appears in FNDRR_USER_CLIENT_PROFILE_TAB only if it is assigned to a user. Otherwise it will not show up here. So to list down all base profiles, regardless of whether they are assigned to a user or not, above query is more accurate.

You can JOIN these tables as necessary using the Profile_ID column to fetch any other data you need since it is common to them all.

Hope this helps!

Userlevel 2
Badge +4

Base profiles can be identified using following query

select * from CLIENT_PROFILE where owner is null

 

Base profile values:

select p.profile_id, p.profile_name,
       pv.profile_id,
       pv.profile_section,
       pv.profile_entry,
       pv.profile_value,
       pv.profile_binary_value   
       from CLIENT_PROFILE p, CLIENT_PROFILE_VALUE pv
where p.owner is null
and p.profile_id = pv.profile_id

 

Cheers!

Damith

Base profiles can be identified using following query

select * from CLIENT_PROFILE where owner is null

 

Base profile values:

select p.profile_id, p.profile_name,
       pv.profile_id,
       pv.profile_section,
       pv.profile_entry,
       pv.profile_value,
       pv.profile_binary_value   
       from CLIENT_PROFILE p, CLIENT_PROFILE_VALUE pv
where p.owner is null
and p.profile_id = pv.profile_id

 

Cheers!

Damith

Thank you so much ..

Userlevel 2
Badge +4

Hi @proharikg,

Hi Charith,

I can only find Profile ID in this table , could you please help me to find the base profile name which is associated with these id’s

If all you need is just the base profile IDs and their names, then following query mentioned in @dsj’s reply is the easiest way to do that. 

Base profiles can be identified using following query

select * from CLIENT_PROFILE where owner is null

 

I should also highlight that a certain profile appears in FNDRR_USER_CLIENT_PROFILE_TAB only if it is assigned to a user. Otherwise it will not show up here. So to list down all base profiles, regardless of whether they are assigned to a user or not, above query is more accurate.

You can JOIN these tables as necessary using the Profile_ID column to fetch any other data you need since it is common to them all.

Hope this helps!

Hi Charith,

Thank you so much,

This solution helps a lot.

Reply