6 Replies Latest reply: Aug 17, 2010 3:06 AM by Abhishek Sukumar RSS

Table-field qualification different on different views?

Abhishek Sukumar

Hi folks,

 

There is a table field 1 in a display-only form, i have created 2 views of this display-form. I want to use the table field 1 on both the views but i want to write different 'table qualification'. How do i achieve this?

 

Thanks,

Abhi

  • 1. Re: Table-field qualification different on different views?
    Jijil Ghosh

    Hi,

     

    This can be achieve through keyword...$VUI$

     

    give the condition in your table qualification

    ($Stored Values$ = "j") AND ($VUI$ LIKE "Normal")

     

    $Stored value$  -> has the query what you need to provide or provide whatever the qualification you need and at the end put the keywords called $VUI$ equal to View name.

     

    So the table will work according to the VUI.

     

    Regards,

    Jijil

  • 2. Re: Table-field qualification different on different views?
    Abhishek Sukumar

    Thank you Jijil for your reply. I have already tried this and it doesn't work. Since, it'z the same table field utilized on the other view. Say, i m on view 1, i modify the qualification on table field 1; now i go to view 2, i modify the quailification on table field 1. I save the form after these changes i check the qualification on view 1, i see view 2 qualification and the same quailification is reflected on view 2 too.

    The reason why i m not looking to create another new table field is, the table field 1 is an in-built field of that display-only form (i m on ITSM 6.0) and it is related to several active links and guides.

  • 3. Re: Table-field qualification different on different views?
    Jitendra k Vishwakarma

    Hi Abhishek,

     

    I think you can solve the issue.. by using External Qualification in the table.

    Set the table qualification as EXTERNAL($dynamic_Qualification$)

     

    'dynamic_Qualification' can be a display only field on the form.... where u can set the desired table qualification using the set field action... as per the requirement....on different view u can set different table qualification.....

  • 4. Re: Table-field qualification different on different views?
    Abhishek Sukumar

    Hi Jitendra, appreciate your response. External operator is the way to achieve my requirement, but i m held up when i m trying to pass a qualification to a chracter field thru AL (set-field action).

    The qualification which i want to pass is

    (( 'zTmpKeyword' =  "MAINCHANGE" ) AND ( 'Status Integer' < 6)) OR (( 'zTmpKeyword' =  "MAINTASK" ) AND ( 'Status Integer' < 4))

    To pass this to a character field, i have to use double quotes in the beginning and at the end, but i get an error.

    error: unexpected character.

    I m sure this is because of the double quotes within the qualification. I tried the following ways, failed on both the occasions

     

    "(( 'zTmpKeyword' =  " + "\"" + "MAINCHANGE" + "\"" + ") AND ( 'Status Integer' < 6)) OR (( 'zTmpKeyword' =  " +  "\"" +  "MAINTASK" + "\"" + ") AND ( 'Status Integer' < 4))"

     

    "(( 'zTmpKeyword' =  " + """ + "MAINCHANGE" + """ + ") AND ( 'Status Integer' < 6)) OR (( 'zTmpKeyword' =  " +  """ +  "MAINTASK" + """ + ") AND ( 'Status Integer' < 4))"

     

    Could someone help me to accomplish this?

  • 5. Re: Table-field qualification different on different views?
    shegde

    if I remember right, you need to enclose doublequotes under two pairs of doublequotes to work with the external qualification.

     

    " should be covered as """""

  • 6. Re: Table-field qualification different on different views?
    Abhishek Sukumar

    Hi Folks,

     

    I solved the issue of passing the qualification in this manner

    ((((((((( "(( 'zTmpKeyword' =" +  """") +  "MAINCHANGE") +  """") +  ")") +  "AND ( 'Status Integer' <6)) OR (( 'zTmpKeyword' =") +  """") +  "MAINTASK") +  """") +  ")") +  "AND ( 'Status Integer' < 4))"

     

    Summing up, i created a character field with a qualification hardcoded in the default value, i used the EXTERNAL operator in my tabel field, also created a active link to chenage when navigated to another view.

     

    Check this link on EXTERNAL operator, it was really helpful.

    http://www.buoyantsolutions.net/PUBLIC/Community/EXTERNAL_viewlet_swf.html

     

    Thanks,

    Abhi