Query for Scheduler is not working properly

himanshu

Dear Support Team,

We are filtering data through Query to display the results in Scheduler and found that Query is working fine in such a manner that data is getting filtered correctly but Column Headers display all the instances of corresponding BO.

Eg. If we have 4 employees with name A,B,C and D and want to display data only for A, then in Scheduler view, data of only A is being displayed however it has all the columns A, B,C,D and B,C,D are empty. We are expecting that only column A should be displayed. Please refer the image for details:

Please advice.

aware_support

This is likely to be the problem with your query, not the scheduler. How does your query look like?

himanshu

In Scheduler View of the Query Results, when we are filtering records with Implicit Data, it is being filtered, but when we are filtering data with “Ask at Run-Time” (Value/Expression), it is not working.
The Same query is working well with simple Standard view of the Query Results.
A SampleApp.bsv is being attached for the reference. Please Download the bsv from:
http://softservsolutions.com/AwareIM/SampleApp.bsv
In this sample bsv, there are two tabs on main-frame on Administrator’s VP. First represents to the scheduler view with implicit data of query result and second represents same with “Ask at Run-Time” (Value Expression). When we provide the parameters into “Ask at Run-Time”, it doesn’t work.
To explore this problem into bsv, please follow these steps:
1.) Create some customers (by Add Customer Menu-Item). There must be a customer with name “Simon” because we have used this name as Implicit Value in Query “ShowSchedulerWithImplicitValue”.
2.) Create Some Appointments (by Add Appointment Menu-Item).

By using “Customer Implicit” and “Customer RunTime” tabs on Home-Page, You can differentiate between these two (the implicit data and “Ask at Run-Time”).

Thanx for the Help.

aware_support

It's difficult to fix, so it will remain a limitation for now. As a workaround use a process that asks the user for parameters (by entering a temporary object) and then running a query that uses this object, rather than using runtime values in a query.

hpl123

Support,
Love the new vertical scheduler. Would it be possible to fix the month view so dates are displayed?