devxlogo

None Specified Datawindow Retrieval Arguments

None Specified Datawindow Retrieval Arguments

Question:
I have a datawindow that will be called by two functions. The first function only uses the first retrieval argument; the second function uses all three arguments. In the first function I’d like to call the retrieve with a “*” value in the second two arguments because those arguments are irrelevant. How do I do this?

Answer:
You can achieve this in one of two ways.

First, you can build your SQL statements to OR the criteria that may not be specified. For example:

WHERE name like :as_name OR :as_name IS NULL

This will search for name when the name parameter has a value but will find all records when the name parameter is NULL.

Second, you can dynamically modify the SQL at runtime to add your criteria manually. For a large table this will give you better performance, but will take longer to code. Take a look at the Describe and Modify functions and the datawindow.table attributes if you want to do this.

See also  Monetize TikTok For Your Business
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist