(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic search question (Read 492 times)
wase
Junior Member
**
Offline


Always looking for a good
code

Posts: 57
Location: Austria
Joined: Jun 22nd, 2004
search question
Feb 21st, 2008 at 4:56pm
Print Post Print Post  
hi

i want to perform a search including some sub conditions like

Code
Select All
{@formresultsettotal("sub")>3}
or something like that

or
Code
Select All
{@formfieldvalue("sub","subfield",1)=formfield}
with the formfield not in the sub

maybe somebody can help me.

-sebastian
  
Back to top
ICQ ICQ  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: search question
Reply #1 - Feb 25th, 2008 at 2:30pm
Print Post Print Post  
Hello Sebastian,

Could you explain some more on what you are trying to accomplish?

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
MP
Full Member
***
Offline



Posts: 104
Joined: Sep 3rd, 2007
Re: search question
Reply #2 - Feb 25th, 2008 at 4:12pm
Print Post Print Post  
Looks to me like the queries being proposed are:

1) All records that have more than three sub-records.

2) All records whose first sub-record have a field value that matches a value in the main record.

I don't see any out-of-the-box way to do these type of queries.  They could be solved programatically using the XResultSet functions, but I hesitate to speculate what the performance would be like.
  
Back to top
 
IP Logged
 
wase
Junior Member
**
Offline


Always looking for a good
code

Posts: 57
Location: Austria
Joined: Jun 22nd, 2004
Re: search question
Reply #3 - Feb 28th, 2008 at 2:43pm
Print Post Print Post  
@mp
you are right with your statement this should be done.

but maybe i can do this with a mass update with the same code.

-sebastian
  
Back to top
ICQ ICQ  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge