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?
                  Seema Hegde

                  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