× Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...

Use of OR Condition in the Enquiry

  • kripesh
  • kripesh's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
9 years 8 months ago #16198 by kripesh
Use of OR Condition in the Enquiry was created by kripesh
How do I check for OR condition in my build routine for my Enquiry ?

For Eg. In the Selection Criteria window the USER will have fields SECTOR and CATEGORY to be INPUT. Then I will add the following in my build routine...

Check if NATIONALITY EQ ''US'' OR NATIONALITY EQ ''GB'' also for the above criteria. .

Please note ::: I will not have the field NATIONALITY in the SELECTION.FLDS of my Enquiry.

Have a great day !

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
9 years 8 months ago #16206 by jpb
Replied by jpb on topic Use of OR Condition in the Enquiry
If this is to be applied on every launch of the enquiry I would either :

- do a first SELECT on the file with this clause and use the active list for the final selection (depends on the size of the underlying file and the speed of the selection, also an index might help)

OR

- just place the clause at the beginning of the selection with proper bracket to be able to append the Sector / Category from user input.

Please Log in or Create an account to join the conversation.

  • kripesh
  • kripesh's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
9 years 8 months ago #16209 by kripesh
Replied by kripesh on topic Use of OR Condition in the Enquiry
Thanks jpb.

So there is no other COMMON Variable available to get this OR inserted.

Have a great day !

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
9 years 8 months ago #16212 by jpb
Replied by jpb on topic Use of OR Condition in the Enquiry
As normally an "OR" is input as multivalues in the selection screen and can be used in JQL as such I never searched for such a way, neither have I heard of any.





LIST Fxxx.CUSTOMER WITH NATIONALITY EQ "US" "GB" NATIONALITY
Attachments:

Please Log in or Create an account to join the conversation.

Time to create page: 0.119 seconds