Topic
2 replies Latest Post - ‏2013-08-20T08:16:08Z by ITUser
ITUser
ITUser
35 Posts
ACCEPTED ANSWER

Pinned topic How to create VIEW object(database configuration) to display Query-column

‏2011-10-25T07:12:52Z |
Hi,

Kindly help me solving following issue and guide me how to do it?

Requirement: I want to create VIEW object(database configuration) to Dislay my required column 'GRACEPERIOD' -
(customized/non-MBO/userdefined/Select column) in Work order Application.

Summary: The 'GracePeriod' column automatically displays value(as mentioned in Select-Query) in PM-workorders

based on pmnum(where pm.pmnum=workorder.pmnum)

Select-Query:

select PMNUM,FREQUNIT,FREQUENCY,
case
when frequnit='DAYS' AND frequency=1 THEN 5
when frequnit='DAYS' AND frequency>1 THEN 10
when frequnit='MONTHS' AND frequency=0 THEN 5
when frequnit='MONTHS' AND frequency>1 THEN 10
when frequnit='WEEKS' AND frequency=1 THEN 5
when frequnit='YEARS' THEN 10
ELSE 0
END GRACEPERIOD
FROM PM
WHERE STATUS='ACTIVE'

Details: (what I configured in Database configuration application to view object)


>> Object=TEST (view of Grace Period to complete the job
each work order which contains pm-job plans)
>> Service=CUSTTAPP
>> Description=Custom Application Service
>> Entity=TEST
>> Class=psdi.mbo.custapp.CustomMboSet
>> Extends Object=PM
>> Level=SYSTEM
>> View=Truc(Ticked)
>> View Where=STATUS='ACTIVE'
>> Join to Object=NULL(Blank)
>> view Select =
PMNUM,FREQUNIT,FREQUENCY,
(case
when frequnit='DAYS' AND frequency=1 THEN 5
when frequnit='DAYS' AND frequency>1 THEN 10
when frequnit='MONTHS' AND frequency=0 THEN 5
when frequnit='MONTHS' AND frequency>1 THEN 10
when frequnit='WEEKS' AND frequency=1 THEN 5
when frequnit='YEARS' THEN 10
ELSE 0
END) GRACEPERIOD

>> Automatically Select?
>> View From = PM
Waiting for your prompt reply.

Regards
Shah
  • amir_samir
    amir_samir
    158 Posts
    ACCEPTED ANSWER

    Re: How to create VIEW object(database configuration) to display Query-column

    ‏2013-08-20T07:45:53Z  in response to ITUser

    Hi Shah,

    Have you got any updates about this , i'm kind of in the same situation.

     

    BR,

    • ITUser
      ITUser
      35 Posts
      ACCEPTED ANSWER

      Re: How to create VIEW object(database configuration) to display Query-column

      ‏2013-08-20T08:16:08Z  in response to amir_samir

      Hi Amir,,

       

      No answer yet given by anyone on forum.

      Still waiting ...!

       

      Regards

      Shah