Defining a User-Specific Query - Intergraph Smart Materials - Version 10.2 - Administration & Configuration - Hexagon

Intergraph Smart Materials Classic Administration (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Materials/Smart Reference Data Version
10.2

You can use the function m_pck_ewn.usr_id in your query to create a user-specific alert. This function can be used for any column that corresponds to the User field of A.20.05 User. When the alerts are processed, the current alert user for whom the alert is generated will be returned by this function.

The value of this function is not defined outside of alert processing.

Example of the Query Text value for a user-specific query:

select i.inq_code, i.i_supp, inqn.short_desc, i.bid_req_return_date, i.inq_id

from m_inquiries i,

m_inquiry_nls inqn

where i.inq_id = inqn.inq_id

and inqn.nls_id = 1

and issue_date is not null

and po_buyer = m_pck_ewn.usr_id

and proj_id = 'XYZ'

order by 1,2