Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Pagebuilder Plugin: How to specify complex conditions?

Quote Reply
Pagebuilder Plugin: How to specify complex conditions?
Can't figure out the correct syntax for adding a new page record with more than one condition, eg: Visible eq 'Yes' AND Priority eq '1'.

They work OK separately, but how do we string them together?
Quote Reply
Re: [YoYoYoYo] Pagebuilder Plugin: How to specify complex conditions? In reply to
Actually, I am surprised that

Visible eq 'Yes'

works. In principle, you should use an SQL-like statement, e.g.

Visible = Yes

(no quotes). If you want to use the condition you mentionnend, then you would have to write

Visible = Yes Priority = 1

Technical note: the whole string is split on whitespace, and the resulting arguments are then used as arguments of a GT::SQL::Condition object. If an argument starts with a backslash, the argument (without backslash) will be referenced. You can use SQL type operators, e.g. LIKE. So

FirstName LIKE Alex%

will be translated into

GT::SQL::Condition->new('FirstName', 'LIKE', 'Alex%');

I hope this makes sense.

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [yogi] Pagebuilder Plugin: How to specify complex conditions? In reply to
Thanks yogi ... I got it now.
Quote Reply
Re: [yogi] Pagebuilder Plugin: How to specify complex conditions? In reply to
Hi

I try to specify my page condition

I have tried

ID > 900 ID < 1000


it doesn't work, it just apply th first one (ID > 900) , the second condition is not respected

Where am I wrong...

txs
FMP
Quote Reply
Re: [fmp] Pagebuilder Plugin: How to specify complex conditions? In reply to
Unsure yogi...are you here??

txs
Quote Reply
Re: [yogi] Pagebuilder Plugin: How to specify complex conditions? In reply to
Hi yogi

I need to build detailed pages for a special range of IDs (all the IDs between 800 and 900)

could you give me the exact condition I have to put in the dedicated field

ID > 800 ID < 900 doesn't work !!!!! It builds all the links over 800 !!! Unsure

need help
txs
FMP
Quote Reply
Re: [fmp] Pagebuilder Plugin: How to specify complex conditions? In reply to
This seems to be a bug. I'll have a look at it.

Ivan
-----
Iyengar Yoga Resources / GT Plugins
Quote Reply
Re: [yogi] Pagebuilder Plugin: How to specify complex conditions? In reply to
hi

did you find a solution?

was is really a bug ?... I was loosing my mind trying to resolve it myself....




Txs
Quote Reply
Re: [yogi] Pagebuilder Plugin: How to specify complex conditions? In reply to
Hi Yogi

Are you dead ? ;)

I really need your help, have seen how to build a range of links ?

condition I try have put in the condition fiel (but it is not working)
ID > 800 ID < 900

Txs
FMP
Quote Reply
Re: [yogi] Pagebuilder Plugin: How to specify complex conditions? In reply to
hi

does anynone knows where yogi is ? I have bought his plugin and i really need his help concerning a bug about "How to specify complex conditions?".

Regards
F M P
Quote Reply
Re: [yogi] Pagebuilder Plugin: How to specify complex conditions? In reply to
hi Yogi
I've seen that you were back on the forum....do you have a solution concerning my problem

regards
F M P
Quote Reply
Re: [yogi] Pagebuilder Plugin: How to specify complex conditions? In reply to
Hi yogi

Could you PLEEEEEEEEEEEEEEEEEEEEEEEEEEEEASE Wink answer my question....

Txs
FMP
Quote Reply
Re: [yogi] Pagebuilder Plugin: How to specify complex conditions? In reply to
Hi

You're back on the forum...Wink

Could you (at lasssssssssssssssssssssst pleeeeeeeeeeease) answer to me concerning the bug when I try to specify complex conditions in your PB plugin

Txs
FMP