I'm having trouble filtering leads using the `$title` field. When I use the following query: https://{{server}}/sdata/{{install}}j/sagecrm2/-/Lead?startindex=1&count=10&where=$title eq 'newsletter'
It shows all the leads instead of filtering. Then I…
Hi there,
Im trying to filter a field based on CHOOSE as I read on greytrix ( http://www.greytrix.com/blogs/sagex3/2014/08/31/adding-selection-window-for-any-action/ )
My code is working but If I use the search (as highlited in the screenshot…
Is it possible to filter a left list so only records I want the user to see appear?
i.e. Only show records that the user has access to, or only show records that have a creation date < 14 days etc?
So we can have 'All requests', 'my requests' and…
Hi,
Imagine I have a button called "FILTER" in GESITM and I want it to filter left list so that it shows all the products that have "TCLCOD = 'ST'". How should I do it?
Best Regards
Hi there, I saw that there were other posts on this topic but I didn't see a solution and the posts were old.
I'm wondering if it is possible to change the default Date Range for the Item Inquiry. I desire to always see all the transactions when I…
In my object, the main table is STOCK and under the environment tab, I linked the itmmaster table. When I write my code to get the itmmaster table linked, it will not link. Everything works when I use the STOCK table, but when I try to use the ITMMASTER…
Hi all,
I'm trying to use the "AQUERY_CRITERIA_AFTER" event, in a mobile representation. My only problem here is that the property "THIS" is not available, and because of that i can't use values from the main screen.
Do you know how can i solve…
Hi there,
When I filter a left list in a specific with CRITERE, the filters imputed by the user are ignored.
I'm trying to filter left list in a specific.
This is my code:
$CLE_GAUCHE Default File [YCRG] If currbox = "GAU_CHE1" CRITERE = …
Hi,
Could someone point me in the right direction. I need to filter the left list for the product master based on the users fictional profile site access.
I am using the CLE_GAUCHE action and FUTERSUP. Using one condition is not a problem but…
Hi,
I need to filter the products selection list when using itemref field in the POH2 screen. The table and field [F:ITM]CCE(0) contains the products linked to the order site. I want to show only products where [F:ITM]CCE(0) = [M:POH0]POHFCY
Could…
I would like to make a filter returning the record with me max value, is there a way to do that?
In SQL I use this:
select MAX(NUM_0) from PINVOICE
Just a example, how I can do that in X3?
Does anyone know how to use relative dates like TODAY or NOW or SYSTEMDATE or something that I can use in my sales order lookup window to create a custom lookup that only shows orders that have a ship date that is less than today or less than tomorrow…