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.
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.
1 of 1 people found this helpful
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.....
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?
if I remember right, you need to enclose doublequotes under two pairs of doublequotes to work with the external qualification.
" should be covered as """""
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.