You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Mahbub Al-Amin <ma...@commlinkinfotech.com> on 2015/04/23 07:23:11 UTC
Info regarding Appointment completed or not
Hi Maxim,
Is it possible to determine which appointments have completed from database
tables? I tried but failed.
Thanks.
Regards,
mahbub
<http://www.commlinkinfotech.com>
Re: Info regarding Appointment completed or not
Posted by Maxim Solodovnik <so...@gmail.com>.
It is possible only in case appointment was scheduled in special
appointment room, The query will be tricky :)
On Thu, Apr 23, 2015 at 11:56 AM, Mahbub Al-Amin <
mahbub@commlinkinfotech.com> wrote:
> Actually, i wanted to know Number of expired conferences (scheduled but
> did not held).
>
> Thanks.
>
> Regards,
> mahbub
> <http://www.commlinkinfotech.com>
>
> On Thu, Apr 23, 2015 at 11:50 AM, Maxim Solodovnik <so...@gmail.com>
> wrote:
>
>> something like this: SELECT * FROM openmeetings_3_0.appointments where
>> appointment_endtime < NOW() ORDER BY appointment_endtime; ?
>>
>> On Thu, Apr 23, 2015 at 11:23 AM, Mahbub Al-Amin <
>> mahbub@commlinkinfotech.com> wrote:
>>
>>> Hi Maxim,
>>>
>>> Is it possible to determine which appointments have completed from
>>> database tables? I tried but failed.
>>>
>>> Thanks.
>>>
>>>
>>> Regards,
>>> mahbub
>>> <http://www.commlinkinfotech.com>
>>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>
>
--
WBR
Maxim aka solomax
Re: Info regarding Appointment completed or not
Posted by Mahbub Al-Amin <ma...@commlinkinfotech.com>.
Actually, i wanted to know Number of expired conferences (scheduled but did
not held).
Thanks.
Regards,
mahbub
<http://www.commlinkinfotech.com>
On Thu, Apr 23, 2015 at 11:50 AM, Maxim Solodovnik <so...@gmail.com>
wrote:
> something like this: SELECT * FROM openmeetings_3_0.appointments where
> appointment_endtime < NOW() ORDER BY appointment_endtime; ?
>
> On Thu, Apr 23, 2015 at 11:23 AM, Mahbub Al-Amin <
> mahbub@commlinkinfotech.com> wrote:
>
>> Hi Maxim,
>>
>> Is it possible to determine which appointments have completed from
>> database tables? I tried but failed.
>>
>> Thanks.
>>
>>
>> Regards,
>> mahbub
>> <http://www.commlinkinfotech.com>
>>
>
>
>
> --
> WBR
> Maxim aka solomax
>
Re: Info regarding Appointment completed or not
Posted by Maxim Solodovnik <so...@gmail.com>.
something like this: SELECT * FROM openmeetings_3_0.appointments where
appointment_endtime < NOW() ORDER BY appointment_endtime; ?
On Thu, Apr 23, 2015 at 11:23 AM, Mahbub Al-Amin <
mahbub@commlinkinfotech.com> wrote:
> Hi Maxim,
>
> Is it possible to determine which appointments have completed from
> database tables? I tried but failed.
>
> Thanks.
>
>
> Regards,
> mahbub
> <http://www.commlinkinfotech.com>
>
--
WBR
Maxim aka solomax