Show Records basis a Field Value

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
uchhavi
Veteran Member
Posts: 80
Joined: 2018-05-15 14:07

Show Records basis a Field Value

Post by uchhavi » 2018-05-30 07:39

Hi,

I have 2 questions:

Question 1
We have dealers from 6-7 countries... When the dealers open the system from their login, I was them to see records belonging to their country only-

I have a company_tb and a company_contact_tb and the both have a field named Country.

Question 2

I have a tables called Purchases and in that i have a field company... in the company field dropdown I want to show data, where the User Category (another table) User_Id = 'Supplier' and also in another I want to show all company records where the user category is NOT suppliers.

How to solve these. Please help
Best regards,

Chhavi Jain

R Tammam
Veteran Member
Posts: 113
Joined: 2017-08-26 15:35

Re: Show Records basis a Field Value

Post by R Tammam » 2018-06-04 00:24

Hello Chhavi Jain,
could you please mention company_tb and company_contact_tb fields please

uchhavi
Veteran Member
Posts: 80
Joined: 2018-05-15 14:07

Re: Show Records basis a Field Value

Post by uchhavi » 2018-06-04 15:30

country_id which it picks from the country_tb in both the company_tb and company_contact_tb

can u please help?
Best regards,

Chhavi Jain

R Tammam
Veteran Member
Posts: 113
Joined: 2017-08-26 15:35

Re: Show Records basis a Field Value

Post by R Tammam » 2018-06-05 00:44

i think you should use addFilter() function to apply filters for what you want to show
and here's it's AppGini documentation
https://bigprof.com/appgini/tips-and-tu ... ult-filter
i hope it would help you

uchhavi
Veteran Member
Posts: 80
Joined: 2018-05-15 14:07

Re: Show Records basis a Field Value

Post by uchhavi » 2018-06-05 05:58

i think what you have told me is for the new entries in the table...

how about the old table? or the existing data? will this work there as well?
Best regards,

Chhavi Jain

R Tammam
Veteran Member
Posts: 113
Joined: 2017-08-26 15:35

Re: Show Records basis a Field Value

Post by R Tammam » 2018-06-06 02:52

uchhavi , could you please tell make data you really want until i could help you , i might misunderstand you

Post Reply