Highlighted
Absent Member.
Absent Member.
109 views

OVSD 4.5 - Anyone know SQL to list Mandatory Fields?

Jump to solution
Hi all - does anyone have a SQL query that will list all mandatory fields including statuses for an entity?

I have to revamp statuses in several modules, and it's very difficult to go thru every field in every module to see which statuses they are mandatory for (if any).

My email is kenilian@bigpond.com.au
0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.
Absent Member.

Re: OVSD 4.5 - Anyone know SQL to list Mandatory Fields?

Jump to solution
Here you are

select ent.ent_name as 'Entity', atr.atr_name as 'Attribute', rct.rct_name as 'Status'
from rep_attr_per_status aps inner join ifc_attributes atr on aps.aps_atr_oid=atr.atr_oid
inner join ifc_entities ent on atr.atr_ent_oid=ent.ent_oid
inner join rep_codes rcd on aps.aps_cod_oid=rcd.rcd_oid
inner join rep_codes_text rct on rcd.rcd_oid=rct.rct_rcd_oid
where rct.rct_lng_oid=1033
order by ent.ent_oid,rcd.rcd_ordering, aps.aps_atr_oid asc

Notice that you may have to change rct_lng_oid if you want other language than english.
menes fhtagn

View solution in original post

0 Likes
5 Replies
Highlighted
Absent Member.
Absent Member.

Re: OVSD 4.5 - Anyone know SQL to list Mandatory Fields?

Jump to solution
Here you are

select ent.ent_name as 'Entity', atr.atr_name as 'Attribute', rct.rct_name as 'Status'
from rep_attr_per_status aps inner join ifc_attributes atr on aps.aps_atr_oid=atr.atr_oid
inner join ifc_entities ent on atr.atr_ent_oid=ent.ent_oid
inner join rep_codes rcd on aps.aps_cod_oid=rcd.rcd_oid
inner join rep_codes_text rct on rcd.rcd_oid=rct.rct_rcd_oid
where rct.rct_lng_oid=1033
order by ent.ent_oid,rcd.rcd_ordering, aps.aps_atr_oid asc

Notice that you may have to change rct_lng_oid if you want other language than english.
menes fhtagn

View solution in original post

0 Likes
Highlighted
Absent Member.
Absent Member.

Re: OVSD 4.5 - Anyone know SQL to list Mandatory Fields?

Jump to solution
Hi George - that is perfect and will save me so much time. Thanks....and thanks for some of your earlier beautiful SQL that I still use regularly.
My email is kenilian@bigpond.com.au
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: OVSD 4.5 - Anyone know SQL to list Mandatory Fields?

Jump to solution
See George's SQL command above
My email is kenilian@bigpond.com.au
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: OVSD 4.5 - Anyone know SQL to list Mandatory Fields?

Jump to solution
I'm glad that this helped... giving me some points would be nice, though.
menes fhtagn
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: OVSD 4.5 - Anyone know SQL to list Mandatory Fields?

Jump to solution
Sorry George...I did give you 10 points but it didn't register. have just tried again
My email is kenilian@bigpond.com.au
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.