HI all,
I need to write a query that will extract some events with system custom fields (items).
I found some exemples here on the wiki, but not regarding item system custom fileds
Can anyone help me?
thanks!
Solved
query events with system custom fields (items)
Best answer by MennovH
The following can be used to get the selected items from custom fields that are lookups to the item table. Just replace PLACE_HOLDER with the shortcode of the custom field you want to extract.
(SELECT i.item_n FROM item i,
jptsys_web_cust_prop_cont c,
jptsys_web_cust_prop jwcp
WHERE i.item_id = c.lookup_val_id
AND jwcp.jptsys_web_cust_prop_id = c.jptsys_web_cust_prop_id
AND jwcp.jptsys_web_cust_prop_sc = 'PLACE_HOLDER'
AND c.entity_id = incident.incident_id)
Regards,
Menno
The following can be used to get the selected items from custom fields that are lookups to the item table. Just replace PLACE_HOLDER with the shortcode of the custom field you want to extract.
(SELECT i.item_n FROM item i,
jptsys_web_cust_prop_cont c,
jptsys_web_cust_prop jwcp
WHERE i.item_id = c.lookup_val_id
AND jwcp.jptsys_web_cust_prop_id = c.jptsys_web_cust_prop_id
AND jwcp.jptsys_web_cust_prop_sc = 'PLACE_HOLDER'
AND c.entity_id = incident.incident_id)
Regards,
Menno
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.